TWO queries on a report.

Question:
Can you have a report were the top half is filled in with one query and the
bottom half is filled in with another query???????????????


I have a report that is just fine right now.
I was asked to have the comments to the agency print at the bottom of the
report.
Query1 is big, mean, massive. I dont wont to touch it.

IDeal: I wonted to create a 2nd query that pulls the comments and display
them at the bottom of the report.

Both queries get there BatchID from the Parameter <@BatchID>.
Both queries work when you run them in the develper envirment.
The report engine errors out.
"The Data Set Name is missing in the data region 'Datasetname'"



Scott Burke

Norman
Tue Jun 26 15:21:27 CDT 2007

Yes. you can have more than one DataSets corresponding to different queries.


"Scott Burke" <ScottBurke@discussions.microsoft.com> wrote in message
news:105BCA18-D6F6-41A0-97A2-5DAA4B86E942@microsoft.com...
> Question:
> Can you have a report were the top half is filled in with one query and
> the
> bottom half is filled in with another query???????????????
>
>
> I have a report that is just fine right now.
> I was asked to have the comments to the agency print at the bottom of the
> report.
> Query1 is big, mean, massive. I dont wont to touch it.
>
> IDeal: I wonted to create a 2nd query that pulls the comments and display
> them at the bottom of the report.
>
> Both queries get there BatchID from the Parameter <@BatchID>.
> Both queries work when you run them in the develper envirment.
> The report engine errors out.
> "The Data Set Name is missing in the data region 'Datasetname'"
>
>
>
> Scott Burke

Bruce
Tue Jun 26 15:29:02 CDT 2007

Two issues. One, you want to have both datasets map to the same parameter.
If they have exactly the same parameter name in the query (including case
sensitivity) then they will share the parameter. Next you have to put
something for the dataset on the report: table object, list object. Then you
need to bind the dataset to it. Click on the second table object and lock at
its properties. You will see a dataset name property with a drop down box.
Select your second query. Drag and drop your fields to the second table
/list object.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Scott Burke" <ScottBurke@discussions.microsoft.com> wrote in message
news:105BCA18-D6F6-41A0-97A2-5DAA4B86E942@microsoft.com...
> Question:
> Can you have a report were the top half is filled in with one query and
> the
> bottom half is filled in with another query???????????????
>
>
> I have a report that is just fine right now.
> I was asked to have the comments to the agency print at the bottom of the
> report.
> Query1 is big, mean, massive. I dont wont to touch it.
>
> IDeal: I wonted to create a 2nd query that pulls the comments and display
> them at the bottom of the report.
>
> Both queries get there BatchID from the Parameter <@BatchID>.
> Both queries work when you run them in the develper envirment.
> The report engine errors out.
> "The Data Set Name is missing in the data region 'Datasetname'"
>
>
>
> Scott Burke

ScottBurke
Wed Jun 27 08:46:01 CDT 2007

Thanks! I give that a try.
Scott Burke

"Bruce L-C [MVP]" wrote:

> Two issues. One, you want to have both datasets map to the same parameter.
> If they have exactly the same parameter name in the query (including case
> sensitivity) then they will share the parameter. Next you have to put
> something for the dataset on the report: table object, list object. Then you
> need to bind the dataset to it. Click on the second table object and lock at
> its properties. You will see a dataset name property with a drop down box.
> Select your second query. Drag and drop your fields to the second table
> /list object.
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Scott Burke" <ScottBurke@discussions.microsoft.com> wrote in message
> news:105BCA18-D6F6-41A0-97A2-5DAA4B86E942@microsoft.com...
> > Question:
> > Can you have a report were the top half is filled in with one query and
> > the
> > bottom half is filled in with another query???????????????
> >
> >
> > I have a report that is just fine right now.
> > I was asked to have the comments to the agency print at the bottom of the
> > report.
> > Query1 is big, mean, massive. I dont wont to touch it.
> >
> > IDeal: I wonted to create a 2nd query that pulls the comments and display
> > them at the bottom of the report.
> >
> > Both queries get there BatchID from the Parameter <@BatchID>.
> > Both queries work when you run them in the develper envirment.
> > The report engine errors out.
> > "The Data Set Name is missing in the data region 'Datasetname'"
> >
> >
> >
> > Scott Burke
>
>
>