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.
Did Jasmin's suggestion solve your issue? If not let us know!
Cardinal Solutions Group
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.