How to find the query that generates print preview?

[Former Member]

Hello,

How can I find the query that gets executed to generate print preview? On SAP Business One client if I open a Sales Quotation and click on print preview a report is generated. What queries are run in the background to generate this report?

Thanks for your help.

Regards,

Sheetal

[Former Member · Accepted solution]

Hi Sheetal,

In such cases i am using a Profiler which is connected to my company's database. If you are using SQL-Server, the start the "Profiler", connect it to your database server and start the trace. When the trace is running, execute the SBO action. After you executed this action you will see in the profiler the excuted SQL-Statements.

Regards,

Christian

[Former Member · Accepted solution]

Thanks Christian.

Yes the Profiler helped me find the query that gets executed.

Is there a better way to get the queries that generate the standard reports?

Regards,

Sheetal

[Former Member · Accepted solution]

Hi,

i don't know a better way. May be someone else. If think watching what happens at the database is a good way because there are no effects from other programs.

Regards,

Christian