Hi,
I have data that is grouped by a code number. One of the code numbers have over 600 rows, while other code numbers have around 10 to 20 rows within it.
When I run the report the code number that has over 600 rows gets split over 2 pages while the other code numbers each get their own page.
How do I make it so that when I run the report the code number that has over 600 rows gets all displayed on the 1 page instead of being split over 2?
Thanks
Ben.
can anyone help please?|||Hi ben22,
I'm afraid there is not really a functionality in Reporting Services that does this. I know this is a lack in Reporting Services.
Greetz,
Geert
Geert Verhoeven
Consultant @. Ausy Belgium
My Personal Blog
|||Hi Ben
Do you just want it to display on 1 page in the browser or
do you require this for printing aswell?
If it is for viewing purposes only, you can try to set the
'Interactive Page size' in the report properties to have a higher width.
G
|||need it both for display in the browser and for printing, as when it gets exported to excell it needs to be in the same sheet instead of being expanded over 2. This is because a certain value in the row gets summed at the end and I need that sum to include all the rows within the group, as when it splits over 2 pages I get two different sums where they should be altogether.|||Hi ben,
As mentioned before, it is not possible to make the page size dynamic for printing and viewing at the same time.
You mentioned that you receive 2 sum results. It is possible to only have only a total line at the end in case of on each page.
For example:
When you use a Table you can set the total in the Table footer. Even if the table overlaps multiple pages, it will only be displayed at the last page.
Greetz,
Geert
Geert Verhoeven
Consultant @. Ausy Belgium
My Personal Blog
|||Sorry, I should of explain things a bit better before. By groups I meant I have 1 group in the table. This group breaks the data up by the unique field assigned to each data item and uses a group footer to do the sum. For example:
I have 800 cars, 600 are red 100 are blue and 100 are green. So when I run the report is looks like this
Page 1
RED
Name | Model | Price
Car1 | c1 | 20000
Car2 | c2 | 30000
…
Car400 | c400 | 15000
-
Total Price: 3000000
Page 2
RED
Name | Model | Price
Car401 | c401 | 20000
Car402 | c402 | 30000
…
Car600 | c600 | 15000
-
Total Price: 1500000
Page 3
BLUE
Name | Model | Price
Car1 | c1 | 10000
Car2 | c2 | 30000
…
Car100 | c100 | 40000
-
Total Price: 1000000
Page 4
GREEN
Name | Model | Price
Car1 | c1 | 25000
Car2 | c2 | 17000
…
Car100 | c100 | 40000
-
Total Price: 1200000
As you can see there are 4 pages. It splits the RED cars up over 2 pages giving the 2 different sums ie: cars 1 – 400 with the sum 3000000 and then cars 401 – 600 with the sum 1500000. I want my report to work so that the RED cars are all together and not on different pages, so altogether there are only 3 pages. So to look like this:
Page 1
RED
Name | Model | Price
Car1 | c1 | 20000
Car2 | c2 | 30000
…
Car600 | c600 | 15000
-
Total Price: 4500000
Page 2
BLUE
Name | Model | Price
Car1 | c1 | 10000
Car2 | c2 | 30000
…
Car100 | c100 | 40000
-
Total Price: 1000000
Page 3
GREEN
Name | Model | Price
Car1 | c1 | 25000
Car2 | c2 | 17000
…
Car100 | c100 | 40000
-
Total Price: 1200000
|||
Hi,
It is not possible to force a group on 1 page but it is possible to have only 1 total per group. You need to set the Color field in the expresion of the group. When you then look at the group footer, you will see that the total is done on group base.
Greetz,
Geert
Geert Verhoeven
Consultant @. Ausy Belgium
My Personal Blog
|||Geert Verhoeven wrote:
It is not possible to force a group on 1 page but it is possible to have only 1 total per group. You need to set the Color field in the expresion of the group. When you then look at the group footer, you will see that the total is done on group base.
Sorry but I dont really understand what you have said or how to implement it
|||Hi,
What I mean is that you can not force the contents of a group to be on 1 page. Although the problem you have that the total is displayed on each page can be avoided by using the footer of the group. When you set the total in the group of the footer, only at the end of the group a total will be displayed and not at the end of each page.
Hope this is more clear.
Greetz,
Geert
Geert Verhoeven
Consultant @. Ausy Belgium
My Personal Blog
|||im using a group a footer and it still displays the total at the end of each page, not at the end of the group
No comments:
Post a Comment