Crystal Reports Viewer 2011 Parameter Change Greyed Out

[Former Member]

Hi All,

I've recently been given the responsibility of modifying and updating reports as another employee left the organization. Unfortunately, I have no experience with CR. We ran into an issue with a report. The report is made up of several subreports all pointing to one database. Most seemed to have errors so I recreated the subreports and verified the issues were resolved. I then added them to the main report and thus far there are no errors.

My current issue is that when attempting to view this report in CR Viewer the button used to change the parameters is greyed out. All subreports can have the parameters modified, but the main report does not allow this.

What I've done:

1. Made sure all the subreports and the main report I allowed editing of the parameters and save data.
2. Put my select query inside the Saved Data Selection on the main report and subreports.
3. In the main report I verified that all subreports use the same linked parameters.

To be clear, I am not attempting to refresh the data or update it or anything like that. I want the report to store the given data so as to allow the viewer the capability changing the parameters to display data between a given start and end date.

For instance, if my report contained statics of johns running for the past 3 years, I would want to be able to see details of johns running between 3/9/13 and 3/9/14 and have the report only show the data from between those dates.

Is it possible that you cannot modify parameters for a report with subreports?

[abhilash_kumar · Accepted solution]

Hi David,

What is the datasource of the Main Report - Stored Proc, Command, BEx Query, Table/View?

-Abhilash

[Former Member · Accepted solution]

Hi DJ, If you look at the second action I took, you will see that I've already done what you have suggested. I've aldo already gone through that link and several others attempting to solve this issue.

Hi Abhilash, I have one Database as the source. One report is using a command, and all the others are using the same table.

[abhilash_kumar · Accepted solution]

Is the Main report using a Command? And is the prompt created at the Command Level?

If yes, then Command prompts are Not supported by CR Viewer as they refresh the query. You would need to recreate such prompts at the Report level (via the Field Explorer) and use a 'Saved Data Selection' formula that includes this new prompt.

-Abhilash

[Former Member · Accepted solution]

One of the subreports is using a command. I suppose that would cause the issue as well. I guess I'll have to figure out how to move the Command into a Saved Data Selection then.

Thank you for your assistance Abhilash!

[Former Member]

Hi,

Check following scenario:

Go to your Report -> Select Expert -> and now you have three choices: Record, Group, Saved Data. Put your select statement using your parameters in the Saved Data only (remove it from Record if already there).

See this is also one more example:

--dj