Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to give users possibility to choose date by themself. After choosing date they will reload data - and get required data.
For example I have report with two dates. I want before reload user with thin client choose date and then reload this file.
Is it possible and how to do it ?
Hi
Ya it is possible to choose the date before the reload from the qv file and reload using the variable in the qv
script.
just create the varialbe in the script and use that variable in the qv sheet and assign the value of user
selected date into that variable and reload it
Regards
Ashok
Hi
example
Let vClientSelectedDate= $(variableName); holds the client selected date value
EmployeeDetails:
SQL SELECT
"Emp_name",
"Emp_Sal",
"Audit_Action",
"Audit_Timestamp_ChangedDetails"
FROM dbo.Employee_Test_Audit
WHERE Audit_Timestamp_ChangedDetails >= $(vClientSelectedDate);
Thank you chandashok,
I am trying do it. I will inform you about results.
Many thanks.
Dear chandashok,
I wrote this:
Let vClientSelectedDate= $(variableName);
SQL SELECT *
FROM "BS_DWH_DS".CUSTOMER
WHERE date >= $(vClientSelectedDate);
But when I made reload I got the follow error:
SQL error: ORA-00936: missing expression
Script line: SELECT * FROM "BS_DWH_DS".CUSTOMER WHERE date >=
SQL SELECT *
FROM "BS_DWH_DS".CUSTOMER
WHERE date >=
Please advice what is the wrong ?
Could you send me one example file ?