Home > Crystal Reports > Crystal Reports Shared Variable Not Working

Crystal Reports Shared Variable Not Working

Ken Hamady, On-site/Phone Crystal Reports Training/ConsultingQuick Reference Guide to using Crystal in VBhttp://www.kenhamady.com/ Red Flag This Post Please let us know here why this post is inappropriate. The behavior didn't change. However, the Shared Variables pass data incorrectly from the main report to the subreport.For example:When creating shared variables using the 'Shared' function in Crystal Reports:· Subreport -> Main report = correct This is the procedure for hiding a sub report which runs: 1.  Suppress all sections in the sub report.  Even if a section only contains white space, it must be suppressed. his comment is here

Also when using Crystal format statements should end with a ; mlmcc 0 Message Author Comment by:DKimzey2005-03-15 Comment Utility Permalink(# a13543924) mlmmc, Thanks - but no effect. Join them; it only takes a minute: Sign up Crystal Report Sub report Shared Variable is not returning to concern Group section up vote -1 down vote favorite Crystal Report Sub By joining you are opting in to receive e-mail. Shared is global with the added benefit of sharing with a subreport.

RE: Losing shared variable on drill down VensCH (Programmer) 11 Apr 05 16:00 Hi ToastyinVA,I guess i am having same problem what said in the first post, I am placing the Privacy Reply Processing your reply... RE: Losing shared variable on drill down TexasGal2 (Programmer) 6 Jun 03 12:45 It was for 7 and 8 but I see the other issue.It's not your suppression though because I Code ladder, Robbers Can spacecraft defend against antimatter weapons?

Please enter an answer. Business Objects http://www.businessobjects.com/ Support services http://support.businessobjects.com/ Show: Inherited Protected Print Export (0) Print Export (0) Share IN THIS ARTICLE Dev centers Windows Office Visual Studio Microsoft Azure More... You might give that a try 0 Message Author Comment by:DKimzey2005-03-15 Comment Utility Permalink(# a13545512) J Lazanowski, Thank you -- but no effect. Result Data Contact Info Main Phone 614-505-0770 Fax 614-505-0779 Address 110 Polaris Parkway Suite 100 Westerville, OH 43082 Email [email protected] Upcoming Special EventsQlik Ohio sponsored by Result Data (User Group)11-18-2016 (Friday)

This error also occurred if we paged through the report and then tried to page back to see earlier pages. Simultaneously if I display the value in the Main Header, it is false. 0 LVL 1 Overall: Level 1 Crystal Reports 1 Message Expert Comment by:jlazanowski2005-03-15 Comment Utility Permalink(# Learning resources Microsoft Virtual Academy Channel 9 MSDN Magazine Community Forums Blogs Codeplex Support Self support Programs BizSpark (for startups) Microsoft Imagine (for students) United States (English) Newsletter Privacy & cookies Should I trust a website which breaks when I use a complex password?

Connect with top rated Experts 10 Experts available now in Live! That meant that there were two copies of the same formula sitting in different parts of the the Report Footer. It redundant but everything worked just fine. my question is how to I clear/reset the shared variable after each record?Flanman IP Logged chris Newbie Joined: 02 Apr 2008 Location: United Kingdom Online Status: Offline Posts: 35 Posted:

The case of the Maid, the Son and the Butler Has a movie ever referred to a later movie? http://kenhamady.com/cru/archives/2369 If the sub-report always runs? As you found out if you suppress the subreport it no longer runs. Do you have separate formulas to accumulate and then display?Post the formulas.What sections are they placed in?Are you using "Keep Group Together" or "Repeate Group Header on each new Page" settings?

Check the suppress blank subreport checkbox. this content We'll send you an e-mail containing your password. Thanks. So the first instance of the formula gave the variable its value before the subreport had a chance to run.

  • The content you requested has been removed.
  • Don’t miss out on this exclusive content!
  • Suggested Solutions Title # Comments Views Activity Crystal Reports Sub Report 4 63 105d Left and Right Trim a field in Crystal Report 2 37 73d Dynamic Image won't display if
  • You set a variable false in a header before the sub-report is fired.
  • All rights reserved.
  • Not the answer you're looking for?
  • Jon Crowhurst February 13, 2009 at 15:56 PM 0 Likes Correct Answer Guest replied February 13, 2009 at 16:00 PM Hi Jon, Make sure that the shared variable which you are
  • What is the syntax to reset the variable to zero after each order number but still grab the calc from the next order in the subreport?
  • I wish to suppress (not show) the subreport on my main report; however I wish to use the values from the shared variables (4 total shared variables).
  • All formulas should be correct because the report works properly if each group is displayed in one page.

Click Here to join Tek-Tips and talk with other members! i.e. place a check mark in the "Suppress Blank Subreport" check box. 5. weblink This documentation is archived and is not being maintained.

All rights reserved. All Rights Reserved. It just would not work when the subreport was in the section where it needed to be, in RFB.

more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science

Crystal Reports uses a two-pass reporting process to provide greater … Crystal Reports Introduction to GIMP Video by: Kyle It is a freely distributed piece of software for such tasks as Please enter a reply. Describe your current report structure, the content of the subreport, how it is linked to the main report, and why you feel you need to use a subreport in the first Globals don't share (as I understand it).

RE: Reset shared variables in the main report kenhamady (Instructor) 16 Aug 01 22:30 If it is related to the patch (and your problem seems to fit the description) then there We had an error, which occurred when the report was compiled (or run through our front end), which caused the total to evaluate to 0.00 (or some other incorrect value), for RE: Reset shared variables in the main report JustineB (Programmer) 15 Aug 01 06:20 I had a similar problem a few years ago when using Crystal 6. check over here Send me notifications when members answer or reply to this question.

Registration on or use of this site constitutes acceptance of our Privacy Policy. Recommended Version This documentation is archived and is not being maintained. Over the years, the most common solution I have seen for hiding this type of sub report is minimization.  The report designer will shrink the sub report down to as small Also I put @Initialize formula to reset all shared variable in Group Header.

Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Ken Hamady, On-site/Phone Crystal Reports Training/ConsultingQuick Reference Guide to using Crystal in VBhttp://www.kenhamady.com/ RE: Reset shared variables in the main report YA (Programmer) (OP) 14 Aug 01 18:01 I checked Seagate Solves a lot of headaches for me... Join & Ask a Question Need Help in Real-Time?

share|improve this answer answered Jan 8 '13 at 23:58 EvilBob22 674412 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign