I need add a table in the Report Writer

(0) Share

Report

Posted on by mgarcia

365

Good evening,

I need create a relationship but one of the tables does not exist, by example i need a relationship between invoices table and the service call table but the service call table does not exist and I need add this table before.

Any suggestion is welcome.

Mr. Garcia

*This post is locked for comments

All responses (4)

Answers (0)

mgarcia 365 on at

Like (0)

Report

RE: I need add a table in the Report Writer

Good morning,

Thanks a lot for your help.

Mr. García
Suggested answer

David Musgrave MVP ... 13,926 Most Valuable Professional on at

Like (0)

Report

RE: I need add a table in the Report Writer

Use GP Power Tools to create a custom RW function to pull the data in via Dexterity or SQL code.

winthropdc.wordpress.com/.../gppt-adding-data-from-any-sql-table-to-sop-documents

winthropdc.wordpress.com/.../gppt-adding-vendor-item-number-to-sop-documents

winthropdc.wordpress.com/.../rw-using-the-rw_tablelinestring-and-rw_tablelinecurrency-report-writer-functions

GP Power Tools Portal: http://WinthropDC.com/GPPT

Install it and activate the free 30 day trial to solve your issue.

David
mgarcia 365 on at

Like (0)

Report

RE: I need add a table in the Report Writer

Good morning,

Thanks for your suggestion and time.

Mr. García
Suggested answer

Mariano Gomez 26,225 on at

Like (0)

Report

RE: I need add a table in the Report Writer

The Service Call tables are in the Field Services dictionary. You could use VBA with Report Writer to retrieve the information you are seeking to print on the report, but VBA is not compatible with Web Client, if you are expecting to use this on web client.