Solved

Shared numbervar in Crystal Reports - linking between groups

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now