Report within a datawindow control

[beti]

I need to show a report on a datawindow control. when I created the report,it was able to retrieve the data (preview mode), However, when i embedded into the datawindow control and run the application, it can not load the data. Only the labels and title of the report shown. Can anyone answer my question??
Thanks

 

[jcura]

Did you explicity retrieve the data?
For instance in the window open() event

Code:
dw1.retrieve()

 

[beti]

Dear jcura,

I'm new to the PB6...so I don't really understand what you meant "explicity retrieve"!

I used a open() event on the application to open the Window. Then I just use the the "DataWindow" icon to open the report inside the Window.

Can you please tell me more on how to display the data on the report within the Window. Thanks

 

[jcura]

You have an application that open's a window with the report, in the open() event of the window you put:

dw_name.retrieve()

where dw_name is the datawindow name
and that should get the data that you see on preview mode... (I hope ))

 

[Kuttipulikal]

Beti,

Jcura is correct but forgot to tell you about
SetTransObject.

Use the following code in your window's open event.

dw_1.SetTransObject(SQLCA)
dw_1.Retrieve()

In order to use SQLCA as transaction object you should
populate it before using it in your application.