Solved

Shared numbervar in Crystal Reports - linking between groups

Posted on 2010-08-28
3
1,254 Views
Last Modified: 2012-08-14
Hi There,

In my main report, I have two groups. The first group is an ID number, the second is a group by month. Within group 2, I have a subtotal of another field. Essentially, for each ID number I can see a breakdown by revenue by month. I then have a subreport to pull in other information for a correlated ID field (also has the same two groups but the ID field is from a different table). Everything displays properly between the main report and the subreport however I need to use a shared numbervar so I can total the values from the primary report to the subreport at the group 2 level. When I try to use a numbervar, I am only seeing the last revenue number repeated for each month (in the attached screenshot I would only see 17387 repeated for each month). I have a reset formula in place but it doesn't seem to be working. The values in the attached screenshot are correct (the boxed data is the subreport values which are correct). I just need to know how to get a shared numbervar to show the correct value for each month. In other words, I need the monthly values to line up between the main and subreport.

Thanks!
J

Thanks!
subreport.png
0
Comment
Question by:jmugford
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 33551938
I don't fully follow what you are saying.

Where is the shared number showing the "wrong" value?

How are you setting it?

mlmcc
0
 

Author Comment

by:jmugford
ID: 33555604
Sorry for being so confusing. I had taken the shared numbervar out when it wasn't working. I have recreated the issue and included some additional screenshots. In 'mainreport_preview', the subreport data is contained within the 'box'. The data in blue within the box is the shared numbervar formula where I can see it is producing the correct data. The number in red is when I use the shared numbervar in the main report. For each group it only pulls the last value. I have also included two other screenshots - one of the main report design and one of the subreport design. I hope this helps to clarify.

Thanks!
mainreport-preview.png
main-design.png
subreport-design.png
0
 

Accepted Solution

by:
jmugford earned 0 total points
ID: 33561642
Hi mlmcc:

Just wanted to let you know that I figured this out. While I had linked my subreport I was convinced the problem was with the dates. What I tried was to create a formula for my group 2 (monthly summarized data) and then link this to the subreport field. When I did this, everything worked as it should.

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question