Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Modified Report showing the data from a SQL VIEW

4 views
Skip to first unread message

wkz0

unread,
Jul 6, 2010, 1:38:29 AM7/6/10
to
We have created a SQL VIEW in a company database, and we wish the
REPORT WRITER able to get the data from this SQL VIEW and then show it
in the modified report (eg, RM Statement On Blank Paper), whether by
using Dexterity Programming, Smart builder or whichever method.

Hope you can provide some guidance on this matter. Many thanks in
advance.

P/S: GP 10 SP4, SQL 2008 Standard

Leslie Vail

unread,
Jul 13, 2010, 8:02:37 PM7/13/10
to
Hi wkz0

I think Mariano Gomez responded to a question like this (if not this
question) in the other Forum. David Musgrave has an article on this here:

http://blogs.msdn.com/b/developingfordynamicsgp/archive/2008/07/17/vba-accessing-any-sql-data-from-a-report-example.aspx

Kind regards,

Leslie

"wkz0" wrote:

> .
>

0 new messages