Prompt Questions

[dgleason42]

I have a couple of questions around prompts that I'm hoping someone can help out with...

1. Is there a way to display prompt values in place of the prompting object itself when exporting the report to Excel or PDF? I have some reports that have optional prompts as filters at the top of the report, but when the user sends the report to an external app for printing they don't know what filters they have applied. I can create text objects that reference those parameters and place them on my layout, but I'd like to "replace" where the prompting objects were in the layout to take advantage of the table(s) I've already made that show the prompt label in one cell and the prompt object in the next, if this is possible...

2. Is there a way to "pass" a prompt value through to a target report if that prompt value is not displayed within the report object (list, crosstab) that contains the drill-through link? For example, say I have a report with a prompt for Region (so the user can filter on the Region they want to display details for), but I don't really want to display the Region in the report itself (this is a simplistic example). Is there a way that the child report can "see" that prompt value/parameter? I haven't been able to pass any values to a drill-through report that aren't containted in the actual displayed report that "does the drilling" - I imagine this could probably be done with JavaScript somehow, but I haven't been able to come up with the approach and I'm hoping someone around here has already done it.

Just as an FYI, adding the parameter as a data item in the query source for the parent report doesn't seem to work - nothing ends up getting passed to the target, even though it would "seem" like this would be the correct approach...unless I'm just doing it wrong!

[Darek]

Ad 1: You could leverage conditional blocks based on a variable driven by ReportOutput() function.

Ad 2: Yes, this should be possible. Did you try making a parameter a query item that is not being used for display?