Export hidden Data from report

[sstrauss87]

Hello,


I was wondering if anybody knows a way to export data from a report if it is hidden. thanks!

[imintrouble]

If what's hidden? More information would be helpful.

[John_G]

What do you mean by "export the data"? Do you mean calculated items (totals, etc) from the report, or do you mean the source data that the report is generated from?

In any event, the general answer to your question is "no", because a report does not keep its data anywhere, like a recordset. If you wanted to do that, you would have to write VBA code to save the data as it is generated, but even that would be full of potential problems. Please give a better indication of what it is you are trying to do.

John

[imintrouble]

What John said.

[sstrauss87]

I want to export the report to Excel, I need the report for the companies references, however, there are far to many fields to be displayed in the report, I wish to only show the most important fields in the report but include the other data as hidden data so when I export all the data to a spreadsheet it will all be transferred.

[John_G]

Hi -

As I said earlier - you can't export report data, because the report does not keep it anywhere (referring to values calculated in the report). You would have to save the calculated values as the report was generated, but that poses all sorts of problems.

My suggestion would be to either a) export the report source data (table or query) to Excel and do the calculations there, or b) write a VBA routine to do the calculations, save the results to a table (including all the fields you need), and then export the table.

Besides all that - what report data would you export? Headers? Footers? Detail? they are all different.

John

[sstrauss87]

I'm confused when you say I can't export report data, because If I open a report in print preview I can export the report to excel but It only export the visible fields.

[sstrauss87]

It exports all the visible fields into columns.

[sstrauss87]

Are you telling me that you didn't know that reports can export data?

[John_G]

Sorry, I overlooked that. But I tried myself what it is you want to do, and you are right, it does not export hidden fields.


But I also notice that only group headers and detail lines are exported - group, page, and report footers, which usually contain totals, are not. (IMHO, that renders the whole exercise somewhat pointless).

Given that limitation, you would probably be better off just exporting the report's source query.

John

[sstrauss87]

I wish I could but I need it to be in report form so users can enter criteria through the front end. I guess I'm out of luck, thanks anyway.

[sstrauss87]

I wasn't trying to sound like a dick earlier, I guess I just assumed you knew. I'll have to place all of the fields on the report then shrink them and hide them behind the fields that I want to be shown. lol

[John_G]

Hi -

No harm done. Exporting to Excel from a report is not something that I have ever needed to do, nor have I been asked about it - so I had never looked into it. That's what happens when we assume too much. Sorry for the confusion.

[sstrauss87]

They should have made an option to "Export Record Source", would have made my life a lot easier.