Crystal Reports+CPU Performance

Hi all
I am to actually integrate different sub reports into the main report.
I was able to solve the problem of linking the sub report parameter fields to the main report.This particular link of msdn helped me

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/crystlmn/html/crtskinsertingsubreports.asp

I am linking the parameter field value of the main report to that of the sub report using the above method.
But my application's performance is going very slow..The cpu usage of the application is almost 100%.I think its because of the double reference that this happens.Reference I mean,the main reports parameters should link to the subreport and then print the data,I guess its this reason that makes the performance go poor.
Can anyone help mein giving any ideas of improving the CPU performance ?

Thanks in advance.How long does it take to print the data?

Crystal Mandatory Fields

Hiya,

I'm writing a crystal report linking with an Access Database.

basically I need to say If Address line1 = "" then display section A if not, do nothing,

but I have to do this for about 30 fields, How would i go about doing this?

Basically, it picks up data from the database,If everything is filled in when the report is run, the report orints out fine, if something is blank or a null value then it will pick up details section B which will say "The following fields need to be filled in" and then it will list the fields?

Any ideas

Thanksif you want to suppress whole section A if addressline ="" then right click on section A -> format section -> there is a button beside suppress text click on it and write down:
if addressline ="" then true else false

It will suppress that section and if you want to suppress some fields only then you have write this on each and every field in design view and for that you have to right click on that field -> formate field -> and here also same you have to write "if addressline ="" then true else false" in suppress button script.

Best of Luck|||better use

if isnull(addressline) then
true
else
false

Cross Database Join in a Data Source View

Hi,

Is it possible to do a cross database join in a report services data source view? It doesn't look like it.

If not I was thinking of linking the table into the other database.

TIA,
Darren

Hello Darren,

Yes, you can do joins to other databases.

For example:

select table1.col1

from db1.dbo.table1 t1

inner join db2.dbo.table2 t2 on t1.col1 = t2.col2

Jarret

|||In the interest of reuse I would like to reference two Data Source Views in the Model. I have a database that has static database for everyone and a separate database for every customer? Is that possible?|||If I add a related table from another database the model blows up when I autogenerate and says it can't find dbo.Table. It shouldn't be dbo.Table it should be database.dbo.Table. If I explore the data it works fine.