Shared numbervar in Crystal Reports - linking between groups

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
jmugfordAsked:
Who is Participating?
 
jmugfordAuthor Commented:
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
 
mlmccCommented:
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
 
jmugfordAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.