Results Differ Between Crystal Reports and Infoview

[Former Member]

I have created a report in Crystal using a SQL command.  When I run the SQL in SSMS, the results set displays 189 records. When I create the report in Crystal, the Crystal report displays 189 records. However, when this report is published to Infoview, the report suddenly displays duplicate records (384 to be exact).  Has anyone experienced this behavior before?  If so, any ideas on how to resolve it?

[Former Member · Accepted solution]

Well, I solved my own issue.  The report uses views with embedded security. When the report is run in Crystal it passes my user name the database and verifies record level security. When it is run in InfoView it is using an unattended account with different security rights.

I simply needed to modify my original query to account for the differences in security when executing the report in different environments.

[Former Member · Accepted solution]

Thank you so much for sharing the solution.

[Former Member]

Hi,

Please re-post this thread into

--DJ