Hi,
i am working on Migration of VB windows application to VB.Net. It contains Crystal Reports coded using CRPEAuto.dll. I have upgraded them using latest Crystal Decision dll's.
I am Using the same .prt files(Design is not changed) , and fixed some Formula issues. Now, Crystal reports are
working as expected. I am executing the Dynamic query and binding the resultant Dataset table to the ReportDocument.
But, i have an issue with data being loaded on reports. The resultant Dynamic SQL query output and the data which
is being shown on reports are not same. I am getting Duplicate rows.
Expected Data:
Ord_ID TO_Symbol From_Symbol
1 A --
2 B --
There is no data For From_Symbol field.
Actual Report Data:
Ord_ID TO_Symbol From_Symbol
1 A A
1 A B
1 B A
1 B B
2 A A
2 A B
2 B A
2 B B
We have Joins in SQL query. The resultant DataSet is getting 2 rows as expected . It seems, there was some
outer join happen with in the report data(To_Symbol and From_Symbol) before showing the data.
I have tried in google, but now able to find the exact settings (or) Changes need to be done.
Please help me in finding the issue.
Thanks in Advance.
Kiran Samudrala
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.