Report to look like Excel (2000)

Topic

New Reply

I have a report and I would like the output to look like a grid like you can in excel. Is there an easy way to do this? So far I haven’t found one.
Thanks,
Deb

Reply | Quote

Replies

Try the Report wizard – AutoReport: Tabular based on a Crosstab query.

Reply | Quote

Cross tab query doesn’t give me what I want. I don’t have the proper data to use it. Any other suggestions?
Deb

Reply | Quote

That kind of report doesn’t have to use a Crosstab query as it’s data source, but without more details, we can’t make explicit suggestions.

Reply | Quote

Basically I have a report that has columns and rows of data and I’d like to have grid lines between each column and row (like and excel spreadsheet). A snap shot is attached. The bottom section is where I’d like the grid
Thanks
Deb

Reply | Quote

That should simply involve turning on the border for the text boxes that run across the detail section of the report – they are presumably set to transparent now.

Reply | Quote

But that’s assuming the fields touch each other which mine do not, so I’m assuming to get the grid I want I have to make them all touch each other. Thanks, Deb

Reply | Quote

Yes, either that, or place rectangles over each text box, turn on their border, and send them to the back. The reason for doing that is that you may not like the data being directly against the border if it is right or left justified – but then you need to make sure your text boxes can’t grow. Always a gottcha isn’t there.

Reply | Quote

Yes, either that, or place rectangles over each text box, turn on their border, and send them to the back. The reason for doing that is that you may not like the data being directly against the border if it is right or left justified – but then you need to make sure your text boxes can’t grow. Always a gottcha isn’t there.

Reply | Quote

If I understand you correctly you want have grid lines around your report controls.

Reply | Quote

Yes I do John.
Deb

Reply | Quote

Can you post the design report here or send direct I will set up

it not pretty in design but it works

Reply | Quote

Is is different than what Wendell offered. I ended up putting rectangles around each field and that gives me what I want. What are you offering?
Thanks,
Deb

Reply | Quote

(Edited by ThreeCrow on 31-Aug-04 22:48. Edit by Threecrow Found better than my way to put grid lines on report)

If you have what you want, then all is done

Helen Feddama
Has method of this on her web site, after logging on goto Archon #104

http://www.helenfeddema.com/access.htm

Reply | Quote

(Edited by ThreeCrow on 31-Aug-04 22:48. Edit by Threecrow Found better than my way to put grid lines on report)

If you have what you want, then all is done

Helen Feddama
Has method of this on her web site, after logging on goto Archon #104

http://www.helenfeddema.com/access.htm

Reply | Quote

Is is different than what Wendell offered. I ended up putting rectangles around each field and that gives me what I want. What are you offering?
Thanks,
Deb

Reply | Quote

Can you post the design report here or send direct I will set up

it not pretty in design but it works

Reply | Quote

Yes I do John.
Deb

Reply | Quote

If I understand you correctly you want have grid lines around your report controls.

Reply | Quote

But that’s assuming the fields touch each other which mine do not, so I’m assuming to get the grid I want I have to make them all touch each other. Thanks, Deb

Reply | Quote

Basically I have a report that has columns and rows of data and I’d like to have grid lines between each column and row (like and excel spreadsheet). A snap shot is attached. The bottom section is where I’d like the grid
Thanks
Deb

Reply | Quote

That kind of report doesn’t have to use a Crosstab query as it’s data source, but without more details, we can’t make explicit suggestions.

Reply | Quote

Cross tab query doesn’t give me what I want. I don’t have the proper data to use it. Any other suggestions?
Deb

Reply | Quote

Try the Report wizard – AutoReport: Tabular based on a Crosstab query.

Reply | Quote