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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.