Paging in Business Intelligent Reports

I have finally been able to create a simple master detail report of the records in the database. Is there any way to create a new page after each record, or to keep a record all together on the same page? It took me two days to get SQL Express installed properly so I could get this simple report. They don't make it easy.

Any help would be appreciated.

Thanks
CalI'd be interested in hearing how you got BIDS to run. I'm still not able to use it. No devenv.exe file!!!!!!!!!!!!|||Well, it wasn't easy. I had installed to Sql Server included with Visual Basic Express. I then downloaded and installed the SQL Express Editon with Advanced Services. I then installed the SQL Express Edition Toolkit SP1. I did this twice before it worked. I hope this helps.

Cal|||I have installed the tool kit twice but still no devenv.exe. I haven't tried to re-nstall 2005 express advanced yet.|||

I'm going to move this question to the RS forum, they'll have specific advice about writting reports.

(we're working on the BIDS install issue in several other threads)

Mike

Paging Header and Detail

I would like to create a report with header and detail, like an invoice with invoice # and line items. I'd like the invoice # to come from a summary query that breaks 1 invoice # per page. Then I'd like to display the line items below the invoice # on each page, from a second query passing the invoice number as a parameter. How is this done? Do I need a subreport?

ie:

header from summary query:

invoice 101

detail from detail query passed invoice # = 101:

line 1 item A

line 2 item B

line 3 item C

page

header from summary query:

invoice 102

detail from detail query passed invoice # = 102:

line 1 item A

line 2 item B

line 3 item C

page

...

Thanks.

If you want to use two queries, yes, you need a subreport to display the line items.

If you can return all the data in one query, then you just need a table with group (by invoice #). The invoice information would be in the group header, and the line items would be in the detail rows.

Paging (or beating a dead horse?)

My report used to work beautifully in regards to paging and then the
requirements changed. I added a subreport into the table's detail
section and made it a drilldown with the toggle based on a group
value. The paging went wonky as in there is only one page now even
with the paging set up on the group.
Any good resources out there on this?
TIA, ReneeUser "beener" <rmp_colo@.hotmail.com> wrote
news:1191519015.869502.324820@.19g2000hsx.googlegroups.com...
> My report used to work beautifully in regards to paging and then the
> requirements changed. I added a subreport into the table's detail
> section and made it a drilldown with the toggle based on a group
> value. The paging went wonky as in there is only one page now even
> with the paging set up on the group.
> Any good resources out there on this?
Try set Hidden=false on group details.
Best regards
Adam