Wednesday, March 28, 2012

HELP! SubReports Nightmare

Hi, Im relatively new at SQLRS and am having a total nightmare trying to get a subreport to work. I have a main report from which I am trying to pass a parameter (OrderID) to a subreport and all I get is Error: Subreport cannot be displayed and some stuff about "An attempt was made to set a report parameter that was not declared in the subreport" but I have created all the parameters!'...What am I doing wrong'
Any help will be hugely appreciated!
shneeg
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.Have you done the following:
In your project you have:
report A (will be the sub report)
report B (will be the parent report)
Report A has a parameter OrderID. It has a particular data type.
In Report B you drag in the sub report report item from the tool box. You
set the subreport name to point to Report A. In the properties windows for
the sub report, you've navigated to the Parameters tab. From the Parameter
column you use the drop down to select OrderID and in the value column you
specified a value (whether expression or literal).
When you use this procedure, do you continue to get the error?
-Lukasz
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:OfiuYomaEHA.3944@.tk2msftngp13.phx.gbl...
> Hi, Im relatively new at SQLRS and am having a total nightmare trying to
> get a subreport to work. I have a main report from which I am trying to
> pass a parameter (OrderID) to a subreport and all I get is Error:
> Subreport cannot be displayed and some stuff about "An attempt was made to
> set a report parameter that was not declared in the subreport" but I have
> created all the parameters!'...What am I doing wrong'
> Any help will be hugely appreciated!
> shneeg
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
> supports Post Alerts, Ratings, and Searching.

No comments:

Post a Comment