Skip to Content
author's profile photo Former Member
Former Member

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

i want to change the design of a report.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Jun 06, 2008 at 05:25 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2008 at 05:35 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2008 at 07:19 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 09, 2008 at 11:01 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 14, 2008 at 08:41 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 04:11 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.