Solved Create a report that resembles an Excel Spreadsheet design

[John Lee]

Good day folks,

I have a spreadsheet (example attached) that I want to recreate in an Access report, can anyone help me with this at all, I've also attached an example of what I've been able to achieve in Access so far, but if it is possible I'd like to re-create the attached spreadsheet look.

Any assistance would be most appreciated.

 

[GPGeorge]

Good day folks,

I have a spreadsheet (example attached) that I want to recreate in an Access report, can anyone help me with this at all, I've also attached an example of what I've been able to achieve in Access so far, but if it is possible I'd like to re-create the attached spreadsheet look.

Any assistance would be most appreciated.

Have you considered exporting the data required into the Excel report?

 

[Gasman]

Good day folks,

I have a spreadsheet (example attached) that I want to recreate in an Access report, can anyone help me with this at all, I've also attached an example of what I've been able to achieve in Access so far, but if it is possible I'd like to re-create the attached spreadsheet look.

Any assistance would be most appreciated.

Looks like a crosstab to me?

 

[GPGeorge]

Good day folks,

I have a spreadsheet (example attached) that I want to recreate in an Access report, can anyone help me with this at all, I've also attached an example of what I've been able to achieve in Access so far, but if it is possible I'd like to re-create the attached spreadsheet look.

Any assistance would be most appreciated.

Looks like a crosstab to me?

The download I offered in Post #2 exports Access data into a pivot table in Excel. That results in something a whole lot like the crosstab report....

 

[John Lee]

The download I offered in Post #2 exports Access data into a pivot table in Excel. That results in something a whole lot like the crosstab report....

The problem with a cross tab query is that it requires a value to calculate and there are no values to calculate, unless I am mis-understanding how it works

 

[GPGeorge]

The problem with a cross tab query is that it requires a value to calculate and there are no values to calculate, unless I am mis-understanding how it works

Yes, that is true, but you've only shown us the results you want, not the data that goes into it. Give us a chance to help with that by providing sample data.

 

[MajP]

The problem with a cross tab query is that it requires a value to calculate and there are no values to calculate

Since there is only one value in each row, column combination you simply pick FIRST. Crosstab will work. I am assuming at least two crosstabs used in sub reports on a main report. A page for General, page for Product...

 

[DHookom]

If you go the Access report direction, you might want to review the example of generating a crosstab report with dynamic headings. I’m not sure you will find a simple solution to the vertical text in your column labels.

 

[MajP]

I’m not sure you will find a simple solution to the vertical text in your column labels.

That is pretty trivial to do.

 

[DHookom]

I am well aware of the Vertical but not sure the orientation matches the desired look. Stephen Lebans was a master at stuff like this.

I searched and found a thread here.

 

[MajP]

l aware of the Vertical but not sure the orientation matches the desired look. Stephen Lebans was a master at stuff like this.

I would not waste time on trying old Lebans code. It was fine when there was not other solutions to stuff that is now built in.
I am pretty sure the OP is better off using native functionality and dealing with the slight appearance difference.

VS original

 

[DHookom]

That’s why I stated not a simple solution. There might need to some compromise regarding format/layout.

I would link the Access table/query into Excel where there are more options for slicing and dicing.

 

[Pat Hartman]

Too bad whoever built the "new" integrated code to make the vertical label didn't do it using the standard orientation. It is jarring to see the labels facing the wrong way.