Tabbed reports: Exporting to Excel and displaying

[steve-waters]

Tabbed reports: Exporting to Excel and displaying (Solved)

Hi,

OK so I have created a report with subreports on tabs.

1. Can I use tabs in reports, it only shows me the first tab

2. Can I export this report to excel, having each tab/sub report going to a different worksheet.

3. Have a good day!!!!

Thanks in advance,
Steve

 

[boblarson]

1. Can I use tabs in reports, it only shows me the first tab

No, sorry you can't. You can use subreports on the main report but not on a tab control. No controls that need you to click on and select can be really used in a report since there is no way to click on them - they are not "active"

2. Can I export this report to excel, having each tab/sub report going to a different worksheet.

You can export the report to Excel, but to have each subreport going to a different sheet will take a bit of extra coding.

3. Have a good day!!!!

Thanks and BTW - Welcome to Access World Forums!

 

[steve-waters]

Excellent thanks for the reply.