?
Solved

Shared numbervar in Crystal Reports - linking between groups

Posted on 2010-08-28
3
Medium Priority
?
1,303 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
  • 2
3 Comments
 
LVL 101

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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

571 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