I’ve checked BoL and the “add data set” section shows “advanced” but not “computed column” option.
When creating/editing a data set and selecting “computed columns”, the prompt text says “
#Data of the data set is present in data frame with name data.
#You can return dataframe or individual vectores and it will be added into the data set.”
I’d like to compute a column based on two columns that come out of “EXEC Lic_CUR_GetLicenseUsage 29” (part of the license summary report but cannot find any syntax.
Best answer by Chris Sunderland
From the sound of your request, you probably want to use a Post Query Filter here. The Computed Columns section is for R scripts.
With the Post Query Filter, you can write another SQL query that executes against your stored procedure results and creates a view around it.
So you could write something like
select col1, col2, col3, (col4 + col5) / 100 As ComputedColumn from $this$
We are missing information about that Compute Column section for Database data sets. We’ll have to speak to the Development/Test team to gather information about it. I created MR 317336 so we can add Compute Column to the Report Builder documentation. Thanks for identifying this gap
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.