Modifying Reports which use Temporary Tables

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I often get told that it is impossible to customize a report which uses a temporary table, and in particular a temporary table which uses single fields for multiple purposes. While I admit that these reports are more challenging to customize they are far from impossible.

Usually, the temporary tables use some sort of sequence number field to help define what each of the generic fields are being used for.  Start by adding all the fields from the temporary table to the report so you can see how they used.

Creating relationships from a temporary table to another table is sometimes possible, if the required key fields are available as non-generic fields.  If this is not the case you can use VBA to access the SQL data via ActiveX Data Objects (ADO) and a Transact-SQL query based on the data available to you from report fields and/or fields from tables already linked to the report.

Please see the posting VBA – Accessing any SQL data from a Report Example for an example.

In summary, VBA can be used to make the impossible…. well…. possible.

This article was originally posted on the Developing for Dynamics GP Blog and has been reposted on http://www.winthropdc.com/blog.

6 thoughts on “Modifying Reports which use Temporary Tables

Please post feedback or comments

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.