Multiple queries on single page of report

  • Thread starter Thread starter af01waco
  • Start date Start date
A

af01waco

I have a table and query created with the fields i want to use. I would like
to be able to pull from the query and create a report that will display on
one page of a report. This will include data from specific dates.
 
Use the report wizard. If you don't know how to use it, type in report wizard
in the help files.
 
thanks for the help, i tried the report wizard and it does not show all the
records on one page. each record is displayed on seperate pages. What im
wanting to do is to display each record on the same page and then have totals
for each piece of information.
 
You probably have done something in your report that forces new records to
new pages. How tall is your detail section?

Do you have any properties set that force new page after or before your
report sections?
 
Hi Duane Hookom

I am facing a problem which goes like this...

we have 20 reports, like 1.rdl ,2.rdl.......20.rdl.

All reports takes a single parameter: @AssessmentId=Parameters!AssessmentId.Value

At present when client wants to view reports they have to click 20 different links for each report and then submit the assessmentid value as the parameter.

Now what they want is submit the parameter value in a single report and able to view all the reports one below another.

so how to go about this using sub reports or any other means.

i am using sql server reporting services 2000. i have one shared datasource for all reports and different datasets.

i tried using subreport but i m getting a error like this :

A parameter in the subreport ‘subreport1’ has the name ‘@AssessmentId’. Parameter names must be CLS-compliant identifiers.

One more thing is that i tried to copy and paste the tables in a single report but i m not able to see the resuls in a single page.

is there any relation between the height of page and the height of details section of a table.

in my case i have multiple tables and the details section is also very tall...

Plz share your thought.
 
hi
can u plz elaborate a little more on this :

Do you have any properties set that force new page after or before your
report sections?

actually i m also facing the same problem and it would be great help if i could get something out of it.
 
Back
Top