RW - Accessing any SQL data from a Report Example

Modifying Reports which use Temporary Tables

Developing for Dynamics GP — Fri, 25 Jul 2008 09:31:20 GMT

I often get told that it is impossible to customize a report which uses a temporary table, and in particular

re: RW - Accessing any SQL data from a Report Example

David Musgrave — Mon, 04 Aug 2008 20:01:28 GMT

Posting from DynamicAccounting.net

http://msdynamicsgp.blogspot.com/2008/07/make-sure-you-are-reading-david.html

re: RW - Accessing any SQL data from a Report Example

David Musgrave — Mon, 04 Aug 2008 20:09:11 GMT

Posting from Dynamics GP Blogster

http://dynamicsgpblogster.blogspot.com/2008/07/modifying-reports-that-use-temp-table.html

Using the built-in Report Writer Functions

Developing for Dynamics GP — Mon, 01 Sep 2008 13:08:01 GMT

During my time in the partner channel, I worked with a number of consultants who had a number of problems

Using VBA with Report Writer

Developing for Dynamics GP — Thu, 30 Oct 2008 09:14:34 GMT

Most people are aware that you can use Visual Basic for Applications (VBA) with Microsoft Dynamics GP

Using ADO with VBA with Report Writer

Developing for Dynamics GP — Thu, 30 Oct 2008 09:17:53 GMT

As a follow on to the Using VBA with Report Writer post, I would like to discuss using ActiveX Data Objects

re: RW - Accessing any SQL data from a Report Example

GPNUT — Tue, 09 Dec 2008 20:29:37 GMT

This works like a charm have been able to implement for several clients... Only thing is there a RetrievealGP10.dll or do you

re: RW - Accessing any SQL data from a Report Example

Scott Stephenson [MSFT] — Tue, 09 Dec 2008 20:37:58 GMT

Thanks for the note GPNUT. For release 10.0, there is no RetrieveGlobals.dll and you would instead use the built-in UserInfoGet object that is available. For GP 10.00 you will need at least Service Pack 1 to use this sample.

RW - Making a One-to-Many Table Relationship behave as One-to-One

Developing for Dynamics GP — Mon, 18 May 2009 03:54:28 GMT

One of biggest issues people have with the Microsoft Dynamics GP Report Writer is not being able to create

re: RW - Accessing any SQL data from a Report Example

Alfred Erian — Tue, 27 Oct 2009 22:00:54 GMT

I used the example in GP 10 SP 4 everything goes fine but the calc. field wouldn't change value

i try to put a code just to change the value in different events without any luck

Can you please help?

re: RW - Accessing any SQL data from a Report Example

David Musgrave — Wed, 28 Oct 2009 05:56:41 GMT

Hi Alfred

Have you put break points in the code to confirm that it is running and to allow you to trace through the scripts.

Do you have VBA working elsewhere in the application on this workstation?

The KB below can help with fixing VBA permissions if VBA is not working on this workstation:

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;929612

David

re: RW - Accessing any SQL data from a Report Example

Alfred Erian — Wed, 28 Oct 2009 06:40:05 GMT

Hi David

Thanks for your answer, yes i tried break points it all goes fine and even show that the calc. field value is correct, but when the report come out the value was still empty string.

It only did work when i changed the code location from Report_BeforeBody event to Report_BeforeRH event

i did try to but the code back in Report_BeforeBody and move my calc. field to different report sections but with the same result, nothing.

Alfred

re: RW - Accessing any SQL data from a Report Example

David Musgrave — Wed, 28 Oct 2009 07:25:15 GMT

Hi Alfred

Make sure that the Field Type for the place holder calculated field you have created is of type DATA.

Have you looked at the related articles:

http://blogs.msdn.com/developingfordynamicsgp/archive/2008/10/30/using-vba-with-report-writer.aspx

http://blogs.msdn.com/developingfordynamicsgp/archive/2008/10/30/using-ado-with-vba-with-report-writer.aspx

David