Placing Link button in Report

[Former Member]

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..

[Former Member]

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

[Former Member]

Thanks jane, i vl check it out and tell........

[Former Member]

hi,

To my knowledge,

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

regards,

varma

[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..

[Former Member]

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

[Former Member]

Hi Jane,

Thanks for ur response....The column in which i want the link button is, the column created through query..For that i think the link button will not be created automatically...

Wat to do in this case......

[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