Showing posts with label detail. Show all posts
Showing posts with label detail. Show all posts

Friday, March 30, 2012

Report Detail Sections will not expand

I have a report that has a detail section hidden until the user clicks
the '+' sign to expand it and see the details. This has worked in the
past and works in design view for this report, however when deployed to
report manager and brought up in IE it will not expand. I have tried
deleting the report from the report manager and then re-deploying but
this doesnt work. Does anyone have a similar experience or know how to
fix this?I have just found out that it is doing this for all reports that have
the '+' sign that lets the user choose to see detail. Only thing that
has changed is that we changed our report server to the full license
when our trial expired. If anyone can help I would greatly appreciate
it.|||I have the same problem. If you have solved the problem, please post the
resolution. Thanks.
<barhoc11@.gmail.com> wrote in message
news:1129901639.084816.251550@.f14g2000cwb.googlegroups.com...
>I have just found out that it is doing this for all reports that have
> the '+' sign that lets the user choose to see detail. Only thing that
> has changed is that we changed our report server to the full license
> when our trial expired. If anyone can help I would greatly appreciate
> it.
>

Saturday, February 25, 2012

Report - Limit rows in table per page

I have a report that is a master-detail style report. The detail is displayed in a table. I would like to be able to limit the number of rows that can be in that table, and if there are more rows, it goes to the next page.

The report is essentially invoices. The master part has the name address, etc... and the detail is the line item detail. But with the format i am using, i can only fit x amount of line items per page (Depends on the size font i have). So, lets say i can only fit 10 items on a page. If there is an invoice with 12 items, i would like it to print 10 on the first page, and the last 2 on the second page. Everything else can be identical (doesn't really matter though). Is this possible?

Thanks

Hi bortiquai

you didn't mentioned which control you are using?

if you are using gridview than you can simple set the property

pagesize="10" or whatever you want

hope it helps

|||

I'm using the Table object in the Report Designer (RDLC), and the ReportViewer Control to view the report on the page. The pagesize=10 property on the GridView control is pretty much what I'm looking for, but the Table object in the report viewer does not have this property.

|||

This article will help you.

http://msdn2.microsoft.com/en-us/library/ms251668(VS.80).aspx

Look for "Page Breaks" section. This "=Int((RowNumber(Nothing)-1)/25)" expression will limit the number of rows displayed to 25 per page but you have to set it in the report. If you want your users to decide the number of pages, you just need to pass a parameter to the report that will contain the value. If you need help with that, let me know.

good luck...