I have a main report with about 10 fields and a subreport with about 7 fields. When I export the report to excel the fields from the subreport do not export. The sub report is basically made up of lots of formulas. I am using crystal 6. Is this possible to do or what are my other options. Secondly can a variable from the subreport be passed to the main report. Thank you for any suggestions you can offer.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
EXPORTING A SUBREPORT
- Thread starter villica
- Start date
Hey Villica,
Crystal Exporting to xHell = BLECH!
(just wanted to state that publically)
We've been trying to find ways to export our reports with formulas and subreports to xHell, and we've discoverd that...well....unless you have a VERY basic report, which is formatted the way an xHell sheet would look, and doesn't have overlapping fields, and doesn't contain any subreports, it'll work. Otherwise, FORGETTABOUTIT!
You either have to retool your report (ours was way too complex to do, but yours might not be as bad?), or what we ultimately did which was to re-create the data within vb and create teh xhell sheet from that.
Crystal has some really good materials available online that deal with exporting. If you go to the crystal decisions site>self serve help and enter Export Excel in the Ask Jeeves box, it should bring up a list which incldes a document that details how to best get your reports to export to xHell properly.
As for your second question, just declare the variable as Shared within the formulas in teh main and subreport, and you should be able to share them (we use shared varaibles all the time in ours).
Hope this helps,
Jack
Crystal Exporting to xHell = BLECH!
(just wanted to state that publically)
We've been trying to find ways to export our reports with formulas and subreports to xHell, and we've discoverd that...well....unless you have a VERY basic report, which is formatted the way an xHell sheet would look, and doesn't have overlapping fields, and doesn't contain any subreports, it'll work. Otherwise, FORGETTABOUTIT!
You either have to retool your report (ours was way too complex to do, but yours might not be as bad?), or what we ultimately did which was to re-create the data within vb and create teh xhell sheet from that.
Crystal has some really good materials available online that deal with exporting. If you go to the crystal decisions site>self serve help and enter Export Excel in the Ask Jeeves box, it should bring up a list which incldes a document that details how to best get your reports to export to xHell properly.
As for your second question, just declare the variable as Shared within the formulas in teh main and subreport, and you should be able to share them (we use shared varaibles all the time in ours).
Hope this helps,
Jack
- Thread starter
- #3
thank you for your reply, I wil try what you have suggested. I have look for share on the help crystal 6 and I can't find it. How do you declare it the variable using share. My very first report using crystal has turn out to be a nightmnare.
thanks.
thanks.
What you do is create a forumla field. In this field you can declare variables in either Crystal syntax or Basic syntax. Whichever you choose, just put the word Shared in front of it. This makes the variable available accross the report. Whenever you want to use the variable (whether showing the value or assigning the value), just plop in a formula field and declare the variable again.
Jack
Jack
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question