I have several reports that when run with HTML output display a seemingly random number of rows on each page - 1 on the first, 3 on the second, 4 on the third, 2 on the forth, etc - yet display a full page of rows when output as PDF.
Why don't all the rows display in the HTML version that display in the PDF version on the same page?
set the display size to the number which required to display. If use the list report the property is "Row Per Page" give some numeric value for that
It sounds like the report may have page breaks. Can you tell if the report starts with a new page everytime a certain field changes? If you can post the report spec, we can have a better idea of the problem.
Hope this helps.
bdybldr: Can I tell if the report starts with a new page everytime a certain field changes? YES, it doesn't. What sort of spec do you need to see?
kaylan_sekhar1: The "rows per page" property is for the MAXIMUM rows to display on a page. I have set this to 500 without making any difference to the HTML output behaviour.
kaylan_sekhar1: I have set every column to a specific width and tried setting the list table to fixed but neither made any difference.
I have a suspicion it is connected with either that the HRML renderer think there are more lines on the page than there is due to the grouping and/or the HTML renderer is not processing enough data at run time to display all values that could be on a page. The PDF processor gets a full set of data before displaying output but HTML only gets enough for the first page until you page down.
I have the same problem. I gave up trying to find a solution months ago. At times I will get 5 rows on 1 page, 1 row on the next 3 pages and then 10 rows on the remaining pages. There seems to be no rhyme or reason to it.
However, there are 2 things that I noticed about these reports that may be worth mentioning. Removing the level span prevents this from occurring, but that is not an option for me. The other thing is that the table seems to split or separate between some of the rows. In other words, 2 rows are joined like they are part of the same table. Then it seems like the table ends and a new table starts, but it is actually the next row. This happens on the same page.
Hi Blue,
Have you checked for page breaks based on some query? Ã, If there are page breaks, the report will start a new page everytime the value in the specified page changes.
I was just referring to the xml file. Ã, It may be helpful to see in person to try to help you resolve this issue.
I have apparently solved the problem though I still need to verify the data.
The previous logic was thus:
create tabular model item from model.
create two tabular model items from the first based to get an hours item and a days item (hours / hours in day model item).
create forth TM item using the second and third items in an IF THEN ELSE based on a user prompt (Hours or Days).
create fifth TN item as TOTAL(forth item FOR key item).
Added the fifth item to the query model facts.
Inserted fifth item into report page with aggregation set to none and level span to key item. Without level spanning I was getting duplicate lines for the key item.
New logic is this:
create tabular model item from model.
create two tabular model items from the first based to get an hours item and a days item (hours / hours in day model item).
create forth TM item using the second and third items in an IF THEN ELSE based on a user prompt (Hours or Days).
Set data aggregate function to TOTAL.
Added the forth item to the query model dimension under item key.
Set level aggregate function to TOTAL.
Inserted fifth item into report page.
However I also had a count column and a currency column in the report. These I could not use the Level Aggregate Function as each line already had the value I wanted.
These were:
COUNT(employeeid FOR item key) with no aggregate function.
TOTAL(salary FOR key item) with no aggregate function.
and now are:
employeeid with data aggregate function of COUNT
salary with data aggregate function of TOTAL.
Both have the Level Aggregate Function set to NONE.
Thanks for everyone's input.
Take a look at my tutorials.. it's explained there how to do that.... Look for: Forcing data on page
Thanks RNA.
The closest thing I could find on the tutorial menu was "Setting number of rows per page". This doesn't help me as a) it is a simple list report not a cross tab and b) I've tried setting this property to 5000 but it didn't make a difference. :(