What is the best way to make reports that looks in one way when you look at them as reports but then have another look when you export them to Excel?
I've made a report where I have several fields that I only want to have when I export the report. I have inserted them on the report and set the width to 0, and it works fine while in CR Developer. In CR Developer the fields have width 0 in the preview but when I export it to Excel the values show up in the columns where I want them, exactly as I wanted it!
The problem is that when I upload the report to our Crystal Reports Server XI and generate the report from there, the fields don't have width 0 anymore but show up fully visible!
All ideas are welcome!
(I've also have to put several empty text objects, so the headlines and such have been moved to the correct columns)
IP Logged
