I want to make formula in business Intelligence Project

Hi Friends,
I want to make formula in business Intelligence Project like as we make
formula in Crystal report.
Thanks,
AlexWell if I understand your question correctly you want to convert a Crystal
formula to RS. I had a lot of trouble with this as well and without doing
custom code that I'm not experienced with you are going to have to move to
single line vb .net functions in order to get your functionality.
The one that I have used the most is the =Iff statement as it lets you test
and chose 2 results and you can nest them inside each other. Here is a link
to the Microsoft MSDN Reference and some text from the link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctiif.asp
Visual Basic Language Reference IIf FunctionReturns one of two objects,
depending on the evaluation of an expression.Public Function IIf( _
ByVal Expression As Boolean, _
ByVal TruePart As Object, _
ByVal FalsePart As Object _
) As ObjectExampleThis example uses the IIf function to evaluate the TestMe
parameter of the CheckIt procedure and returns the word "Large" if the
amount is greater than 1000; otherwise, it returns the word "Small".Function
CheckIt (ByVal TestMe As Integer) As String
CheckIt = IIf(TestMe > 1000, "Large", "Small")
End FunctionGood luck,Dan"Alex Smith" <sam@.gmail.com> wrote in message
news:ODPzlaGfFHA.2372@.TK2MSFTNGP14.phx.gbl...
> Hi Friends,
> I want to make formula in business Intelligence Project like as we make
> formula in Crystal report.
> Thanks,
> Alex
>

i need to create a report by using 5 databases

let me put it little more deatail,
i'm using crystal report XI,
I have 5 database servers and i need to make a report on the table which is common among all 5 DB's.
sample.
employ,
empnum, empname,.......
pls some one help me out hereIf all databases exist on the same server, then you can reference the tables directly and do joins on them like this:

select ....
from DB1.dbo.Table1 AS d1t1
inner join DB2.dbo.Table2 as d2t1 ON d1t1.ID = d2t1.ID
...

What you need to do is create a view, to be used as a table for Crystal Reports. Then when you "select * from" the view, it will query each of the databases as defined in the view.

If the databases exist on a different server, u should consult your administrator about setting up a link. Not all database systems support linked databases. When you query a table from a linked database, expect it to be very very slow, since it has to copy the tabledata across the network before the join can begin.. so depending on the query, u may end up copying the whole table from each database, as temporary data, every time the report executes.

To speed this up, you could replicate the necessary data into the report database, either with some kind of replicator or by scheduling a daily process to get the new data to be used. Then its a local table you are querying or joining against.

Does this answer your question?

I need Crystal report Tutorial in PDF form

Hi all,
I need Crystal report Tutorial in PDF form. So please send me the website address or otherwise please send me if any body having tutorial.
Bye,
R.Ragupathi.Refer this
http://support.businessobjects.com/library/docfiles/cps10/docs_en.asp

Madhivanan