Problem with output of report not matching whats in database

[Former Member]

I have a report that pulls data from the data base and displays each record in the access data base on a single sheet.

So i Enter my parameter field to sort what i want to display.

For my particular parameter i have 42 records.

when i am in the preview tab of the report it actualy says at the bottom right of the screen "Records:42".

But when i export to PDF i noticed that it only exports 21 records.

I then began to scroll through each output in the preview tab and found that it only brings up 21.

I tried this with other parameters and began to realize that for some reason when i enter my parameter field it only displays half in the preview of what is true in the data base.

Any one have any issues with this that can help me?

-Jimmy

[abhilash_kumar]

Hi James,

What you see on the top (21/21) is actually the number of pages. That has nothing to do with the number of records in the report.

How many pages of data do you have in the report and the exported pdf file?

- Abhilash

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member]

No each page has its own record.

in the database there are 42 records.

it should get 42 pages of outputs.

however it only does half. it only prodcues half no matter what parameter i put in. 

[Former Member]

ok i found out why its doing that.

i deviate from the page margins.

I want my data to fit all on one page. Before what was happening was i would get a spill over and have a blank second page. So after each record i would get a blank second page. to fix that i made the page margins small so i would not have blank pages. However in doing that for some reason or another it only gives me half my records. Any one have a clue why that happening?

[former_member198519]

Could you try and and export the report in any format and compare the resultset?

Let say PDF?

- Kuldeep

[abhilash_kumar]

Hi James,

It's just 42 records isn't it? Could you first make sure it is actually showing only half the records (Don't look at the Page Numbers).

Could you browse through and see if there are any missing records?

Also, please attach a copy of the report with saved data? Change its extension to .txt before you attach.

-Abhilash

[former_member11696]

Hi Jimmy,

Not enough info and not clear how your report is laid out, so it sounds like you have a bunch of data and your report is Grouped on a field that returns 42 rows of data? And these rows then fill each page with some other data to fill up one page?

Did you write the report or are you just running it? If you did not write it then talk to the person who did, maybe they can explain what is happening.

And to clarify, where are you seeing these numbers, along the top menu area:

Or bottom of the designer:

Don

[former_member198519]

Hi James,

It looks like you have 42 records and these 42 records are splited across 21 pages.

Correct me if I am wrong.

- Kuldeep

[Former Member]

ok i found out why its doing that.

i deviate from the page margins.

I want my data to fit all on one page. Before what was happening was i would get a spill over and have a blank second page. So after each record i would get a blank second page. to fix that i made the page margins small so i would not have blank pages. However in doing that for some reason or another it only gives me half my records. Any one have a clue why that happening?