All,
Is there a way to have code in an expression that refers to the name of the data item icon?
for example:
IF ([Business Layer].[Earnings Check History].[Earnings Code]=DataIconName ) THEN
( [Business Layer].[Earnings Check History].[Current Amount])
ELSE
(0 )
thanks in advance,
Andy
IF ([Business Layer].[Earnings Check History].[Earnings Code]='some_value' ) THEN ( [Business Layer].[Earnings Check History].[Current Amount]) ELSE (0 )
You have to refer to a specific value of Earnings Code to get a parsing If Then Else expression
yup, normally I would hardcode in the name of the earning code I want the $ amount for. But, some clients have 100+ earning codes which means 100+ columns and each one have to edit to put in the code. So, if there was a way to just update the name of the icon and refer to the icon in the expression, then I could shorten my dev time in 1/2...
No idea what you mean with 'icon' . Why do you not use a prompt to feed the right value to the query ?
I am confused by the reference to "icon" in your question also. Are you trying to transpose rows of data into columns? If so, would a crosstab layout work as an alternative? If you create 100 query calculations and then come across a situation where there are 101 you'd have a problem.
sorry, obviously doing a poor job describing what i need. i will try again.
1. In Query Explorer, I have a Query.
2. Inside this Query, I have Data Items.
3. I dragged a new Data Item from the Toolbox into the Query.
4. I named this new Data Item 'Overtime'
5. Inside the expression for the data item, I have code that basically says if earning code in the dbase = overtime then show me the $ amount.
6. I am looking for a way to change the code to refer to the name of the Data item the code is in. So, if earning code in dbase = nameOfThisDataItem then show me the $ amount.
hope that makes more sense!