Hi all,
BO5 and Oracle 8
We have a report which returns Sales Value for a customer. The user is prompted to enter the “Customer” number and the “Year” and then sales values are returned for the customer for both the selected year and year-1 (i.e. previous year).
Hence we get columns
Customer, Sales Year, Sales Month, Sales Value showing records for both 1998 and 1999.
We now want top add additional columns, Sales Value for Year 1999 and Sales Value for Year 1998 for purposes of obtaining cumulative values and so on.
In the formula for the new column I’ve tried = where (=1999) and this works fine.
But ideally I don’t want to hard-code my year here, I want to use the value the user entered at the prompt. I tried
= where (=UserResponse("Query 1 with DATestUn,“Year”)
but got a syntax error, and also tried
= where (=ToNumber(UserResponse(“Query 1 with DATestUn”,“Year”)
and still got a syntax error.
I then tried defining a Variable in my report YearSelected with a formula =ToNumber(UserResponse(“Query 1 with DATestUn”,“Year”) and then tried to use this variable in the above column formula but that also gave a syntax error.
I’ve read posting about creating a User Object on the universe to hold the value but I can’t get this working either.
Any help would be greatly appreciated.
Thanks
Darren Anderson
Client Services Manager - QI/LSR-De
Listserv Archives (BOB member since 2002-06-25)