Export/Map more than 10 Samples to Excel?

I've got Datasuite 4.1+ and whenever I try to export 30 pcs to excel, only 10 pcs are mappable to excel columns. Is there an easier way around this without having to export 3 different reports 10 pcs each and combining them into 1 final report?

I've looked into using a query inside excel to connect to the SQL database but since I'm not familiar with writing SQL statements I cannot get it to do what I want as the data is really broken apart across multiple tables.

Any help, thoughts would be greatly appreciated.

Matthew D. Hoedeman over 12 years ago

Are you sure that you aren't seeing 10 subgroups of 3? Datapage defaults to subgroups of 3, 30 pc would then be 10 subgroups....

If that isn't the issue.... just do a data report
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Fish_Hook over 12 years ago

It is a data report and I'm using the option to Output as Excel.

Here is a picture of the custom report I am talking about.

The options are MeasData1 - 10
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Matthew D. Hoedeman over 12 years ago

Try just saving it as a TXT file, Excel can open a TXT file, I do it all the time.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Fish_Hook over 12 years ago

Exactly how do you save as a TXT file? When I run the "TEXT/DATA REPORT" and click "Save Report" all I get is save to WebReporter and ReportViewer. No options for RAW text. Do you have to open up the saved "reportviewer" report in some other program and then save as text?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Fish_Hook over 12 years ago

Nevermind on this....

I found that the button on the "side" labeled "to excel" will export all the data and I can work with that.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel