September 9, 2011 at 12:58 pm
We've been running a Crystal report for years. It has been quite reliable until recently.
2 key fields that used to appear on the report are missing. We use 3 SQl tables for the report and each one has a single row of data. One of the data elements is present in one of the tables but no longer appear in a grid that was designed for the report.
The second field is not present in any of the tables. I thought it might be a formula but that is not so.
We use version 7 of Crystal Reports. Please don't laugh. I am not an expert in Crystal so any hints on how to display the fields in the grid or find the missing field would be appreciated. You would have my gratitude.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
September 9, 2011 at 1:07 pm
I would first look at how the tables are joined (if they are). If so, make sure that a key hasn't been broken somehow. Whatever Crystal is trying to do, make it happen in SQL (assuming you have access).
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
September 9, 2011 at 3:18 pm
Thanks. The user needed training. She was running the wrong report. I think I found those demons of stupidity!
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
September 9, 2011 at 3:25 pm
Well, at least you found the solution. 'Hope you can upgrade Crystal soon. 😉
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply