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

Placing Link button in Report

Hi All.

I am generating a report using query generator..In that i want to place a link button in a particular column...Whether its possible..

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

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

    Dear Sridhar R Badri,

    If the column is a key field like ItemCode in OITM then it will display the Link button authomatically

    for the key field.

    Best Regards

    Jane Jing

    SAP Business One Forums team

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      Jing is correct.

      Along with this you have to consider following things:

      The Column should come from Base Table only. If the column is the union of one or two tables then link will not appear.

      ex: Select 'OITM' IT, ItemCode,ItemName from OITM

      Link will appear here

      ex:

      Select 'OITM' IT, ItemCode,ItemName from OITM

      UNION ALL

      Select 'RDR1' IT, ItemCode ,Dscription ItemName from RDR1

      Link will not appear.

      Regards

      Sanjay

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 09:08 AM

    hi,

    To my knowledge,

    For user defined tables we can not make out the link buttons concept in Query manager.

    regards,

    varma

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi All,

      Wat my need is,

      For ex: I am having a Total column(user defined column through sql query) in my report.....If i click the Link Button which is in the Total Column, another small screen should be opened......Whether this is possible to acheive..

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 09:49 AM

    Dear Sridhar R Badri,

    In B1 the Link button just can link to a object, system object or User Defined Object.

    The possible way is to define a UDO (with UDT and UDF) for your open window and link to the UDO.

    The column with Link button should be the key of UDO also.

    I can not sure you can do this in B1 query generator and maybe you need to developer another UDF contained these query columns.

    Best Regards

    Jane Jing

    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.