Solved

Shared numbervar in Crystal Reports - linking between groups

Posted on 2010-08-28
3
1,246 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 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

777 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