Subreport issue

[Former Member]

Raghavendra,

Here's the new thread. Sorry, I feel silly, but I'm new to this whole forum thing! If I understood you correctly, I'm going to move the shared value on my main report to the Group Header and keep the variable in my subreport in GF1 & 2 (GF2 is a running total on all the payments, GF1 is the running total for the client.)

I still can't thank you enough for all your help and most importantly patience with me!

Thanks,

James

[Former Member · Accepted solution]

No! You need to keep the formula that exist in subreport in header section but not in main report

Regards,

Raghavendra

[Former Member · Accepted solution]

For some reason that didn't work... Could it be my groups? The subreport is grouped by entered date and client name. The main report is grouped by call date and client name. Both date groups are for each week.. Also, I'm not sure if this makes a difference, but my main report I have everything suppressed except one client. The end goal is to have one report for each client, so they can see their account volumes by week...

Thanks again for all your help!!

James

[Former Member · Accepted solution]

Raghavendra,

Hope everything is well with you. Just checking in to see if you had any other suggestions for me to try. With your help I'm almost there! I just can't seem to get it to calculate correctly.

Thanks!

James

[Former Member · Accepted solution]

Hi James,

Did you check the formula output in subreport after placing it in the group header in subreport?

Regards,

Raghavendra

[Former Member · Accepted solution]

Hi Raghavendra!

Thank you for responding! I was beginning to think you lost your patience for me! When I tried putting it in the header I get the same result. Please see attached screen shot...

http://www.transferbigfiles.com/Get.aspx?id=1b3c4c93-99aa-46cb-a480-2d463e8ec57e

I've been trying to do other research, and with what I'm trying to accomplist would it be possible to use a croos tab, or something like that, or is the subreport the best way to go?

Thanks,

James

[Former Member · Accepted solution]

Hi James,

Lets work on subreport only. Now try to refresh the subreport and see the value you are getting in group header. Please attach the screenshot of subreport preview and screen shot of the formula placed in group header in subreport by editing it.

Regards,

Raghavendra

[Former Member · Accepted solution]

Raghavendra,

I had to block out the names of the clients for security purposes, here's just the subreport, and the two formulas:

http://www.transferbigfiles.com/Get.aspx?id=947f058c-0af5-45e5-9fe0-313004be76e2

Thanks,

James

[Former Member · Accepted solution]

Which formula did you place in group header? (@SpeedPays/@GT SpeedPays) also let me know what is {#GT Weekly}? is it a running total?

Regards,

Raghavendra

[Former Member · Accepted solution]

Raghavendra,

@SpeedPays is in the group header, {#GT Weekly} is a Running Total that counts the number of payments and resets on Group 1, which is entered date.

Thanks for your help!!!

James

[Former Member · Accepted solution]

Ok now I see different values in the subreport as seen in the screenshot. Can you tell me which value you want to pass to the main report? I think it is a running total value right?

Regards,

Raghavendra

[Former Member · Accepted solution]

The values I would like to pass to the main report would be the the total number of payments for a specific client @SpeedPays The main report is suppressing all clients except one. I also would like to display the total number of payments for the group period. I attached a screen shot of the desired result..

http://www.transferbigfiles.com/Get.aspx?id=f7170f9f-76bc-4d13-9b3f-b066ef726c4a

So, the "48" in the Client name line would be the total of payments for that particular client for the week, and the "48" in the All Clients field would be the total of all payments for that week.

48 is the last total for that client, but it's not showing the total for the week.. For example it should be:

03/01

79

389

03/08

92

516

Etc..

Thanks!

James

[Former Member · Accepted solution]

But in your subreport I don't see 48 for 03/01? Is your subreport data is linked with client name?

Regards,

Raghavendra

[Former Member · Accepted solution]

Yes, 48 is the total for that client for the week of 03/29/09. For that week it should be:

Client 48

All Clients 304 just for that week.

It's not in the screen shot because it's page 3 of the preview.

Thanks!

James

[Former Member · Accepted solution]

subreport is showind data for all clients but not for each client?

Regards,

Raghavendra

[Former Member · Accepted solution]

The subreport is displaying the payments by client:

In your screen shot:

Client 1 13

Client 2 2

Client 3 1

Client 4 10

Thanks!

James

[Former Member · Accepted solution]

I think you placed you subreport in group footer of client name in main report. But why you are showing all clients data for each client in main report instead of showing only one client by linking with client name in subreport links?

Regards,

Raghavendra

[Former Member · Accepted solution]

Yes, the subreport is in GF2a in the main report. The reason I'm doing both is when you look at the main report the client can see what we did for them and how we did as a roll up with all our clients

Thanks!

James

[Former Member · Accepted solution]

But you are suppressing the subreport in GF2a so I think it is better to link the client name field from main report to subreport so that we will get the corresponding data related to each client in subreport and pass the value to main report.

Regards,

Raghavendra

[Former Member · Accepted solution]

I do have the subreport and main report linked by client name, I believe that's how I'm picking the "48". 48 is the weekly total for the client that the main report is showing. The problem with that is 48 is for the week of 03/29. It's not showing 79 for 03/01, 92 for 03/08, 90 for 03/15, and 115 for 03/22...

Thanks!

James

[Former Member · Accepted solution]

I think we are missing a small line in the report but I'm still unable to understand what it is happening at your end. If possible raise a ticket with SAP Support portal.

Regards,

Raghavendra

[Former Member · Accepted solution]

I'm not sure how to do that... Not to ask a dumb question, but what will that do for me?

I still can't thank you enough for all your help with this!

Thanks!

James

[Former Member · Accepted solution]

If you are a registered Customer then you can raise a ticket by loging in service market place.

[www.service.sap.com]

Regards,

Raghavendra

[Former Member · Accepted solution]

I'm not a customer of SAP, I thank you for trying to help me anyway! Believe it or not I did learn some things I didn't already know!

Thanks again!

James