VB Forms and Custom Report Link

Yahoo Archive
1
Sorry, It's been a long weekend.
My correct web site link is:

http://members.aol.com/mpodlin/index.htm

One little type-o and nothing ever works. When are they going to fix the
spell check for url's???

-----Original Message-----
From: Podlin, Michael
Sent: Monday, September 04, 2000 10:28 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] VB Forms and Custom Report Link


For anyone interested, I have a new shareware program available at
http://memebers.aol.com/mpodlin/index.htm

VBRpt.r is a program that is more like a Vantage Basic Add-on. It will
allow you to run a specific Report Builder report from a Vantage Basic form
and pass variables directly to the filter. No need to edit the filter to
each time you run the report. An example of this would be if you create a
Report Builder report for a type of packing slip and place the button and
command on a VB form in the ShipHead section, you could have the command
pass the filter of ShipHead.PackNum = {PackNum.SCRVALUE} which would pass
the filter of the current packing number to the report.

-----Original Message-----
From: Alan Williams [mailto:awilliams@...]
Sent: Wednesday, August 23, 2000 4:18 PM
To: vantage@egroups.com
Subject: [Vantage] VB Forms and Custom Report Link


Hi, everybody
Has anyone created a VB Form that will call a report from the
custom report link? Is it possible? I'm just now digging into Vantage
Basic, and the Training database isn't very helpful in this area.

Thanx,
Alan Williams
Vantage Implementation Team
2
Yes it can be done. You need to create a small Progress Program that runs a
specific Report Builder report, compile it, save it. In Vantage Basic,
create a button that executes "RUNPROG yourprogram.r".

I even have it passing variables to the clipboard and then using those
variables as filters for the report.

Mike :)

-----Original Message-----
From: Alan Williams [mailto:awilliams@...]
Sent: Wednesday, August 23, 2000 4:18 PM
To: vantage@egroups.com
Subject: [Vantage] VB Forms and Custom Report Link


Hi, everybody
Has anyone created a VB Form that will call a report from the
custom report link? Is it possible? I'm just now digging into Vantage
Basic, and the Training database isn't very helpful in this area.

Thanx,
Alan Williams
Vantage Implementation Team
3
For anyone interested, I have a new shareware program available at
http://memebers.aol.com/mpodlin/index.htm

VBRpt.r is a program that is more like a Vantage Basic Add-on. It will
allow you to run a specific Report Builder report from a Vantage Basic form
and pass variables directly to the filter. No need to edit the filter to
each time you run the report. An example of this would be if you create a
Report Builder report for a type of packing slip and place the button and
command on a VB form in the ShipHead section, you could have the command
pass the filter of ShipHead.PackNum = {PackNum.SCRVALUE} which would pass
the filter of the current packing number to the report.

-----Original Message-----
From: Alan Williams [mailto:awilliams@...]
Sent: Wednesday, August 23, 2000 4:18 PM
To: vantage@egroups.com
Subject: [Vantage] VB Forms and Custom Report Link


Hi, everybody
Has anyone created a VB Form that will call a report from the
custom report link? Is it possible? I'm just now digging into Vantage
Basic, and the Training database isn't very helpful in this area.

Thanx,
Alan Williams
Vantage Implementation Team