hidden data needs shown for export into excel - help!

I have a report that lists items purchased by various customer accounts.  To allow for a better user experience, I've suppressed duplicate data on repeated lines.  I've come to learn that a handful of our clients are going to need the ability to export that data as well.  With the report designed how it is, that would require a LOT of copy and pasting (or a nasty formula in Excel) to fill in the gaps.  Look at the included screen shot.  It shows how I only list the customer name once on the report per order.  By the way, banding exists on this report; any gray backgrounds only represent a change in the customer record.

snapshot of data displayed on the report
Is there a way to have the report export the data as if I had never turned on the "Suppress Duplicate Records" feature?  In other words, can I have the report conditionally skip that feature if it's being exported?   ....I'm also open to alternative strategies with this too.  

Thanks everyone!
- Travis
trs28Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
How do you export the report?

I have seen reports written that had an ExportToEXCEL parameter.  It was used to control visibility of sections when the report was to be exported to Excel.

mlmcc
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
There is a possible alternative strategy, but first please explain what process is responsible for delivering the excel file.  Manual export by the user or an automated export process?  
0
 
trs28Author Commented:
Right now there is no process in place to do the exporting.  Our VP has the files & gave it a test shot by manually exporting it via Crystal.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
What is the desired process: manual or automated?  If manual, than go with mlmcc suggestion.  A parameter can control whether or not you suppress the repeated info.
0
 
trs28Author Commented:
It's a little bit cruder than I would have liked, but it did solve my problem in no time flat.  ....so I decided to roll with it.  Thanks for the help!
0
 
mlmccCommented:
If you hit the Crystal Viewer export button, there is nothing you can really do since it doesn't reprompt for parameters.

You could have the users do a REFRESH and choose the export parameters then after it is previewed export it.

If you were to write your own application to do the viewing and exporting you could control the export through code.

There are third-party tools that can do this for you
http://www.kenhamady.com/bookmarks.html

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.