Skip to Content
0

Crystal Report - on Cross tab calculation and how to save the values calculated in Crosstab

Feb 27, 2017 at 01:38 PM

125

avatar image
Former Member

Hello,

Am using crosstab concept, please find the attachment which shows my report design.

In this, I would like to display the addition of Row and Column 'Difference' columns within the crosstab as a new Row and Column and also i need to store these values Outside the crosstab because here am trying to build a complex report with many calculations or manipulation. So I need these addition of Row and Column value of 'Difference' columns outside the cross tab as well (i.e., how to save or store the values calculated from Cross-tab concept?).24feb-2.jpg

24feb-2.jpg (33.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

14 Answers

Abhilash Kumar
Feb 27, 2017 at 01:43 PM
0

Hi Kayalvizhi,

Please attach the report with saved data.

This is going to need some calculations and I prefer to try them directly on your version of the report.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 27, 2017 at 02:04 PM
0

Sure Abhilash. I will do that.

One question, Is it possible to save or store the values derived from Cross-tab within the subreport ?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 28, 2017 at 09:02 AM
0

Hello Abhilash,

How do I attach the report? It is not allowing me to attach .rpt file.

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Feb 28, 2017 at 09:42 AM
0

Save it to Google Drive and send me the URL.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 01, 2017 at 09:45 AM
0

https://drive.google.com/file/d/0B0B4TeDAWfj8RmJJSndKV2ZXRUE/view?usp=sharing (Please remove the link from the post once you are able to download)

Is it possible to save or store the values derived from Cross-tab within the subreport ?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 02, 2017 at 12:37 PM
0

Hi Abhilash,

Could you please tell me the outlook date when you will share the results? ( sorry for pressurizing you, as i have my own deadline )

And also please let me know is it possible to save or store the values derived from Cross-tab within the subreport ?

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Mar 02, 2017 at 01:38 PM
0

The report you posted doesn't have saved data.

Could you please re-post and ensure it has data.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 02, 2017 at 01:47 PM
0

I have checked on "Save Data with Reports" and ran the report using Preview Sample. And thought it would save the Data.

Could you please tell how to do it?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 03, 2017 at 06:16 AM
0

https://drive.google.com/drive/folders/0B0B4TeDAWfj8dnNReGdtcnh2R0U?usp=sharing

Please check this and let know me. I have also attached the parameter input file.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 03, 2017 at 10:59 AM
0

Is it possible to save or store the values derived from Cross-tab within the subreport?

Share
10 |10000 characters needed characters left characters exceeded