Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Shared Variable Exports Zero (0) to Excel

Shared Variable Exports Zero (0) to Excel

Shared Variable Exports Zero (0) to Excel

We are using Crystal Reports XI release 2 (bundled with MAS500). I've added a subreport to the page header section of my main report. I also created a shared variable in the subreport and corresponding shared variable in the main report. The shared variable is placed in my Group Footer #2 section and when previewing the Crystal Report, the CORRECT VALUE is returned. However, when I export this same report to Microsoft Excel, the value of the shared report is zero.

Has anyone seen this before?


RE: Shared Variable Exports Zero (0) to Excel

Using Crystal Reports 2008 the same behaviour seems to occur i.e. a formula using a shared variable from a sub-report placed in the Page Header section fails to export correctly to Excel when choosing Microsoft Excel (97 to 2003) Data Only.

I tried it with a shared stringVar and I got the same issue - this time it exported blank text as opposed to a 0.

I moved the sub-report to the Report Header and it exported the formula with the shared stringVar successfully.
I then moved the sub-report back to the Page Header and it is now exporting successfully.

So that may be a simple fix for the problem (bug?).


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close