Crystal Report, Group based Summary at report footer

Posted by yesosuresh on Stack Overflow See other posts from Stack Overflow or by yesosuresh
Published on 2010-06-07T07:03:23Z Indexed on 2010/06/07 7:12 UTC
Read the original article Hit count: 531

Filed under:

crystal-reports

|

footer

|

crystal

|

crystal-report

HI,

Is it possible to display summary of a group at the report footer ? Let me explain the scenario. I've to create the following kind of report:

Client    Amount    Currency 

Customer 123:

WWWW       300         SGD
XXXX       400         SGD
YYYY       200         USD
ZZZZ       300         USD


Customer 456:

W1W1       300         SGD
X1X1       400         SGD
Y1Y1       200         USD
Z1Z1       300         USD

.
.
.
.
.

At the report footer, I need to show the following:

Grand total: USD        1000
Grand total: SGD        1400

Need to display grand total of amount by Currency at Report footer.Is it possible to do in Crystal report? I'm using crystal report version 11. Could anyone suggest me a solution ?

© Stack Overflow or respective owner

Related posts about crystal-reports

Crystal Reports: Save Time with Formula Sharing

as seen on ASP alliance - Search for 'ASP alliance'
Once a report library grows to a certain size there are always going to be common formulas which are needed repeatedly. Having easier access to them can save a lot of development time. >>> More
Automate delivery of Crystal Reports With a Windows Service

as seen on ASP alliance - Search for 'ASP alliance'
In this article, Vince demonstrates the creation of a Windows Service to automatically run and send a Crystal Report as an email attachment. After a basic introduction, he examines the creation of the database and windows service with the help of relevant source code and explanations. Towards the… >>> More
Crystal Reports for VS deployment to Web Application doesn't work (3 replies)

as seen on .NET 247 - Search for '.NET 247'
I've followed the "documentation" for getting crystal reports to work on a production web site. I've migrated a VS 2003 web project to a VS 2008 web application. Everything works fine on my dev box. publish the site out to the server (2003 X86) and no go on the reports, get the infamous:… >>> More
Crystal Reports: 5 Tests for Top Performance

as seen on ASP alliance - Search for 'ASP alliance'
Your masterpiece report is now complete. It doesn't just meet your customer’s expectations, it blows them out of the water. All they want is a beautifully-summarized report that can be displayed in a myriad of ways. Then disaster strikes! You try to run the report for a month against the live database… >>> More
Crystal Reports for VS deployment to Web Application doesn't work (3 replies)

as seen on .NET 247 - Search for '.NET 247'
I've followed the "documentation" for getting crystal reports to work on a production web site. I've migrated a VS 2003 web project to a VS 2008 web application. Everything works fine on my dev box. publish the site out to the server (2003 X86) and no go on the reports, get the infamous:… >>> More

Related posts about footer

Symfony 1.4 Layout footer glitch: Footer div is echoed out with $sf_content

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a very simple Layout for my application. A header, the main content, and a footer. Semantically, they are rendered like this: <body> <div id = "header"> </div> <div id = "content"> </div> <div id = "footer"> </div> </body> The corresponding… >>> More
Jasper report->If page footer data over flows then it should print in next page footer

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to print textfield, which lenght is more than 4000 characters. I put the text field in page footer and trying print data in page footer, but when data over flows its not printing in next page. Can anyboday have idea, please reply me. Thanks, Raj >>> More
How to let short content pages reach the bottom of the browser window and then a footer should appea

as seen on Stack Overflow - Search for 'Stack Overflow'
In this case, I've developed a CSS code for this web application ..and sometimes the resulting data is too small and the footer of the site appears in the middle of the page and looks odd. I'd like to push that whitespace of the background to the browser's bottom and then followed by a footer.… >>> More
How to manually patch Blogger template to use Disqus

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to add disqus to my blog and I tried following this guide to do so: http://disqus.com/docs/patch-blogger/ However their instructions are completely off with what I have on my custom template. Here is the template: <b:skin><![CDATA[/*----------------------------------------------- Blogger… >>> More
Putting (WordPress) tags in <footer> tag, good for SEO or not?

as seen on Pro Webmasters - Search for 'Pro Webmasters'
I am using tags for my posts on my WordPress site. The content of my post is set in <article> tags, which is fine and now, I want to put the author link and tags in a <footer> tag, but I don't know if this is good for SEO reasons. I know that Googlebots are putting less weight if they… >>> More