Showing results for 
Search instead for 
Did you mean: 

crystal reports show only one value for the invoice

Former Member
0 Kudos

Dear all,

          a   I have created a crystal report for bank payment voucher. where i need to get the invoice date, invoice amount, payment total, vendor number and many fields like that.  But when i execute the report it fetches only one value always.could anyone suggest me what should be done in order to get all the values which are there in the data base.



Accepted Solutions (0)

Answers (2)

Answers (2)

Active Contributor
0 Kudos

Hi Akram,

What database are you reporting against?

To add to Sastry's suggestions, I would also recommend copying the SQL Generated by CR and running it on the Database (Go to the database option > Show SQL Query).


Active Contributor
0 Kudos

Hi Ali,

You said you are getting only one value i.e only one record you are getting or out all fields only field is displaying value ?

Go in File--Report Options--and check 'Convert Database NULL values to default' & Convert other NULL values to default and try

Also check you have any filter conditions applied through Report--Selection Formulas--Record.

Also check in section expert you have any suppress conditions.

Is this report is based off tables or Add command, if it is tables check joins between tables.  If it is Add command try to execute the SQL at database end and see whether you are getting any records or not.