want to change the design of a report in query print layout

[Former Member]

i want to change the design of a report.

[Former Member]

You can do chages in the QLD as in the same way Changes done in PLD.

if you chaged query you need not to create new Query Report.you can update that report.

There is one Field in RDOC Table named "QString".

Whatever SQL Query you are using for creating report that query will stored in this column.you need to update that column with the new query only.Report will automatically gets reflected.

Hope this will hlp you .....

lg Mahendra

[former_member187989]

hi singh,

I think what you mean is you want to change the place of

condition variables while print preview.

You should modify condition variables('[%0]' etc..) according

to requirment in the query what you saved in query manager

save the query in new name.

Create a new report using the query in QPLD.

Jeyakanthan.

[former_member187989]

hi singh,

If you want to change design of Query Print Layout designer,

Make required changes in user query & save it Query manager.

Create a new QPLD from Base Template.

Hope above answer will solve your problem.

Jeyakanthan

[Former Member]

Hi om singh,

You can also find more information with recorded video at the following place:

SAP Channel Partner Portal->Education->Role-Based Training->Implementation Consultants->Customization-> Print Layout Designer Part I,II,III

http://service.sap.com/smb/sbo/documentation->choose the B1 version youu2019re using->Print Layout Designer

Hope it helps.

Regards,

Jacqueline Jiang

SAP Business One Forums Team

[Former Member]

my situation is this - i hav a query which returns many fields.

and i follow the track tools -> queries -> query manager .In query manager after selecting my query i select the create report option.Then after i again go to tools -> queries -> query prient layout and there after selecting my query i select the prient preview option.it return a report and i just want to customize this report means i want to change the place of some field value.

[Former Member]

Hi,

If you want to redesign the Query PLD, Goto Tools --> Queries --> Query Print Layout.

In this you can view the list of Query PLD's. Select the query you want to change the position of fields and double click the query PLD name. It opens the PLD. You make necessary changes in it and Save the layout.

I hope this could help you to solve the problem

Raja.S

[helen_sun]

from the query layout designer you could edit and save the settings as

what you can do in the system standard template.

Best Regards

Helen Sun

[Former Member]

Hello Sir,

After tools -> queries -> query prient layout ,Double Click Query .Change the position of fields,or add new fields if you want to add.make the changes required.

Then go to PrintlayoutDesigner-->Click save.

close all the windows.

then again go to tools -> queries -> query prient layout .

select that query and go to File-->print Preview.

Regards,

Neetu

[helen_sun]

Hi

You could access the report designer:

tools->query->user reports

double click on the user report

Best Regards

Helen Sun

SAP Business One Forums Team