on 08-17-2017 9:28 PM
I have an existing Crystal Report that I feed data into from a stored procedure on MSSQL DB. I recently added a new column and new values on a case statement inside stored proc (MSSQL server side). I hit refresh button on crystal reports page. The only one value showed when I selected browse data on the column. I went into database expert and to command to re-execute the proc. I hit refresh on the column that has the new data. Once I did that I right clicked on the column and selected browse data. The only value there was the last 'new' value on my case statement from my stored procedure. I did verify the data from the database side and everything was fine there. Afterward running out of options I recreated the stored proc and tried the report again. I was unable to see the other values. Any suggestions?
Within Crystal click on Database and Verify Database, see if that works.
What happens if you create a new report, do you see the new info?
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I did verify the database but I still can only see the last value of the case statement below (>365):
-- it ran fine prior to adding the last three values below
Here is the browse data from crystal
When I went to create a new report I still was only able to see >365 value. I even restarted the PC.
I also removed the last three values from when the problem started. I verified the DB and no data came back for that column.
Strange, likely something server side...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The data reappeared on the crystal report but I have no idea why it disappeared
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.