I need to display a report on the pdf based on the database query result. The thing is My query is working fine. I'm using queryMultipleToXML. The 'test' is giving proper data in the SQL statement. The output of this is being assigned to an XML Variable A. I'm using mapping after this step. I'm mapping this A to a textbox in the pdf with xml binding(string for that field).
Problem is nothing is getting displayed on the pdf form. The problem it seems is the data from sql query result is not getting assigned to A whose type is xml.
Can Any body help me? I want to assign a database query result into a form textbox. if any sample please let me know.
Actually I was expecting something but it turned out to be something else!!!
The flow is like this.
QueryMultipleToXML (A) -> Set Value (B ) -> Assign Task (C)
My requirement is: From A i'll get data, in B, i'll map raw data from A to form element which i'll process while rendering the form. In C i'm assigning the form to a user.
I was expecting data to be displayed on the report table when user logs in and starts a process (on the displayed form). But what is happening is, the data is not getting displayed there. If the user completes that form, then the form will go to his 'To Do' list. If he opens that then the data is being displayed (on the displayed form).
Is there any way that i can show the data whenever the users starts the process?
Thanks a lot for your kind reply and time.
Actually i was not going further(completing on the start process). So I was thinking that data is not coming to the form.
My question is not of variable. if u look at the thread from the beginning. The functionality is working perfectly fine. All that i need is the query result needs to be assigned to a textbox in the form before it gets rendered first.
I WANT TO KNOW WHAT SETTINGS I NEED TO DO ON RENDER SERVICE? in order to have data displayed on the form on its first display.