Rightmost columns missing in report

[asu81]

Hi,
I'm new with reports and with Access in general and I've got a problem creating a report based on a query.

I select a query and then create a basic report on that query. My query has 17 columns, but only 15 of these are displayed in the report. The 2 rightmost columns are missing. I'm not sure if it's a coincidence, but when I open the query these 2 columns are the only ones that I cannot see without having to scroll to the right.

However I've set my report to A3 landscape size. I can see there's clearly room left on the report in the print view. The columns just aren't there, neither in normal- print- or design view.

Please help me!

 

[boblarson]

Do you remember to add the margins into the measurements? The design view of the report does NOT take into account margins.

 

[asu81]

Do you remember to add the margins into the measurements? The design view of the report does NOT take into account margins.

I've got narrow margins, only 0.64 cm. I find it unlikely that they would block 2 whole columns. No matter what view I'm in the columns don't show.

 

[boblarson]

Can you either post a copy of the database (with bogus data) or post a screenshot of the report in design view (make sure all of it is showing in the screenshot) and one when it is in print preview.

 

[asu81]

Can you either post a copy of the database (with bogus data) or post a screenshot of the report in design view (make sure all of it is showing in the screenshot) and one when it is in print preview.

I'm at work now and I've only got the swedish access version here. I can post a screenshot of it now and I'll try posting my english access version when I get home.


http://i1164.photobucket.com/albums/q565/shinzai1/report_design.png

http://i1164.photobucket.com/albums/q565/shinzai1/query.png

EDIT: there's just bogus data in the db so far.

 

[boblarson]

I'm at work now and I've only got the swedish access version here. I can post a screenshot of it now and I'll try posting my english access version when I get home.


http://i1164.photobucket.com/albums/q565/shinzai1/report_design.png

http://i1164.photobucket.com/albums/q565/shinzai1/query.png

EDIT: there's just bogus data in the db so far.

You'll need to upload the images HERE in the forum so I can see them. I can't see anything at public photo sharing sites, like photobucket, as they are blocked by my workplace.

See this for how:
http://www.access-programmers.co.uk/forums/showthread.php?t=194680

 

[asu81]

You'll need to upload the images HERE in the forum so I can see them. I can't see anything at public photo sharing sites, like photobucket, as they are blocked by my workplace.

See this for how:
http://www.access-programmers.co.uk/forums/showthread.php?t=194680

Ok I'll try uploading the database.

http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=44741&stc=1&d=1351703021

The report "rptRU_Alla" is created by selecting the query "qryRU_Alla" and clicking "Report".

Thanks for your help!

 

[boblarson]

Have you looked in the report in design view? You only have 15 of the fields on the report. So of course the other 2 won't show. You will have to add the other two fields manually, like what I did in the revised attached sample.

 

[asu81]

Have you looked in the report in design view? You only have 15 of the fields on the report. So of course the other 2 won't show. You will have to add the other two fields manually, like what I did in the revised attached sample.

Thanks, but I'm not sure as to how you added the fields.. I found the "add existing fields" button, but I can't seem to get them organzed as I want. I cant get the label and its corresponding textbox to be in separate areas. I want the label to be in the "page header" and the textbox in the "detail", but it seems I can only move one to another area if I also move the other one at the same time.

So..

1) How did you do it?
2) Why doesn't the report pick all the fields from the query?

Thanks for your time!

 

[boblarson]

you drag and drop onto the detail section like you have, but then click somewhere other than the control Then click on the top left of the label and to CTRL+X to cut and then click in the header and use CTRL+V to paste. You'll have to move and size them to where you want them.

2) Why doesn't the report pick all the fields from the query?

How did you build the report?

 

[asu81]

you drag and drop onto the detail section like you have, but then click somewhere other than the control Then click on the top left of the label and to CTRL+X to cut and then click in the header and use CTRL+V to paste. You'll have to move and size them to where you want them.



How did you build the report?

Thanks, that worked!
I created it by selecting a query and choosing "report"