on 01-23-2015 3:16 PM
I am using VS2010 and Crystal Reports Version 11R2 SP8
I have noticed a weird feature in crystal reports and was wondering if anyone has noticed. (has a work around for)
When you refresh a report it brings up the parameter prompt at first with the default values but after that it will use the last used parameters so if you just wanted to do a quick refresh of data you can.
This works as expected on reports that are not saved.
HOWEVER
on reports that have saved data the first time you refresh the values that are shown are not the currently used parameters they are in fact the defaults or blank if no default is set.
After this first initial time it works as expected until you close and open the report again.
I have also noticed this in a test application with only code to log into the report.
Are you using .NET or the RDC?
Discard Saved Data for the RDC, in the .NET viewer click on the Viewers property page and select the appropriate Parameter Prompt refresh setting.
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Luke,
Can't explain it with the info I have then... If not all parameter values are filled in and valid that would clear the list... maybe...
See if this post helps: View the full discussion
Don
Hey Don,
I just had a look however i don't think that thread is relevant.
I am going to attempt to demonstrate the issue i am having with pictures. if it works.
OK so i load a report that has saved data into the viewer and connect to the database in this example the reports parameters is 2 date fields.
The dates used are printed at the top of the report so you can easily see.
So as you can see the date range is 01/01/2015 - 31/01/2015
When i click Refresh for the first time this is the parameter screen i see:
As you can see the previously used parameters are not present.
so i enter new parameters and click OK
as you can see this time the date range is 06/11/2014 - 09/12/2014
When i click refresh this time the parameters fields are populated with the current values.
I hope this makes it clearer.
Hey Don,
Its not the default value that isn't appearing, in fact the default value appearing is part of the issue in some regards.
When we are loading a saved report that has parameters already entered, when pressing the refresh button we are either shown nothing or the default value.
Are you saying on open of the report to overwrite the default values? isn't this a bit backwards? as the parameter screen should (as it does in any other circumstance) pick up the current values.
Hi Luke,
I've been testing this all day trying to find how to get that value....
In debug mode you can get it but the property is not exposed.
Here's one of the collections:
Bottom line is I don't think we can get to the saved value and/or this is by design.
I have to ping DEV and ask them if they know of a supported way to not clear the value.
Don
Yes I can see it now, must have been a replication delay.
R&D confirmed this has not worked since CR 2008 days so they are investigating.
Ideally we want to use the Viewer Parameter Collection to get the values so we don't have to use the Engine - ClientDocument or RAS - ReportClientDocument to get it.
I'll create a case and get them to officially drill into the issue.
Incident 94205 / 2015 / Saved data not display Param Value on refresh
Thanks again
Don
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
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.