Calculate column in Data from other Data Source

jay@bplogix.com · Post by **jay@bplogix.com** » Wed May 11, 2011 12:36 pm

I cannot seem to add a calculated column to a datasource that is of type "Data from other Data Source". Are calculated columns supported in these datasources?
thanks

Post by **Alex K.** » Thu May 12, 2011 2:07 am

Hello,

Unfortunately, on the current moment, calculated columns not supported in the "Data from other Data Source" datasources.

Thank you.

jay@bplogix.com · Post by **jay@bplogix.com** » Mon Jun 13, 2011 9:53 pm

Is there any workaround for thuis? In need to make calculations based on the data in the "Data from other Data Source"

For example, how can I set up a report that has this as the input data:
User Sales_Cat_A Sales_Cat_B
Jay 100 0
Jay 200 50
Bill 100 200
Jay 0 100
Bill 100 200

I want to show each user, the total sales they had in Cat_A, the total sales in Cat_B, and the percent sales that were in Cat_A. Very easy to create a "Data from other Data Source" and group by "User", use Sum for Sales_Cat_A and Sales_Cat_B.
User Sum_Sales_Cat_A Sum_Sales_Cat_B Percent_Sales
Jay 300 150 200%
Bill 200 400 50%

Normally the Percent_Sales would just be a calculated column with a simple formula. How do I accomplish something like this when using "Data from other Data Source"?

thx,
Jay

Post by **Ivan** » Wed Jun 15, 2011 4:51 pm

Hello,

Please check the sample report in attachment.
Also for the correct work of this report, please use the next prerelease build from 22-May-2011 when it will be available.

Thank you.

jay@bplogix.com · Post by **jay@bplogix.com** » Wed Jun 15, 2011 8:23 pm

Hi,

I get this error when I run the report:
Error running report: Object reference not set to an instance of an object.

I am using the pre-release from today SW_2011.06.15.

Also, when I edit the properties of the datasource, it deletes my calculated column.

Thanks

Post by **Ivan** » Thu Jun 16, 2011 5:31 pm

Hello,

[quote="jay"@bplogix.com]I get this error when I run the report: .....[/quote]
Please use the next prerelease build from 22-Jun-2011 when it will be available.

[quote="jay"@bplogix.com]Also, when I edit the properties of the datasource, it deletes my calculated column.[/quote]
The problem is solved.
The patch will be available in the next prerelease build from 22-Jun-2011.

Thank you.

jay@bplogix.com · Post by **jay@bplogix.com** » Thu Jun 23, 2011 1:35 pm

I just tried the new build and when I edit the datasource, it still deletes all of my calculated columns.

Post by **Vladimir** » Fri Jun 24, 2011 8:46 am

Hello,

This error was fixed for Win designer.
We have fixed this error also in the Web designer, the update will be available in the next prerelease build on June, 29.

Thank you.

jay@bplogix.com · Post by **jay@bplogix.com** » Tue Jul 05, 2011 5:59 pm

I just installed the latest pre-release and the bug is still there.

When I add a calculated column to a Data from other Datasource, it adds correctly. BUT when I view the properties of that datasource, it deletes all of the calculated columns!

Was that supposed to be fixed?

Jay

Post by **Vladimir** » Wed Jul 06, 2011 7:27 am

Hello, Jay

Sorry, this fix was not included in previous prerelease build. It will be included in a prerelease build on June, 7.

Thank you.