Custom Reports on Sage

[Zak2009]

Hi ,

I have created a report that extracts data from a custom table (Table added but it extracts data from Sage table) I added into the Sage company database.

I try to print the report from within Sage application but the report keeps asking for authentication credentials even though I specified this while creating an ODBC using SQL authentication for the report.

On using windows authentication on the ODBC, the report comes out blank.

Any Insights anyone.

Sage 6.1, MSSQL 2005.

Thanks

 

[Jay Converse]

Put the custom tables in a subreport.

 

[ettienne]

See this post, not the best solution but if all else fails...

http://sagecity.na.sage.com/support_communities/sage300_erp/f/145/t/74816.aspx