Page 1 of 1
Calculated column in DataSource from other DataSource
Posted: Wed Aug 14, 2013 5:33 pm
by jmgardn2
I have two datasources set up. One from a SQL connection (DataSource1), and the other one as a virtual datasource from DataSource1. I have a grouping set up in the virtual datasource with a result using the Avg aggregate function. I added a calculated column to the virtual datasource to take the Avg column and multiply it by 100. However, when I view the data or attempt to use the calculated column it is blank. Any suggestions would be appreciated.
Re: Calculated column in DataSource from other DataSource
Posted: Thu Aug 15, 2013 11:15 am
by Alex K.
Hello,
The Calculated columns may be used only for showing in report. The "View Data" does not show the data from calculated columns.
Thank you.
Re: Calculated column in DataSource from other DataSource
Posted: Thu Aug 15, 2013 1:05 pm
by jmgardn2
Thanks Aleksey,
The view data issue makes sense. However, if I use the calculated column in my chart, I don't get any data. Using a databand I can see the data is showing properly, however the calculated column doesn't appear to be working within a chart. Is this not supported?
Re: Calculated column in DataSource from other DataSource
Posted: Fri Aug 16, 2013 7:10 am
by Alex K.
Hello,
The calculated columns have limited functionality.
Please try to add the necessary column in your original query.
Thank you.