Empty Report

[ilanit]

VB, Crystal, SQL Server2000

Ok here goes....
I have users hitting the SAME Crystal reports through a VB app...I have one user that for some reason when they open the reports they get an empty report or old/invalid data. In other aspects of the application she is able to get data via ADO...when opening the crystal report is connects through the ODBC...I checked to see that her ODBC driver was the same version as the people who are working, and it is, i also checked to see that her permissions are the same as the rest of the users on the database and they are....does anyone have any idea why my one user can't see the data via crystal reports...????? please help...I am having nightmares about this!....i wan't to sleep =o)

 

[Naith]

Firstly, and I guess fundamentally, you need to ensure that your user isn't looking at a report with saved data in it. As you say other users are getting results, this might not be the problem - but as this problem is so weird, check it out anyway.

Ultimately, if the Crystal Query is corrupted on this users machine, try the following:
1. Copy the contents of the SQL from the Query in the SQL Designer.
2. Create a brand new Query in the SQL designer.
3. Delete the old query from the SQL designer.
4. Name the new query to the same name as the old one.
5. Open and refresh the report in CR 7 MR1.

- If Save Data with Query is not selected from the File menu in the SQL Designer and the Query is saved when the queries parameter field value returned no data, complete the following steps to resolve the issue:

1. Refresh the query.
2. Save the query when at least one record has been returned.

This is an odd one, though, so if anyone else has any heals at hand, I for one would like to see 'em.

Keep us posted, Ilanit.

 

[synapsevampire]

If there isn't an error being displayed, and you've reinstalled your app, the user does NOT have another version of Crystal installed...

If you have another means to query the database from that client (Query Analyzer, Excel, Access, etc.), try executing the same SQL and see what it returns.

OR

Try creating an .exe using Crystal of just the report and running it on that box, providing you have a verion of Crystal to do so.

I'd be suspect that your app or the report is different on that client, or that they're doing something different with their parameter entry (perhaps even a local machine setting).

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[ilanit]

Hey Naith and synapsevampire
Thanks for your input....I have some more bizarre info....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
One:
I logged into SQL Server Query Analyzer with my users ID and was able to successfully execute a stored procedure from one of the reports
this rules out it being a problem with SQL Server2000 log in
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Two:
Needless to say on my PC with my NT login and DB login everything works...so I decided to log into Windows NT on my PC as my user...so now, on my PC logged in as her running the app I get an empty report....
this rules out it being a problem with her PC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I'm thinking it might have something to do with her NT login??? Could that be possible??
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Anyway....any thoughts let me know...everyone I ask here is stumped!.........thanks for your time

 

[synapsevampire]

It sure sounds like a user account problem...

I don't do VB->Crystal anymore (been a couple of years), perhaps Ken Hamady can help. Ken???

He has some FAQs on his site, have a look:

http://www.kenhamady.com/

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com