HELP! SUBREPORTS!!

Hi All, I really need some help with subreporting in SQLRS. I have wasted 2 full days trying to get a simple subreport working in Reporting Services and am on the brink of going back to Active Reports if RS continues to be so confusing!
I have a main report and for each line I need a subreport linked on an OrderID parameter. I have followed every single RS books online How-to (as vague as some of them are) and still no luck. This is what I have done
I have created main report and a subreport.
I have placed the subreport on the main report and in its properties have added a parameter â'OrderIdâ' linked to the OrderId field from the main report. No complaints from RS so far.
In the subreport, I click on the â'â?¦â' to edit the DataSet and add a parameter OrderId here whos value is Parameters!OrderId.Value
Surely now when I run the report, the main report will pass its OrderId through to the sub report and I will get a subreport for each line?
All I get is all my main reports lines and then one subreport listing everything in the table?
If anyone can, please could you explain how exactly the parameters are meant to be set up as the online documentation assumes one has been using RS for 50 years or more!
Many thanks in advance
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.This is a very rough guess, but it sounds like you need to do some sort of
grouping (on OrderID perhaps) on each main report line item...
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uoqz3rnaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> Hi All, I really need some help with subreporting in SQLRS. I have wasted
2 full days trying to get a simple subreport working in Reporting Services
and am on the brink of going back to Active Reports if RS continues to be so
confusing!
> I have a main report and for each line I need a subreport linked on an
OrderID parameter. I have followed every single RS books online How-to (as
vague as some of them are) and still no luck. This is what I have done
> I have created main report and a subreport.
> I have placed the subreport on the main report and in its properties have
added a parameter â?~OrderIdâ?T linked to the OrderId field from the main
report. No complaints from RS so far.
> In the subreport, I click on the â?oâ?¦â' to edit the DataSet and add a
parameter OrderId here whos value is Parameters!OrderId.Value
> Surely now when I run the report, the main report will pass its OrderId
through to the sub report and I will get a subreport for each line?
> All I get is all my main reports lines and then one subreport listing
everything in the table?
> If anyone can, please could you explain how exactly the parameters are
meant to be set up as the online documentation assumes one has been using RS
for 50 years or more!
> Many thanks in advance
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.|||Break this down. First, work on the two reports separately until you get
what you want. Create the subreport as a stand alone report. This report
should have a report parameter and a query parameter. You should be able to
fully test your subreport stand alone. Then put the subreport into the mail
report. Do a right mouse click onto the subreport and then you can set the
parameter to the value of the orderid field.
Bruce L-C
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uoqz3rnaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> Hi All, I really need some help with subreporting in SQLRS. I have wasted
2 full days trying to get a simple subreport working in Reporting Services
and am on the brink of going back to Active Reports if RS continues to be so
confusing!
> I have a main report and for each line I need a subreport linked on an
OrderID parameter. I have followed every single RS books online How-to (as
vague as some of them are) and still no luck. This is what I have done
> I have created main report and a subreport.
> I have placed the subreport on the main report and in its properties have
added a parameter â?~OrderIdâ?T linked to the OrderId field from the main
report. No complaints from RS so far.
> In the subreport, I click on the â?oâ?¦â' to edit the DataSet and add a
parameter OrderId here whos value is Parameters!OrderId.Value
> Surely now when I run the report, the main report will pass its OrderId
through to the sub report and I will get a subreport for each line?
> All I get is all my main reports lines and then one subreport listing
everything in the table?
> If anyone can, please could you explain how exactly the parameters are
meant to be set up as the online documentation assumes one has been using RS
for 50 years or more!
> Many thanks in advance
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.