Crystal Report Questions

building reports crystal reports
1

Hello Experts,

Couple of questions in Cyrstal reports…

1.) If there is a “SUMIF” command in Excel. How can we simulate them in Crystal??

2.) When should you choose the fields directly from the Database, and when should you use the Command feature? What are the pros and cons of each??

Could you Please answer to these questions ASAP that would be a great help…

Thanks in Advance…

listener (BOB member since 2011-04-26)

2

2.) When should you choose the fields directly from the Database, and when should you use the Command feature? What are the pros and cons of each??
-------Using “Command” you can write your own sql for data/data manipulation.

anil.ganga1 :us: (BOB member since 2007-07-04)

3

  1. Yes and no. You can create a running total that only gets evaluated on certain conditions, you can create a formula using shared variables to act like the SUMIF, but there is no SUMIF function in crystal.

  2. The command feature (as stated by listener), you can more control what fields are seen by the report (and if you are really good with SQL, can do some neat tricks). Also if you have a where clause in your command, then you will not be bringing in all the rows into crystal for it to process. Using the tables and linking fields is faster and easier to understand for development. But normally the report will process faster with a command.

I hope this helps.

kevlray :us: (BOB member since 2010-06-23)

4

Thanks guys for your promt answer…

Could you answer to this question briefly…

How do you tell Crystal Reports that one field in one table is connected to one field in another table??

Thanks in Advance…

listener (BOB member since 2011-04-26)