I have created a Initialization block named Budgetary_Control
the query entered in the data source is
then i selected a connection pool and tested with 2 USER
and it gave me expected result.
in the Edit data target i gave a name to this variable as S_Budgetary_Control and a default valus as -1
i checked on row wise initialization test again
it show me multiple record.
the i save the rpd and deployed the same to the server.
now when i trying to create a report using this varriable like VALUEOF(NQ_SESSION.S_Budgetary_Control) it gave me error like
[nQSError: 23006] The session variable, NQ_SESSION.S_Budgetary_Control, has no value definition.
Please help me to get rid of this issue.