AspWebSolution Forums » Products » ASP Report Wizard v2 » Calculated Total Columns

index | search | no replies | posting guidelines | help

login | register

» »

:: Calculated Total Columns :: (12)

Post a New Message | Post a Reply

May 6 2005, 6:57 AM

Calculated Total Columns

Dreamer

from: New York I created a report called Paul's Order Detail Report, I placed the following in the Discount column - [eval](Math.round((({{SUM_2}}-{{SUM_1}}) /{{SUM_1}}*100)*100)/100)[/eval] %

Please run the report and NOTICE that the TOTAL at the bottom for that column is NOT the real total of the Calculation. It is rather a total of the information that exists in the database. Why does it not give me the total of [eval](Math.round((({{SUM_2}}-{{SUM_1}}) /{{SUM_1}}*100)*100)/100)[/eval] %

at the bottom??

May 6 2005, 1:23 PM

Re: Calculated Total Columns

ghost

from: Washington, DC This is because the eval tag is handled by javascript (front-end) meanwhile the column totals are processed by the server.

I will see if something can be done about this.

-------------------------
Ghost

May 20 2005, 3:57 PM

Re: Calculated Total Columns

ghost

from: Washington, DC This functionality has been added as of the latest version (v2.5.35).

Note: Only the evel tag can be put into the TextReplacement
e.g.
[eval](Math.round((({{SUM_2}}-{{SUM_1}}) /{{SUM_1}}*100)*100)/100)[/eval]
and not
[eval](Math.round((({{SUM_2}}-{{SUM_1}}) /{{SUM_1}}*100)*100)/100)[/eval] %

-------------------------
Ghost

May 23 2005, 5:53 AM

Re: Calculated Total Columns

Dreamer

from: New York Is it safe to apply the latest version for this calculated column fix? I noticed that there were some issues with the dropdowns, please advise.

May 23 2005, 6:12 AM

Re: Calculated Total Columns

ghost

from: Washington, DC While we are still testing, we have not been able to re-create any of the bugs mentionned about the drop downs

-------------------------
Ghost

May 23 2005, 10:14 AM

Re: Calculated Total Columns

Dreamer

from: New York see the change that you made and tested it out. It is totalling the SUM of the percentages in each ROW. However this IS NOT what should be happening. The calculated column is as follows..

[eval](Math.round((({{SUM_2}}-{{SUM_1}}) /{{SUM_1}}*100)*100)/100)[/eval]

What should happen is that the Total of the Sum1 and Sum2 rows should be what is calulated in the Percentage column.

for instance.

2004 Sales 2005 Sales Percent
1,000 2,000 100%
3,000 5,000 666%

Total 4,000 7,000 750%

In your calculation, you add up the 100% and 666% and ger 766% when it should really be 7,000 - 4,000 / 4,000 = 750%

Unless I am missing something, please advise,,,,

May 23 2005, 10:22 AM

Re: Calculated Total Columns

Dreamer

from: New York Bottom line is that I need the following formula

eval](Math.round((({{SUM_2}}-{{SUM_1}}) /{{SUM_1}}*100)*100)/100)[/eval]

to be executed against the Total Row numbers.......

May 23 2005, 4:20 PM

Re: Calculated Total Columns

ghost

from: Washington, DC No you are not missing anything. I will see what we can do about this as soon as possible.

Can u please send me a sample dataset - text file will be okay

-------------------------
Ghost

May 23 2005, 5:04 PM

Re: Calculated Total Columns

Dreamer

from: New York Sent a sample to admin@aspwebsolution.com

May 24 2005, 5:28 AM

Re: Calculated Total Columns

ghost

from: Washington, DC send it to support@aspweb....

-------------------------
Ghost

Jun 3 2005, 9:25 AM

Re: Calculated Total Columns

Dreamer

from: New York The Calulated columns (any eval code in the text replacement) does not carry over to a save as Excel. When I view a report in the screen in a browser and then click on the Excel Icon, all data comes down into excel EXCEPT the Calculated columns, they show what is actually in the Database and NOT te result of what was Calculated.

Jun 3 2005, 10:31 AM

Re: Calculated Total Columns

ghost

from: Washington, DC The export buttons export the dataset. They do not convert the report into an excel document.
I will see if document conversion can be added

-------------------------
Ghost

Pages: (1) [1]