Solved

Use running total as column field for Cross-tab

Posted on 2009-07-01
9
574 Views
Last Modified: 2013-11-15
Hi,
I want to create a cross-tab where each column has the same record number of each group.
Meaning that the first record in every group will be in the same column, and so the second and the thrid records of every group will be in the same column respectively.

So what i mean is a running total that resets upon change of group.
i have created a running total (both with crystal and a manual running total) and tried it but its not available for the cross-tab.

Maybe i'm using the wrong approach, but all other fields i have to use as column are number fields or date fields. these wont work. the numbers dont have any particular order they are just a value for that record. as for The date, it will force to put them in groups of date (monthly, daily, every second) but wont help to get records in the same column.

How can i work around this?

thanks
CRM
0
Comment
Question by:carlosmonte
  • 4
  • 3
9 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 24759546
Have you tried doing that using the running total field as the column header?

mlmcc
0
 
LVL 1

Author Comment

by:carlosmonte
ID: 24763545
that is exactly what i want and what i tried but doesnt work.
i could create a command query and add such numbers to the records but i'm sure there must be a way to do it in the report
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 450 total points
ID: 24766395
I think the problem is when cross tabs are built.  They get built before the report is run and running totals are calculated.

This idea might work
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40e7130d-aa1e-2b10-ce9f-eee2a54ff4cd

mlmcc
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 1

Author Comment

by:carlosmonte
ID: 24767911
looks promising.
i will try it early next week (going away for 4th of july!)
i'll let you know if it works
Thanks,
CM
0
 
LVL 1

Author Comment

by:carlosmonte
ID: 25101865
Michael,
i got it to work from the article you sent me. Thanks.
the only other thing i wanted is to better understand how this works.
i understand how the field values are passed to the subreport but i dont understand how the cross-tab reads those split values as a field./column coming from the DB.
Can you explain a little?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 25102217
It really doesn't read them as coming from the database.

Each record from the database is read and the formulas are executed for each record.  The formulas pull the correct value from the arrays.

mlmcc
0
 
LVL 1

Author Comment

by:carlosmonte
ID: 25102586
Thanks
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
bank transaction downloader ? 1 41
VB RDLC Report 1 75
Crystal Reports - group header 2 30
report returning null 21 52
1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

747 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

9 Experts available now in Live!

Get 1:1 Help Now