Print Report from Button

[system]

Hi DD,

Do you know how to do the below?

Cheers,

CHRIS THOMPSON



________________________________
From: Chris Thompson <chriselectrix@...>
To: vantage@yahoogroups.com
Sent: Wednesday, 8 July, 2009 9:55:16
Subject: Re: [Vantage] Print Report from Button





Hi,

I think that I am almost there.

I have Generated Sample Data from the DashBoard and brought that data into a new .rpt file.

I have set the CustCnt.Name as the parameter field and used it in 'Select Expert ...'.

The only things I can't do now are:

1)Â set the new report to be the default report for the dashboard

2) get the embedded dashboard on my Cutomer Maintenence page to update instantly when I add a contact (without having to view a different customer then re-visit the customer where I have added the contact). The retrieve button doesn't seem to do anything.

3) i do have a print driver for my printer - can this be embedded so it always prints to the correct printer?

Any help would be appreciated.

____________ _________ _________ __
From: DD <ddavis4569@yahoo. com>
To: vantage@yahoogroups .com
Sent: Tuesday, 7 July, 2009 21:53:30
Subject: Re: [Vantage] Print Report from Button

OK you are almost there.
The dashboard has the information of the contacts for the customer contacts.
Now create a Crystal report from the dashboard.
From the Dashboard editor select Tools / Report Tools / Design Crystal reports.
Note Where is put the data file and the name of the data file.
This report will have to be written from a blank report then link in the data file.
Create a Parameter field that can be a list of the Contacts from the dashboard.
They will select the contact that they want to print the label for.
Use this parameter in the select expert in Crystal.
Format the page size to match the label size in Crystal.
Â
Let me know if you need help setting up the Report options or in setting up the Crystal Report.
Do you have a printer driver for your label printer?

--- On Tue, 7/7/09, Chris Thompson <chriselectrix@ ymail.com> wrote:

From: Chris Thompson <chriselectrix@ ymail.com>
Subject: Re: [Vantage] Print Report from Button
To: vantage@yahoogroups .com
Date: Tuesday, July 7, 2009, 4:47 AM

Hi,

I think Ive got it almost working.

I have created a BAQ with Contact Name, Customer Name, Addr 1 etc.

From that I have created a Dashboard.

On the top level (query) on the Dashboard, I have set a filter Customer.CustID = Dashboard Browse.

I have added a new sheet in the Customer Maintenance > Contact tab and added the Dashboard.

I have subscribed to UI data (includes retrieve button) and linked it on CustID.

When I view a customer's page for the first time, I can go to the tab and view a list of all contacts in the Dashboard.

However, there are a couple of things I can't quite work out ...

1) How can I shrink the results of the DB down further so it only shows the contact's information for the contact that I am viewing? This way I would get a label for EVERY contact when I click print (which I dont want). Im guessing I need at add another filter to the DB, but it can't be another Dashboard browse. What can it be?

2) If I add another contact, the dashboard doesn't automatically refresh. It doesnt refresh even if I click on the Retrieve button. The only way to view the new contact's details in the dashboard is to go to a different customer's details, then go back to the previous user's details. I dont know if this is just how it works, or if it isa bug with E9?

3) When I am ready to print, how can I change the format (in Crystal) to fit the results on to a label? I would have thought it would generate a .rpt for the DB, but it doesn't look like it does.

Any help with this would be greatly appreciated.

Regards,

CHRIS THOMPSON

____________ _________ _________ __
From: DD <ddavis4569@ yahoo. com>
To: vantage@yahoogroups .com
Sent: Monday, 6 July, 2009 20:48:51
Subject: Re: [Vantage] Print Report from Button

I have created a button on a form to write the data to an excel file.
Then the crystal report could use the excel file for the data file.
Â
Another Idea is to create a dashboard and add it to a new page on the form.
The form could publish the data and the dashboard can subscribe to the data published from the form. Then there would be a crystal report from the dashboard. Dashboard reports are a little different from BAQ designer reports. It does allow you to pass the data to the Dashboard.
Â

--- On Mon, 7/6/09, Chris Thompson <chriselectrix@ ymail.com> wrote:

From: Chris Thompson <chriselectrix@ ymail.com>
Subject: Re: [Vantage] Print Report from Button
To: vantage@yahoogroups .com
Date: Monday, July 6, 2009, 10:56 AM

Hi Ross,

I would be interested to give it a go if you dont mind.

Not sure about all this UD table stuff but I will give it a go in our test environment.

Cheers,

CHRIS

____________ _________ _________ __
From: Ross Hughes <ross.hughes@ comcast.net>
To: "vantage@yahoogroup s .com" <vantage@yahoogroup s .com>
Sent: Monday, 6 July, 2009 16:49:24
Subject: Re: [Vantage] Print Report from Button

If the baq report is always drawn from the same module you could write
the variables to a UD table and then have the baq report onload event
pick them up on start up. I have had success with this but am unable
to autopreview the report. I have to press preview again in the
report dialog box. Not a real inconvenience.

I can post the code if you are interested.

Ross

On Jul 6, 2009, at 7:34 AM, "Vic Drecchio" <vic.drecchio@ timco.aero>
wrote:

> Chris,
>
> This has been a topic of discussion in the past. It sure would be a
> great feature to be able to pass context parameters to any BAQ
> report but I don't know of any.
>
> If you are on the Customer Maintenance screen and have Customer
> ABC123 in context and press a button to launch a BAQ report, there
> is no way I know of to pass "ABC123" to the BAQ Crystal Report. We
> all know Crystal Reports has the capability but the Vantage UI lacks
> the capability to extract and send that value to the report.
>
> If there is a solution, I'm all ears. :-)
>
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email: vic.drecchio@ timco.aero
> Mobile: 704.530.3092
>
> -----Original Message-----
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
> Behalf Of Chris Thompson
> Sent: Friday, July 03, 2009 10:33 AM
> To: vantage@yahoogroups .com
> Subject: Re: [Vantage] Print Report from Button
>
> Hi All,
>
> Does is there a way where I can use the below to launch a report to
> print a label with the data that is on the screen?
>
> I want to add a button to the Contact tab in Customer Maintenance so
> if we need to send that contact a letter after adding them, we can
> press the button and it will print a label (or default letter) with
> their name and company address on the label.
>
> Im surprised Epicor/Vantage dont have this as standard (well not
> that suprised considering! :-) ).
>
> Cheers,
>
>
>
> CHRIS THOMPSON
>
>
>
>
> ____________ _________ _________ __
> From: Linda Lowney <llowney@pridesigns . com>
> To: vantage@yahoogroups .com
> Sent: Friday, 24 April, 2009 14:03:43
> Subject: [Vantage] Print Report from Button
>
>
>
>
>
> Thank you Rob and Stephen for pointing me in the right direction. I
> was
> able to add the report to the button, but now I would like to pass the
> job number parameter to the Crystal Report. Is that possible?
>
> Regards,
>
> Linda
>
> Rob is correct,
>
> It can be done
>
> The syntax is
> ProcessCaller. LaunchForm( oTrans,"YourMenu ID")
>
> Create a menu id in menu maintenance this is what you
> use.
>
> The menu would be either a crystal
> report or BAQ report.
>
> Regards,
>
> Stephen
>
> ------------ --------- --------
>
> Might be possible by sticking a LaunchProcessCaller () statement
> (...hope
> that's the right VB keyword... Replying on a Palm w/out access to
> Vantage to verify syntax) within a Sub triggered by clicking on your
> custom button control.
>
> Never tried it personally so don't know if Crystal complicates it.
> Pretty sure our primary programmer did something like this in one the
> Receiving apps though (although it may not have been a BAQ report).
>
> Hope that heads you in some useful direction. Be glad to dig deeper
> tomorrow if you need.
> Rob
>
> ------------ --------- ---------
>
> Hi Group,
>
> I would like to print a BAQ report from a button. Would someone please
> tell me if this is possible and what I need to do to make it happen.
>
> Regards,
> Linda
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> .
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> Groups Links
>
>
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> .
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> Groups Links
>
>
>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]

[system]

Thank you Rob and Stephen for pointing me in the right direction. I was
able to add the report to the button, but now I would like to pass the
job number parameter to the Crystal Report. Is that possible?



Regards,

Linda







Rob is correct,

It can be done

The syntax is
ProcessCaller.LaunchForm(oTrans,"YourMenuID")



Create a menu id in menu maintenance this is what you
use.

The menu would be either a crystal
report or BAQ report.



Regards,

Stephen



-----------------------------



Might be possible by sticking a LaunchProcessCaller() statement (...hope
that's the right VB keyword... Replying on a Palm w/out access to
Vantage to verify syntax) within a Sub triggered by clicking on your
custom button control.

Never tried it personally so don't know if Crystal complicates it.
Pretty sure our primary programmer did something like this in one the
Receiving apps though (although it may not have been a BAQ report).

Hope that heads you in some useful direction. Be glad to dig deeper
tomorrow if you need.
Rob






------------------------------



Hi Group,

I would like to print a BAQ report from a button. Would someone please
tell me if this is possible and what I need to do to make it happen.

Regards,
Linda





[Non-text portions of this message have been removed]

[system]

Hi All,

Does is there a way where I can use the below to launch a report to print a label with the data that is on the screen?

I want to add a button to the Contact tab in Customer Maintenance so if we need to send that contact a letter after adding them, we can press the button and it will print a label (or default letter) with their name and company address on the label.

Im surprised Epicor/Vantage dont have this as standard (well not that suprised considering! :-) ).

Cheers,



CHRIS THOMPSON




________________________________
From: Linda Lowney <llowney@...>
To: vantage@yahoogroups.com
Sent: Friday, 24 April, 2009 14:03:43
Subject: [Vantage] Print Report from Button





Thank you Rob and Stephen for pointing me in the right direction. I was
able to add the report to the button, but now I would like to pass the
job number parameter to the Crystal Report. Is that possible?

Regards,

Linda

Rob is correct,

It can be done

The syntax is
ProcessCaller. LaunchForm( oTrans,"YourMenu ID")

Create a menu id in menu maintenance this is what you
use.

The menu would be either a crystal
report or BAQ report.

Regards,

Stephen

------------ --------- --------

Might be possible by sticking a LaunchProcessCaller () statement (...hope
that's the right VB keyword... Replying on a Palm w/out access to
Vantage to verify syntax) within a Sub triggered by clicking on your
custom button control.

Never tried it personally so don't know if Crystal complicates it.
Pretty sure our primary programmer did something like this in one the
Receiving apps though (although it may not have been a BAQ report).

Hope that heads you in some useful direction. Be glad to dig deeper
tomorrow if you need.
Rob

------------ --------- ---------

Hi Group,

I would like to print a BAQ report from a button. Would someone please
tell me if this is possible and what I need to do to make it happen.

Regards,
Linda

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]

[system]

Sorry I can't help with details but I am pretty sure there is a way. Selectrix is in Australia right? The problem is many of the USA based people likely to be able to help are off work today on national holiday - Independence Day - which falls tomorrow so most businesses are closed today. The few actually working, like me, are probably doing system upgrades while everyone else is out drinking beer and bar-b-queing. If you don't get a response today be patient most will be back by Monday, maybe even sober. ;)
-Todd C.


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Friday, July 03, 2009 9:33 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Print Report from Button




Hi All,

Does is there a way where I can use the below to launch a report to print a label with the data that is on the screen?

I want to add a button to the Contact tab in Customer Maintenance so if we need to send that contact a letter after adding them, we can press the button and it will print a label (or default letter) with their name and company address on the label.

Im surprised Epicor/Vantage dont have this as standard (well not that suprised considering! :-) ).

Cheers,

CHRIS THOMPSON

________________________________
From: Linda Lowney <llowney@...<mailto:llowney%40pridesigns.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Friday, 24 April, 2009 14:03:43
Subject: [Vantage] Print Report from Button

Thank you Rob and Stephen for pointing me in the right direction. I was
able to add the report to the button, but now I would like to pass the
job number parameter to the Crystal Report. Is that possible?

Regards,

Linda

Rob is correct,

It can be done

The syntax is
ProcessCaller. LaunchForm( oTrans,"YourMenu ID")

Create a menu id in menu maintenance this is what you
use.

The menu would be either a crystal
report or BAQ report.

Regards,

Stephen

------------ --------- --------

Might be possible by sticking a LaunchProcessCaller () statement (...hope
that's the right VB keyword... Replying on a Palm w/out access to
Vantage to verify syntax) within a Sub triggered by clicking on your
custom button control.

Never tried it personally so don't know if Crystal complicates it.
Pretty sure our primary programmer did something like this in one the
Receiving apps though (although it may not have been a BAQ report).

Hope that heads you in some useful direction. Be glad to dig deeper
tomorrow if you need.
Rob

------------ --------- ---------

Hi Group,

I would like to print a BAQ report from a button. Would someone please
tell me if this is possible and what I need to do to make it happen.

Regards,
Linda

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]

[system]

Hi Todd,

I see the confusion - my email is Chris Electrix - Electrix being the company.

We are in the UK - but a public holiday right about now does sound pretty good!! :-)

Hopefully somebody will be able to help today.

Cheers,


CHRIS




________________________________
From: Todd Caughey <caugheyt@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Friday, 3 July, 2009 16:44:55
Subject: RE: [Vantage] Print Report from Button





Sorry I can't help with details but I am pretty sure there is a way. Selectrix is in Australia right? The problem is many of the USA based people likely to be able to help are off work today on national holiday - Independence Day - which falls tomorrow so most businesses are closed today. The few actually working, like me, are probably doing system upgrades while everyone else is out drinking beer and bar-b-queing. If you don't get a response today be patient most will be back by Monday, maybe even sober. ;)
-Todd C.

____________ _________ _________ __
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Chris Thompson
Sent: Friday, July 03, 2009 9:33 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Print Report from Button

Hi All,

Does is there a way where I can use the below to launch a report to print a label with the data that is on the screen?

I want to add a button to the Contact tab in Customer Maintenance so if we need to send that contact a letter after adding them, we can press the button and it will print a label (or default letter) with their name and company address on the label.

Im surprised Epicor/Vantage dont have this as standard (well not that suprised considering! :-) ).

Cheers,

CHRIS THOMPSON

____________ _________ _________ __
From: Linda Lowney <llowney@pridesigns. com<mailto:llowney% 40pridesigns. com>>
To: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>
Sent: Friday, 24 April, 2009 14:03:43
Subject: [Vantage] Print Report from Button

Thank you Rob and Stephen for pointing me in the right direction. I was
able to add the report to the button, but now I would like to pass the
job number parameter to the Crystal Report. Is that possible?

Regards,

Linda

Rob is correct,

It can be done

The syntax is
ProcessCaller. LaunchForm( oTrans,"YourMenu ID")

Create a menu id in menu maintenance this is what you
use.

The menu would be either a crystal
report or BAQ report.

Regards,

Stephen

------------ --------- --------

Might be possible by sticking a LaunchProcessCaller () statement (...hope
that's the right VB keyword... Replying on a Palm w/out access to
Vantage to verify syntax) within a Sub triggered by clicking on your
custom button control.

Never tried it personally so don't know if Crystal complicates it.
Pretty sure our primary programmer did something like this in one the
Receiving apps though (although it may not have been a BAQ report).

Hope that heads you in some useful direction. Be glad to dig deeper
tomorrow if you need.
Rob

------------ --------- ---------

Hi Group,

I would like to print a BAQ report from a button. Would someone please
tell me if this is possible and what I need to do to make it happen.

Regards,
Linda

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]

[system]

Chris,

This has been a topic of discussion in the past. It sure would be a great feature to be able to pass context parameters to any BAQ report but I don't know of any.

If you are on the Customer Maintenance screen and have Customer ABC123 in context and press a button to launch a BAQ report, there is no way I know of to pass "ABC123" to the BAQ Crystal Report. We all know Crystal Reports has the capability but the Vantage UI lacks the capability to extract and send that value to the report.

If there is a solution, I'm all ears. :-)



Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email:Â Â vic.drecchio@...
Mobile:Â 704.530.3092

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Friday, July 03, 2009 10:33 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Print Report from Button

Hi All,

Does is there a way where I can use the below to launch a report to print a label with the data that is on the screen?

I want to add a button to the Contact tab in Customer Maintenance so if we need to send that contact a letter after adding them, we can press the button and it will print a label (or default letter) with their name and company address on the label.

Im surprised Epicor/Vantage dont have this as standard (well not that suprised considering! :-) ).

Cheers,



CHRIS THOMPSON




________________________________
From: Linda Lowney <llowney@...>
To: vantage@yahoogroups.com
Sent: Friday, 24 April, 2009 14:03:43
Subject: [Vantage] Print Report from Button





Thank you Rob and Stephen for pointing me in the right direction. I was
able to add the report to the button, but now I would like to pass the
job number parameter to the Crystal Report. Is that possible?

Regards,

Linda

Rob is correct,

It can be done

The syntax is
ProcessCaller. LaunchForm( oTrans,"YourMenu ID")

Create a menu id in menu maintenance this is what you
use.

The menu would be either a crystal
report or BAQ report.

Regards,

Stephen

------------ --------- --------

Might be possible by sticking a LaunchProcessCaller () statement (...hope
that's the right VB keyword... Replying on a Palm w/out access to
Vantage to verify syntax) within a Sub triggered by clicking on your
custom button control.

Never tried it personally so don't know if Crystal complicates it.
Pretty sure our primary programmer did something like this in one the
Receiving apps though (although it may not have been a BAQ report).

Hope that heads you in some useful direction. Be glad to dig deeper
tomorrow if you need.
Rob

------------ --------- ---------

Hi Group,

I would like to print a BAQ report from a button. Would someone please
tell me if this is possible and what I need to do to make it happen.

Regards,
Linda

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[system]

Hi Vic,

Epicor has suggested a solution, but I have no idea how to implement it. They said ...
If you have the Bartender label printing module, a better approach is to use this. In this scenario, we could do as you suggest which is:
Â
Add a button to the screen / Action menu entry,
Have this button/menu set a UD field which would trigger the BPM,
Have the BPM reset the UD field and output a Bartender format file to the folder monitored by Bartender printing,
Bartender would then pick up the report file and print it.
Â
I dont know if that means more to you than it does to me.

Cheers,


CHRIS




________________________________
From: Vic Drecchio <vic.drecchio@...>
To: vantage@yahoogroups.com
Sent: Monday, 6 July, 2009 13:34:57
Subject: RE: [Vantage] Print Report from Button





Chris,

This has been a topic of discussion in the past. It sure would be a great feature to be able to pass context parameters to any BAQ report but I don't know of any.

If you are on the Customer Maintenance screen and have Customer ABC123 in context and press a button to launch a BAQ report, there is no way I know of to pass "ABC123" to the BAQ Crystal Report. We all know Crystal Reports has the capability but the Vantage UI lacks the capability to extract and send that value to the report.

If there is a solution, I'm all ears. :-)

Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email:Â Â vic.drecchio@ timco.aero
Mobile:Â 704.530.3092

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Chris Thompson
Sent: Friday, July 03, 2009 10:33 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Print Report from Button

Hi All,

Does is there a way where I can use the below to launch a report to print a label with the data that is on the screen?

I want to add a button to the Contact tab in Customer Maintenance so if we need to send that contact a letter after adding them, we can press the button and it will print a label (or default letter) with their name and company address on the label.

Im surprised Epicor/Vantage dont have this as standard (well not that suprised considering! :-) ).

Cheers,

CHRIS THOMPSON

____________ _________ _________ __
From: Linda Lowney <llowney@pridesigns. com>
To: vantage@yahoogroups .com
Sent: Friday, 24 April, 2009 14:03:43
Subject: [Vantage] Print Report from Button

Thank you Rob and Stephen for pointing me in the right direction. I was
able to add the report to the button, but now I would like to pass the
job number parameter to the Crystal Report. Is that possible?

Regards,

Linda

Rob is correct,

It can be done

The syntax is
ProcessCaller. LaunchForm( oTrans,"YourMenu ID")

Create a menu id in menu maintenance this is what you
use.

The menu would be either a crystal
report or BAQ report.

Regards,

Stephen

------------ --------- --------

Might be possible by sticking a LaunchProcessCaller () statement (...hope
that's the right VB keyword... Replying on a Palm w/out access to
Vantage to verify syntax) within a Sub triggered by clicking on your
custom button control.

Never tried it personally so don't know if Crystal complicates it.
Pretty sure our primary programmer did something like this in one the
Receiving apps though (although it may not have been a BAQ report).

Hope that heads you in some useful direction. Be glad to dig deeper
tomorrow if you need.
Rob

------------ --------- ---------

Hi Group,

I would like to print a BAQ report from a button. Would someone please
tell me if this is possible and what I need to do to make it happen.

Regards,
Linda

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------ --------- --------- ------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links







[Non-text portions of this message have been removed]

[system]

If the baq report is always drawn from the same module you could write
the variables to a UD table and then have the baq report onload event
pick them up on start up. I have had success with this but am unable
to autopreview the report. I have to press preview again in the
report dialog box. Not a real inconvenience.

I can post the code if you are interested.

Ross



On Jul 6, 2009, at 7:34 AM, "Vic Drecchio" <vic.drecchio@...>
wrote:

> Chris,
>
> This has been a topic of discussion in the past. It sure would be a
> great feature to be able to pass context parameters to any BAQ
> report but I don't know of any.
>
> If you are on the Customer Maintenance screen and have Customer
> ABC123 in context and press a button to launch a BAQ report, there
> is no way I know of to pass "ABC123" to the BAQ Crystal Report. We
> all know Crystal Reports has the capability but the Vantage UI lacks
> the capability to extract and send that value to the report.
>
> If there is a solution, I'm all ears. :-)
>
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email: vic.drecchio@...
> Mobile: 704.530.3092
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Chris Thompson
> Sent: Friday, July 03, 2009 10:33 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Print Report from Button
>
> Hi All,
>
> Does is there a way where I can use the below to launch a report to
> print a label with the data that is on the screen?
>
> I want to add a button to the Contact tab in Customer Maintenance so
> if we need to send that contact a letter after adding them, we can
> press the button and it will print a label (or default letter) with
> their name and company address on the label.
>
> Im surprised Epicor/Vantage dont have this as standard (well not
> that suprised considering! :-) ).
>
> Cheers,
>
>
>
> CHRIS THOMPSON
>
>
>
>
> ________________________________
> From: Linda Lowney <llowney@...>
> To: vantage@yahoogroups.com
> Sent: Friday, 24 April, 2009 14:03:43
> Subject: [Vantage] Print Report from Button
>
>
>
>
>
> Thank you Rob and Stephen for pointing me in the right direction. I
> was
> able to add the report to the button, but now I would like to pass the
> job number parameter to the Crystal Report. Is that possible?
>
> Regards,
>
> Linda
>
> Rob is correct,
>
> It can be done
>
> The syntax is
> ProcessCaller. LaunchForm( oTrans,"YourMenu ID")
>
> Create a menu id in menu maintenance this is what you
> use.
>
> The menu would be either a crystal
> report or BAQ report.
>
> Regards,
>
> Stephen
>
> ------------ --------- --------
>
> Might be possible by sticking a LaunchProcessCaller () statement
> (...hope
> that's the right VB keyword... Replying on a Palm w/out access to
> Vantage to verify syntax) within a Sub triggered by clicking on your
> custom button control.
>
> Never tried it personally so don't know if Crystal complicates it.
> Pretty sure our primary programmer did something like this in one the
> Receiving apps though (although it may not have been a BAQ report).
>
> Hope that heads you in some useful direction. Be glad to dig deeper
> tomorrow if you need.
> Rob
>
> ------------ --------- ---------
>
> Hi Group,
>
> I would like to print a BAQ report from a button. Would someone please
> tell me if this is possible and what I need to do to make it happen.
>
> Regards,
> Linda
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/
> .
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo!
> Groups Links
>
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/
> .
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo!
> Groups Links
>
>
>

[system]

Hi Ross,

I would be interested to give it a go if you dont mind.

Not sure about all this UD table stuff but I will give it a go in our test environment.

Cheers,


CHRIS



________________________________
From: Ross Hughes <ross.hughes@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, 6 July, 2009 16:49:24
Subject: Re: [Vantage] Print Report from Button





If the baq report is always drawn from the same module you could write
the variables to a UD table and then have the baq report onload event
pick them up on start up. I have had success with this but am unable
to autopreview the report. I have to press preview again in the
report dialog box. Not a real inconvenience.

I can post the code if you are interested.

Ross

On Jul 6, 2009, at 7:34 AM, "Vic Drecchio" <vic.drecchio@ timco.aero>
wrote:

> Chris,
>
> This has been a topic of discussion in the past. It sure would be a
> great feature to be able to pass context parameters to any BAQ
> report but I don't know of any.
>
> If you are on the Customer Maintenance screen and have Customer
> ABC123 in context and press a button to launch a BAQ report, there
> is no way I know of to pass "ABC123" to the BAQ Crystal Report. We
> all know Crystal Reports has the capability but the Vantage UI lacks
> the capability to extract and send that value to the report.
>
> If there is a solution, I'm all ears. :-)
>
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email: vic.drecchio@ timco.aero
> Mobile: 704.530.3092
>
> -----Original Message-----
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
> Behalf Of Chris Thompson
> Sent: Friday, July 03, 2009 10:33 AM
> To: vantage@yahoogroups .com
> Subject: Re: [Vantage] Print Report from Button
>
> Hi All,
>
> Does is there a way where I can use the below to launch a report to
> print a label with the data that is on the screen?
>
> I want to add a button to the Contact tab in Customer Maintenance so
> if we need to send that contact a letter after adding them, we can
> press the button and it will print a label (or default letter) with
> their name and company address on the label.
>
> Im surprised Epicor/Vantage dont have this as standard (well not
> that suprised considering! :-) ).
>
> Cheers,
>
>
>
> CHRIS THOMPSON
>
>
>
>
> ____________ _________ _________ __
> From: Linda Lowney <llowney@pridesigns. com>
> To: vantage@yahoogroups .com
> Sent: Friday, 24 April, 2009 14:03:43
> Subject: [Vantage] Print Report from Button
>
>
>
>
>
> Thank you Rob and Stephen for pointing me in the right direction. I
> was
> able to add the report to the button, but now I would like to pass the
> job number parameter to the Crystal Report. Is that possible?
>
> Regards,
>
> Linda
>
> Rob is correct,
>
> It can be done
>
> The syntax is
> ProcessCaller. LaunchForm( oTrans,"YourMenu ID")
>
> Create a menu id in menu maintenance this is what you
> use.
>
> The menu would be either a crystal
> report or BAQ report.
>
> Regards,
>
> Stephen
>
> ------------ --------- --------
>
> Might be possible by sticking a LaunchProcessCaller () statement
> (...hope
> that's the right VB keyword... Replying on a Palm w/out access to
> Vantage to verify syntax) within a Sub triggered by clicking on your
> custom button control.
>
> Never tried it personally so don't know if Crystal complicates it.
> Pretty sure our primary programmer did something like this in one the
> Receiving apps though (although it may not have been a BAQ report).
>
> Hope that heads you in some useful direction. Be glad to dig deeper
> tomorrow if you need.
> Rob
>
> ------------ --------- ---------
>
> Hi Group,
>
> I would like to print a BAQ report from a button. Would someone please
> tell me if this is possible and what I need to do to make it happen.
>
> Regards,
> Linda
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> .
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> Groups Links
>
>
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> .
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> Groups Links
>
>
>

[Non-text portions of this message have been removed]

[system]

Here are some note on passing values to BAQ reports by writing and reading
records:

In my case I was using the UD100/100A table.

Because I wanted to use the same location to write to I created a
'placeholder' record. I called the Key field 'REPORT'.

The fields originally populated were:
Key1 = REPORT
Key2 = 1
Key3 = 1
Key4 = 1
Key5 = 1

If you were going to use the customer table you could create a phony
customer with a CustID named 'REPORT' or something similar. All you

need is a fixed record that you can write your dynamic data to. Or maybe use
the COMPANY table.

I am writing a part number and a report style number to the table. I have
created a drop-down box with various labels to print to.

Create a button to call the BAQ report. In the onclick event I have the
following code:
'----------------------------------------------
Private Sub btnPrintLabel_Click(ByVal Sender As Object, ByVal Args
As System.EventArgs) Handles btnPrintLabel.Click
'// ** Place Event Handling Code Here **

'Create a dataview for the current record
Dim edvUD100 As EpiDataView = CType(oTrans.EpiDataViews(“UD100”),
EpiDataView)

'Create access to retrieve the REPORT record
Dim adpUD100 As UD100Adapter = New UD100Adapter(UD100Form)
adpUD100.BOConnect()

Dim record As Boolean = adpUD100.GetByID("REPORT", "1", "1", "1",
"1")
Dim dsUD100 As UD100DataSet = adpUD100.UD100Data

'Write the needed variables to the REPORT record and dispose of the
object
If txtPartNum.Text <> "" Then
dsUD100.Tables("UD100").Rows(0)("ShortChar01") =
edvUD100.dataView(edvUD100.Row)(“Key1”)
dsUD100.Tables("UD100").Rows(0)("Number10") =
edvUD100.dataView(edvUD100.Row)(“Number02”)
adpUD100.Update
adpUD100.Dispose()

'Launch the BAQ form
dim opts as LaunchFormOptions = New LaunchFormOptions()
ProcessCaller.LaunchForm(oTrans, "UDPLSLBL") 'this is the menu
ID of your BAQ report
Else
Messagebox.Show("No Record Available.")
End If

End Sub
'----------------------------------------------

This will put whatever variables in the table of your choice and call the
report.

One thing to mention: since you have to call a BAQ report from menu id you
will need to connect it to a menu. I put it in the System

Management area since the parent folder is secured to most users. It is not
being called directly, but, you can do whatever you want with

this. Just know that the report is always going to call the last variable
posted to the table inless the code is modified to recognize where

it was called from. I don't know how to do this in Vantage. For this
approach, it works great.

Next create a customization in the BAQ report. Create an onload event
subroutine and paste the following code:
'----------------------------------------------

Private Sub BAQReportForm_Load(ByVal sender As object, ByVal args As
EventArgs) Handles BAQReportForm.Load
'//
'// Add Event Handler Code
'//

'Retreive the variables from the REPORT record in the UD100
table
Dim recSelected As Boolean
Dim whereClause As String = "Key1 = 'REPORT'"
Dim dsUD100 As DataSet =
Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
"UD100Adapter", recSelected, False,

whereClause)
If (recSelected) Then
Dim PartNumber As String =
dsUD100.Tables(0).Rows(0)(“ShortChar01”)
Dim ReportStyleNumber As String =
dsUD100.Tables(0).Rows(0)(“Number10”)
Dim edvPartNum As EpiDataView =
CType(oTrans.EpiDataViews("ReportParam"), EpiDataView)
edvPartNum.dataView(edvPartNum.Row)("Field1") =
PartNumber 'This is overriding the Option1 field
edvPartNum.dataView(edvPartNum.Row)("ReportStyleNum") =
ReportStyleNumber 'This is overriding the report style number
End If



End Sub
'----------------------------------------------

That is it. It should pick up the variables you need. You will need to
modify the code depending on what variables you are trying to pass

and override in the BAQ report.

Let me know if you have any questions of further clarification.

Ross

P.S. Does anyone know how to auto-preview a BAQ report? If I could auto
print preview this it would be great.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Thompson
Sent: Monday, July 06, 2009 10:56 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Print Report from Button

Hi Ross,

I would be interested to give it a go if you dont mind.

Not sure about all this UD table stuff but I will give it a go in our test
environment.

Cheers,


CHRIS



________________________________
From: Ross Hughes <ross.hughes@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, 6 July, 2009 16:49:24
Subject: Re: [Vantage] Print Report from Button





If the baq report is always drawn from the same module you could write
the variables to a UD table and then have the baq report onload event
pick them up on start up. I have had success with this but am unable
to autopreview the report. I have to press preview again in the
report dialog box. Not a real inconvenience.

I can post the code if you are interested.

Ross

On Jul 6, 2009, at 7:34 AM, "Vic Drecchio" <vic.drecchio@ timco.aero>
wrote:

> Chris,
>
> This has been a topic of discussion in the past. It sure would be a
> great feature to be able to pass context parameters to any BAQ
> report but I don't know of any.
>
> If you are on the Customer Maintenance screen and have Customer
> ABC123 in context and press a button to launch a BAQ report, there
> is no way I know of to pass "ABC123" to the BAQ Crystal Report. We
> all know Crystal Reports has the capability but the Vantage UI lacks
> the capability to extract and send that value to the report.
>
> If there is a solution, I'm all ears. :-)
>
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email: vic.drecchio@ timco.aero
> Mobile: 704.530.3092
>
> -----Original Message-----
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
> Behalf Of Chris Thompson
> Sent: Friday, July 03, 2009 10:33 AM
> To: vantage@yahoogroups .com
> Subject: Re: [Vantage] Print Report from Button
>
> Hi All,
>
> Does is there a way where I can use the below to launch a report to
> print a label with the data that is on the screen?
>
> I want to add a button to the Contact tab in Customer Maintenance so
> if we need to send that contact a letter after adding them, we can
> press the button and it will print a label (or default letter) with
> their name and company address on the label.
>
> Im surprised Epicor/Vantage dont have this as standard (well not
> that suprised considering! :-) ).
>
> Cheers,
>
>
>
> CHRIS THOMPSON
>
>
>
>
> ____________ _________ _________ __
> From: Linda Lowney <llowney@pridesigns. com>
> To: vantage@yahoogroups .com
> Sent: Friday, 24 April, 2009 14:03:43
> Subject: [Vantage] Print Report from Button
>
>
>
>
>
> Thank you Rob and Stephen for pointing me in the right direction. I
> was
> able to add the report to the button, but now I would like to pass the
> job number parameter to the Crystal Report. Is that possible?
>
> Regards,
>
> Linda
>
> Rob is correct,
>
> It can be done
>
> The syntax is
> ProcessCaller. LaunchForm( oTrans,"YourMenu ID")
>
> Create a menu id in menu maintenance this is what you
> use.
>
> The menu would be either a crystal
> report or BAQ report.
>
> Regards,
>
> Stephen
>
> ------------ --------- --------
>
> Might be possible by sticking a LaunchProcessCaller () statement
> (...hope
> that's the right VB keyword... Replying on a Palm w/out access to
> Vantage to verify syntax) within a Sub triggered by clicking on your
> custom button control.
>
> Never tried it personally so don't know if Crystal complicates it.
> Pretty sure our primary programmer did something like this in one the
> Receiving apps though (although it may not have been a BAQ report).
>
> Hope that heads you in some useful direction. Be glad to dig deeper
> tomorrow if you need.
> Rob
>
> ------------ --------- ---------
>
> Hi Group,
>
> I would like to print a BAQ report from a button. Would someone please
> tell me if this is possible and what I need to do to make it happen.
>
> Regards,
> Linda
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto:

http://groups. yahoo.com/ group/vantage/ files/

> .
> (2) To search through old msg's goto: http://groups. yahoo.com/

group/vantage/ messages

> (3) To view links to Vendors that provide Vantage services goto:

http://groups. yahoo.com/ group/vantage/ linksYahoo!

> Groups Links
>
>
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto:

http://groups. yahoo.com/ group/vantage/ files/

> .
> (2) To search through old msg's goto: http://groups. yahoo.com/

group/vantage/ messages

> (3) To view links to Vendors that provide Vantage services goto:

http://groups. yahoo.com/ group/vantage/ linksYahoo!

> Groups Links
>
>
>

[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[system]

I have created a button on a form to write the data to an excel file.
Then the crystal report could use the excel file for the data file.
Â
Another Idea is to create a dashboard and add it to a new page on the form.
The form could publish the data and the dashboard can subscribe to the data published from the form. Then there would be a crystal report from the dashboard. Dashboard reports are a little different from BAQ designer reports. It does allow you to pass the data to the Dashboard.
Â

--- On Mon, 7/6/09, Chris Thompson <chriselectrix@...> wrote:


From: Chris Thompson <chriselectrix@...>
Subject: Re: [Vantage] Print Report from Button
To: vantage@yahoogroups.com
Date: Monday, July 6, 2009, 10:56 AM








Hi Ross,

I would be interested to give it a go if you dont mind.

Not sure about all this UD table stuff but I will give it a go in our test environment.

Cheers,

CHRIS

____________ _________ _________ __
From: Ross Hughes <ross.hughes@ comcast.net>
To: "vantage@yahoogroups .com" <vantage@yahoogroups .com>
Sent: Monday, 6 July, 2009 16:49:24
Subject: Re: [Vantage] Print Report from Button

If the baq report is always drawn from the same module you could write
the variables to a UD table and then have the baq report onload event
pick them up on start up. I have had success with this but am unable
to autopreview the report. I have to press preview again in the
report dialog box. Not a real inconvenience.

I can post the code if you are interested.

Ross

On Jul 6, 2009, at 7:34 AM, "Vic Drecchio" <vic.drecchio@ timco.aero>
wrote:

> Chris,
>
> This has been a topic of discussion in the past. It sure would be a
> great feature to be able to pass context parameters to any BAQ
> report but I don't know of any.
>
> If you are on the Customer Maintenance screen and have Customer
> ABC123 in context and press a button to launch a BAQ report, there
> is no way I know of to pass "ABC123" to the BAQ Crystal Report. We
> all know Crystal Reports has the capability but the Vantage UI lacks
> the capability to extract and send that value to the report.
>
> If there is a solution, I'm all ears. :-)
>
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email: vic.drecchio@ timco.aero
> Mobile: 704.530.3092
>
> -----Original Message-----
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
> Behalf Of Chris Thompson
> Sent: Friday, July 03, 2009 10:33 AM
> To: vantage@yahoogroups .com
> Subject: Re: [Vantage] Print Report from Button
>
> Hi All,
>
> Does is there a way where I can use the below to launch a report to
> print a label with the data that is on the screen?
>
> I want to add a button to the Contact tab in Customer Maintenance so
> if we need to send that contact a letter after adding them, we can
> press the button and it will print a label (or default letter) with
> their name and company address on the label.
>
> Im surprised Epicor/Vantage dont have this as standard (well not
> that suprised considering! :-) ).
>
> Cheers,
>
>
>
> CHRIS THOMPSON
>
>
>
>
> ____________ _________ _________ __
> From: Linda Lowney <llowney@pridesigns . com>
> To: vantage@yahoogroups .com
> Sent: Friday, 24 April, 2009 14:03:43
> Subject: [Vantage] Print Report from Button
>
>
>
>
>
> Thank you Rob and Stephen for pointing me in the right direction. I
> was
> able to add the report to the button, but now I would like to pass the
> job number parameter to the Crystal Report. Is that possible?
>
> Regards,
>
> Linda
>
> Rob is correct,
>
> It can be done
>
> The syntax is
> ProcessCaller. LaunchForm( oTrans,"YourMenu ID")
>
> Create a menu id in menu maintenance this is what you
> use.
>
> The menu would be either a crystal
> report or BAQ report.
>
> Regards,
>
> Stephen
>
> ------------ --------- --------
>
> Might be possible by sticking a LaunchProcessCaller () statement
> (...hope
> that's the right VB keyword... Replying on a Palm w/out access to
> Vantage to verify syntax) within a Sub triggered by clicking on your
> custom button control.
>
> Never tried it personally so don't know if Crystal complicates it.
> Pretty sure our primary programmer did something like this in one the
> Receiving apps though (although it may not have been a BAQ report).
>
> Hope that heads you in some useful direction. Be glad to dig deeper
> tomorrow if you need.
> Rob
>
> ------------ --------- ---------
>
> Hi Group,
>
> I would like to print a BAQ report from a button. Would someone please
> tell me if this is possible and what I need to do to make it happen.
>
> Regards,
> Linda
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> .
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> Groups Links
>
>
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> .
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> Groups Links
>
>
>

[Non-text portions of this message have been removed]



















[Non-text portions of this message have been removed]

[system]

You can always just use bartender & the script editor if you have a copy or can get some money to get it.
I think I might have metioned this on a previous post.

All you do is use the click event.
Then Process.Start(path,parameters)

ex. path = "C:\Progra~1\Seagull\BarTender\8.0\bartend.exe"
ex. parameters = "/F=C:\Tags.btw /PRN= /P /X /?TagNumber="&TagNumber

You can even choos the printer. I insert in in my parameter using another variable.
Parameter.Insert(20,Printer)

--- In vantage@yahoogroups.com, DD <ddavis4569@...> wrote:
>
> I have created a button on a form to write the data to an excel file.
> Then the crystal report could use the excel file for the data file.
> Â
> Another Idea is to create a dashboard and add it to a new page on the form.
> The form could publish the data and the dashboard can subscribe to the data published from the form. Then there would be a crystal report from the dashboard. Dashboard reports are a little different from BAQ designer reports. It does allow you to pass the data to the Dashboard.
> Â
>
> --- On Mon, 7/6/09, Chris Thompson <chriselectrix@...> wrote:
>
>
> From: Chris Thompson <chriselectrix@...>
> Subject: Re: [Vantage] Print Report from Button
> To: vantage@yahoogroups.com
> Date: Monday, July 6, 2009, 10:56 AM
>
>
>
>
>
>
>
>
> Hi Ross,
>
> I would be interested to give it a go if you dont mind.
>
> Not sure about all this UD table stuff but I will give it a go in our test environment.
>
> Cheers,
>
> CHRIS
>
> ____________ _________ _________ __
> From: Ross Hughes <ross.hughes@ comcast.net>
> To: "vantage@yahoogroups .com" <vantage@yahoogroups .com>
> Sent: Monday, 6 July, 2009 16:49:24
> Subject: Re: [Vantage] Print Report from Button
>
> If the baq report is always drawn from the same module you could write
> the variables to a UD table and then have the baq report onload event
> pick them up on start up. I have had success with this but am unable
> to autopreview the report. I have to press preview again in the
> report dialog box. Not a real inconvenience.
>
> I can post the code if you are interested.
>
> Ross
>
> On Jul 6, 2009, at 7:34 AM, "Vic Drecchio" <vic.drecchio@ timco.aero>
> wrote:
>
> > Chris,
> >
> > This has been a topic of discussion in the past. It sure would be a
> > great feature to be able to pass context parameters to any BAQ
> > report but I don't know of any.
> >
> > If you are on the Customer Maintenance screen and have Customer
> > ABC123 in context and press a button to launch a BAQ report, there
> > is no way I know of to pass "ABC123" to the BAQ Crystal Report. We
> > all know Crystal Reports has the capability but the Vantage UI lacks
> > the capability to extract and send that value to the report.
> >
> > If there is a solution, I'm all ears. :-)
> >
> >
> >
> > Vic Drecchio
> > ERP Administrator
> > TIMCO Aviation Services
> > Greensboro, NC
> > Email: vic.drecchio@ timco.aero
> > Mobile: 704.530.3092
> >
> > -----Original Message-----
> > From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
> > Behalf Of Chris Thompson
> > Sent: Friday, July 03, 2009 10:33 AM
> > To: vantage@yahoogroups .com
> > Subject: Re: [Vantage] Print Report from Button
> >
> > Hi All,
> >
> > Does is there a way where I can use the below to launch a report to
> > print a label with the data that is on the screen?
> >
> > I want to add a button to the Contact tab in Customer Maintenance so
> > if we need to send that contact a letter after adding them, we can
> > press the button and it will print a label (or default letter) with
> > their name and company address on the label.
> >
> > Im surprised Epicor/Vantage dont have this as standard (well not
> > that suprised considering! :-) ).
> >
> > Cheers,
> >
> >
> >
> > CHRIS THOMPSON
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: Linda Lowney <llowney@pridesigns . com>
> > To: vantage@yahoogroups .com
> > Sent: Friday, 24 April, 2009 14:03:43
> > Subject: [Vantage] Print Report from Button
> >
> >
> >
> >
> >
> > Thank you Rob and Stephen for pointing me in the right direction. I
> > was
> > able to add the report to the button, but now I would like to pass the
> > job number parameter to the Crystal Report. Is that possible?
> >
> > Regards,
> >
> > Linda
> >
> > Rob is correct,
> >
> > It can be done
> >
> > The syntax is
> > ProcessCaller. LaunchForm( oTrans,"YourMenu ID")
> >
> > Create a menu id in menu maintenance this is what you
> > use.
> >
> > The menu would be either a crystal
> > report or BAQ report.
> >
> > Regards,
> >
> > Stephen
> >
> > ------------ --------- --------
> >
> > Might be possible by sticking a LaunchProcessCaller () statement
> > (...hope
> > that's the right VB keyword... Replying on a Palm w/out access to
> > Vantage to verify syntax) within a Sub triggered by clicking on your
> > custom button control.
> >
> > Never tried it personally so don't know if Crystal complicates it.
> > Pretty sure our primary programmer did something like this in one the
> > Receiving apps though (although it may not have been a BAQ report).
> >
> > Hope that heads you in some useful direction. Be glad to dig deeper
> > tomorrow if you need.
> > Rob
> >
> > ------------ --------- ---------
> >
> > Hi Group,
> >
> > I would like to print a BAQ report from a button. Would someone please
> > tell me if this is possible and what I need to do to make it happen.
> >
> > Regards,
> > Linda
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------ --------- --------- ------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must have already linked your email address to a yahoo id to enable
> > access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> > .
> > (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> > (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> > Groups Links
> >
> >
> >
> >
> >
> > ------------ --------- --------- ------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must have already linked your email address to a yahoo id to enable
> > access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> > .
> > (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> > (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> > Groups Links
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[system]

Hi Ross,

I have to admit, I was lost when you started talking about UD100/100A Table.

I will pass the notes on to our tech guys and see if it makes more sense to them.

Cheers,


CHRIS




________________________________
From: Ross Hughes <ross.hughes@...>
To: vantage@yahoogroups.com
Sent: Monday, 6 July, 2009 20:14:05
Subject: RE: [Vantage] Print Report from Button





Here are some note on passing values to BAQ reports by writing and reading
records:

In my case I was using the UD100/100A table.

Because I wanted to use the same location to write to I created a
'placeholder' record. I called the Key field 'REPORT'.

The fields originally populated were:
Key1 = REPORT
Key2 = 1
Key3 = 1
Key4 = 1
Key5 = 1

If you were going to use the customer table you could create a phony
customer with a CustID named 'REPORT' or something similar. All you

need is a fixed record that you can write your dynamic data to. Or maybe use
the COMPANY table.

I am writing a part number and a report style number to the table. I have
created a drop-down box with various labels to print to.

Create a button to call the BAQ report. In the onclick event I have the
following code:
'----------- --------- --------- --------- --------
Private Sub btnPrintLabel_ Click(ByVal Sender As Object, ByVal Args
As System.EventArgs) Handles btnPrintLabel. Click
'// ** Place Event Handling Code Here **

'Create a dataview for the current record
Dim edvUD100 As EpiDataView = CType(oTrans. EpiDataViews(“ UD100”),
EpiDataView)

'Create access to retrieve the REPORT record
Dim adpUD100 As UD100Adapter = New UD100Adapter( UD100Form)
adpUD100.BOConnect( )

Dim record As Boolean = adpUD100.GetByID( "REPORT", "1", "1", "1",
"1")
Dim dsUD100 As UD100DataSet = adpUD100.UD100Data

'Write the needed variables to the REPORT record and dispose of the
object
If txtPartNum.Text <> "" Then
dsUD100.Tables( "UD100"). Rows(0)(" ShortChar01" ) =
edvUD100.dataView( edvUD100. Row)(“Key1” )
dsUD100.Tables( "UD100"). Rows(0)(" Number10" ) =
edvUD100.dataView( edvUD100. Row)(“Number02” )
adpUD100.Update
adpUD100.Dispose( )

'Launch the BAQ form
dim opts as LaunchFormOptions = New LaunchFormOptions( )
ProcessCaller. LaunchForm( oTrans, "UDPLSLBL") 'this is the menu
ID of your BAQ report
Else
Messagebox.Show( "No Record Available.")
End If

End Sub
'----------- --------- --------- --------- --------

This will put whatever variables in the table of your choice and call the
report.

One thing to mention: since you have to call a BAQ report from menu id you
will need to connect it to a menu. I put it in the System

Management area since the parent folder is secured to most users. It is not
being called directly, but, you can do whatever you want with

this. Just know that the report is always going to call the last variable
posted to the table inless the code is modified to recognize where

it was called from. I don't know how to do this in Vantage. For this
approach, it works great.

Next create a customization in the BAQ report. Create an onload event
subroutine and paste the following code:
'----------- --------- --------- --------- --------

Private Sub BAQReportForm_ Load(ByVal sender As object, ByVal args As
EventArgs) Handles BAQReportForm. Load
'//
'// Add Event Handler Code
'//

'Retreive the variables from the REPORT record in the UD100
table
Dim recSelected As Boolean
Dim whereClause As String = "Key1 = 'REPORT'"
Dim dsUD100 As DataSet =
Epicor.Mfg.UI. FormFunctions. SearchFunctions. listLookup( oTrans,
"UD100Adapter" , recSelected, False,

whereClause)
If (recSelected) Then
Dim PartNumber As String =
dsUD100.Tables( 0).Rows(0) (“ShortChar01” )
Dim ReportStyleNumber As String =
dsUD100.Tables( 0).Rows(0) (“Number10” )
Dim edvPartNum As EpiDataView =
CType(oTrans. EpiDataViews( "ReportParam" ), EpiDataView)
edvPartNum.dataView (edvPartNum. Row)("Field1" ) =
PartNumber 'This is overriding the Option1 field
edvPartNum.dataView (edvPartNum. Row)("ReportStyl eNum") =
ReportStyleNumber 'This is overriding the report style number
End If

End Sub
'----------- --------- --------- --------- --------

That is it. It should pick up the variables you need. You will need to
modify the code depending on what variables you are trying to pass

and override in the BAQ report.

Let me know if you have any questions of further clarification.

Ross

P.S. Does anyone know how to auto-preview a BAQ report? If I could auto
print preview this it would be great.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Chris Thompson
Sent: Monday, July 06, 2009 10:56 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Print Report from Button

Hi Ross,

I would be interested to give it a go if you dont mind.

Not sure about all this UD table stuff but I will give it a go in our test
environment.

Cheers,

CHRIS

____________ _________ _________ __
From: Ross Hughes <ross.hughes@ comcast.net>
To: "vantage@yahoogroups .com" <vantage@yahoogroups .com>
Sent: Monday, 6 July, 2009 16:49:24
Subject: Re: [Vantage] Print Report from Button

If the baq report is always drawn from the same module you could write
the variables to a UD table and then have the baq report onload event
pick them up on start up. I have had success with this but am unable
to autopreview the report. I have to press preview again in the
report dialog box. Not a real inconvenience.

I can post the code if you are interested.

Ross

On Jul 6, 2009, at 7:34 AM, "Vic Drecchio" <vic.drecchio@ timco.aero>
wrote:

> Chris,
>
> This has been a topic of discussion in the past. It sure would be a
> great feature to be able to pass context parameters to any BAQ
> report but I don't know of any.
>
> If you are on the Customer Maintenance screen and have Customer
> ABC123 in context and press a button to launch a BAQ report, there
> is no way I know of to pass "ABC123" to the BAQ Crystal Report. We
> all know Crystal Reports has the capability but the Vantage UI lacks
> the capability to extract and send that value to the report.
>
> If there is a solution, I'm all ears. :-)
>
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email: vic.drecchio@ timco.aero
> Mobile: 704.530.3092
>
> -----Original Message-----
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
> Behalf Of Chris Thompson
> Sent: Friday, July 03, 2009 10:33 AM
> To: vantage@yahoogroups .com
> Subject: Re: [Vantage] Print Report from Button
>
> Hi All,
>
> Does is there a way where I can use the below to launch a report to
> print a label with the data that is on the screen?
>
> I want to add a button to the Contact tab in Customer Maintenance so
> if we need to send that contact a letter after adding them, we can
> press the button and it will print a label (or default letter) with
> their name and company address on the label.
>
> Im surprised Epicor/Vantage dont have this as standard (well not
> that suprised considering! :-) ).
>
> Cheers,
>
>
>
> CHRIS THOMPSON
>
>
>
>
> ____________ _________ _________ __
> From: Linda Lowney <llowney@pridesigns . com>
> To: vantage@yahoogroups .com
> Sent: Friday, 24 April, 2009 14:03:43
> Subject: [Vantage] Print Report from Button
>
>
>
>
>
> Thank you Rob and Stephen for pointing me in the right direction. I
> was
> able to add the report to the button, but now I would like to pass the
> job number parameter to the Crystal Report. Is that possible?
>
> Regards,
>
> Linda
>
> Rob is correct,
>
> It can be done
>
> The syntax is
> ProcessCaller. LaunchForm( oTrans,"YourMenu ID")
>
> Create a menu id in menu maintenance this is what you
> use.
>
> The menu would be either a crystal
> report or BAQ report.
>
> Regards,
>
> Stephen
>
> ------------ --------- --------
>
> Might be possible by sticking a LaunchProcessCaller () statement
> (...hope
> that's the right VB keyword... Replying on a Palm w/out access to
> Vantage to verify syntax) within a Sub triggered by clicking on your
> custom button control.
>
> Never tried it personally so don't know if Crystal complicates it.
> Pretty sure our primary programmer did something like this in one the
> Receiving apps though (although it may not have been a BAQ report).
>
> Hope that heads you in some useful direction. Be glad to dig deeper
> tomorrow if you need.
> Rob
>
> ------------ --------- ---------
>
> Hi Group,
>
> I would like to print a BAQ report from a button. Would someone please
> tell me if this is possible and what I need to do to make it happen.
>
> Regards,
> Linda
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto:

http://groups. yahoo.com/ group/vantage/ files/

> .
> (2) To search through old msg's goto: http://groups. yahoo.com/

group/vantage/ messages

> (3) To view links to Vendors that provide Vantage services goto:

http://groups. yahoo.com/ group/vantage/ linksYahoo!

> Groups Links
>
>
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto:

http://groups. yahoo.com/ group/vantage/ files/

> .
> (2) To search through old msg's goto: http://groups. yahoo.com/

group/vantage/ messages

> (3) To view links to Vendors that provide Vantage services goto:

http://groups. yahoo.com/ group/vantage/ linksYahoo!

> Groups Links
>
>
>

[Non-text portions of this message have been removed]

------------ --------- --------- ------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links







[Non-text portions of this message have been removed]

[system]

HI,

That also sounds like a good possibility.

Do you have any notes on how to get a dahboard to subscribe to date published from the form?

Which form would it be, as the Contact Name pulls from CustCnt and the address pulls from the Customer table?

Cheers,



CHRIS THOMPSON




________________________________
From: DD <ddavis4569@...>
To: vantage@yahoogroups.com
Sent: Monday, 6 July, 2009 20:48:51
Subject: Re: [Vantage] Print Report from Button





I have created a button on a form to write the data to an excel file.
Then the crystal report could use the excel file for the data file.
Â
Another Idea is to create a dashboard and add it to a new page on the form.
The form could publish the data and the dashboard can subscribe to the data published from the form. Then there would be a crystal report from the dashboard. Dashboard reports are a little different from BAQ designer reports. It does allow you to pass the data to the Dashboard.
Â

--- On Mon, 7/6/09, Chris Thompson <chriselectrix@ ymail.com> wrote:

From: Chris Thompson <chriselectrix@ ymail.com>
Subject: Re: [Vantage] Print Report from Button
To: vantage@yahoogroups .com
Date: Monday, July 6, 2009, 10:56 AM

Hi Ross,

I would be interested to give it a go if you dont mind.

Not sure about all this UD table stuff but I will give it a go in our test environment.

Cheers,

CHRIS

____________ _________ _________ __
From: Ross Hughes <ross.hughes@ comcast.net>
To: "vantage@yahoogroup s .com" <vantage@yahoogroup s .com>
Sent: Monday, 6 July, 2009 16:49:24
Subject: Re: [Vantage] Print Report from Button

If the baq report is always drawn from the same module you could write
the variables to a UD table and then have the baq report onload event
pick them up on start up. I have had success with this but am unable
to autopreview the report. I have to press preview again in the
report dialog box. Not a real inconvenience.

I can post the code if you are interested.

Ross

On Jul 6, 2009, at 7:34 AM, "Vic Drecchio" <vic.drecchio@ timco.aero>
wrote:

> Chris,
>
> This has been a topic of discussion in the past. It sure would be a
> great feature to be able to pass context parameters to any BAQ
> report but I don't know of any.
>
> If you are on the Customer Maintenance screen and have Customer
> ABC123 in context and press a button to launch a BAQ report, there
> is no way I know of to pass "ABC123" to the BAQ Crystal Report. We
> all know Crystal Reports has the capability but the Vantage UI lacks
> the capability to extract and send that value to the report.
>
> If there is a solution, I'm all ears. :-)
>
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email: vic.drecchio@ timco.aero
> Mobile: 704.530.3092
>
> -----Original Message-----
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
> Behalf Of Chris Thompson
> Sent: Friday, July 03, 2009 10:33 AM
> To: vantage@yahoogroups .com
> Subject: Re: [Vantage] Print Report from Button
>
> Hi All,
>
> Does is there a way where I can use the below to launch a report to
> print a label with the data that is on the screen?
>
> I want to add a button to the Contact tab in Customer Maintenance so
> if we need to send that contact a letter after adding them, we can
> press the button and it will print a label (or default letter) with
> their name and company address on the label.
>
> Im surprised Epicor/Vantage dont have this as standard (well not
> that suprised considering! :-) ).
>
> Cheers,
>
>
>
> CHRIS THOMPSON
>
>
>
>
> ____________ _________ _________ __
> From: Linda Lowney <llowney@pridesigns . com>
> To: vantage@yahoogroups .com
> Sent: Friday, 24 April, 2009 14:03:43
> Subject: [Vantage] Print Report from Button
>
>
>
>
>
> Thank you Rob and Stephen for pointing me in the right direction. I
> was
> able to add the report to the button, but now I would like to pass the
> job number parameter to the Crystal Report. Is that possible?
>
> Regards,
>
> Linda
>
> Rob is correct,
>
> It can be done
>
> The syntax is
> ProcessCaller. LaunchForm( oTrans,"YourMenu ID")
>
> Create a menu id in menu maintenance this is what you
> use.
>
> The menu would be either a crystal
> report or BAQ report.
>
> Regards,
>
> Stephen
>
> ------------ --------- --------
>
> Might be possible by sticking a LaunchProcessCaller () statement
> (...hope
> that's the right VB keyword... Replying on a Palm w/out access to
> Vantage to verify syntax) within a Sub triggered by clicking on your
> custom button control.
>
> Never tried it personally so don't know if Crystal complicates it.
> Pretty sure our primary programmer did something like this in one the
> Receiving apps though (although it may not have been a BAQ report).
>
> Hope that heads you in some useful direction. Be glad to dig deeper
> tomorrow if you need.
> Rob
>
> ------------ --------- ---------
>
> Hi Group,
>
> I would like to print a BAQ report from a button. Would someone please
> tell me if this is possible and what I need to do to make it happen.
>
> Regards,
> Linda
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> .
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> Groups Links
>
>
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> .
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> Groups Links
>
>
>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]

[system]

Hi,

Where does that code go?

Epicor had mentioned Bartender to me, but even they seemed a little sketchy as to how to do it.

In Epicor 9, it doesnt put click button details in the script - I thought it did in V8.

What is the script I would need to insert and on which page, if I wanted the Contact Name and Customer Address to print on a label through bartender?

Cheers,


CHRIS




________________________________
From: Michael McWilliams <mmcwilliams22@...>
To: vantage@yahoogroups.com
Sent: Monday, 6 July, 2009 21:09:20
Subject: [Vantage] Re: Print Report from Button





You can always just use bartender & the script editor if you have a copy or can get some money to get it.
I think I might have metioned this on a previous post.

All you do is use the click event.
Then Process.Start( path,parameters)

ex. path = "C:\Progra~1\ Seagull\BarTende r\8.0\bartend. exe"
ex. parameters = "/F=C:\Tags. btw /PRN= /P /X /?TagNumber= "&TagNumber

You can even choos the printer. I insert in in my parameter using another variable.
Parameter.Insert( 20,Printer)

--- In vantage@yahoogroups .com, DD <ddavis4569@ ...> wrote:
>
> I have created a button on a form to write the data to an excel file.
> Then the crystal report could use the excel file for the data file.
> Â
> Another Idea is to create a dashboard and add it to a new page on the form.
> The form could publish the data and the dashboard can subscribe to the data published from the form. Then there would be a crystal report from the dashboard. Dashboard reports are a little different from BAQ designer reports. It does allow you to pass the data to the Dashboard.
> Â
>
> --- On Mon, 7/6/09, Chris Thompson <chriselectrix@ ...> wrote:
>
>
> From: Chris Thompson <chriselectrix@ ...>
> Subject: Re: [Vantage] Print Report from Button
> To: vantage@yahoogroups .com
> Date: Monday, July 6, 2009, 10:56 AM
>
>
>
>
>
>
>
>
> Hi Ross,
>
> I would be interested to give it a go if you dont mind.
>
> Not sure about all this UD table stuff but I will give it a go in our test environment.
>
> Cheers,
>
> CHRIS
>
> ____________ _________ _________ __
> From: Ross Hughes <ross.hughes@ comcast.net>
> To: "vantage@yahoogroup s .com" <vantage@yahoogroup s .com>
> Sent: Monday, 6 July, 2009 16:49:24
> Subject: Re: [Vantage] Print Report from Button
>
> If the baq report is always drawn from the same module you could write
> the variables to a UD table and then have the baq report onload event
> pick them up on start up. I have had success with this but am unable
> to autopreview the report. I have to press preview again in the
> report dialog box. Not a real inconvenience.
>
> I can post the code if you are interested.
>
> Ross
>
> On Jul 6, 2009, at 7:34 AM, "Vic Drecchio" <vic.drecchio@ timco.aero>
> wrote:
>
> > Chris,
> >
> > This has been a topic of discussion in the past. It sure would be a
> > great feature to be able to pass context parameters to any BAQ
> > report but I don't know of any.
> >
> > If you are on the Customer Maintenance screen and have Customer
> > ABC123 in context and press a button to launch a BAQ report, there
> > is no way I know of to pass "ABC123" to the BAQ Crystal Report. We
> > all know Crystal Reports has the capability but the Vantage UI lacks
> > the capability to extract and send that value to the report.
> >
> > If there is a solution, I'm all ears. :-)
> >
> >
> >
> > Vic Drecchio
> > ERP Administrator
> > TIMCO Aviation Services
> > Greensboro, NC
> > Email: vic.drecchio@ timco.aero
> > Mobile: 704.530.3092
> >
> > -----Original Message-----
> > From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
> > Behalf Of Chris Thompson
> > Sent: Friday, July 03, 2009 10:33 AM
> > To: vantage@yahoogroups .com
> > Subject: Re: [Vantage] Print Report from Button
> >
> > Hi All,
> >
> > Does is there a way where I can use the below to launch a report to
> > print a label with the data that is on the screen?
> >
> > I want to add a button to the Contact tab in Customer Maintenance so
> > if we need to send that contact a letter after adding them, we can
> > press the button and it will print a label (or default letter) with
> > their name and company address on the label.
> >
> > Im surprised Epicor/Vantage dont have this as standard (well not
> > that suprised considering! :-) ).
> >
> > Cheers,
> >
> >
> >
> > CHRIS THOMPSON
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: Linda Lowney <llowney@pridesigns . com>
> > To: vantage@yahoogroups .com
> > Sent: Friday, 24 April, 2009 14:03:43
> > Subject: [Vantage] Print Report from Button
> >
> >
> >
> >
> >
> > Thank you Rob and Stephen for pointing me in the right direction. I
> > was
> > able to add the report to the button, but now I would like to pass the
> > job number parameter to the Crystal Report. Is that possible?
> >
> > Regards,
> >
> > Linda
> >
> > Rob is correct,
> >
> > It can be done
> >
> > The syntax is
> > ProcessCaller. LaunchForm( oTrans,"YourMenu ID")
> >
> > Create a menu id in menu maintenance this is what you
> > use.
> >
> > The menu would be either a crystal
> > report or BAQ report.
> >
> > Regards,
> >
> > Stephen
> >
> > ------------ --------- --------
> >
> > Might be possible by sticking a LaunchProcessCaller () statement
> > (...hope
> > that's the right VB keyword... Replying on a Palm w/out access to
> > Vantage to verify syntax) within a Sub triggered by clicking on your
> > custom button control.
> >
> > Never tried it personally so don't know if Crystal complicates it.
> > Pretty sure our primary programmer did something like this in one the
> > Receiving apps though (although it may not have been a BAQ report).
> >
> > Hope that heads you in some useful direction. Be glad to dig deeper
> > tomorrow if you need.
> > Rob
> >
> > ------------ --------- ---------
> >
> > Hi Group,
> >
> > I would like to print a BAQ report from a button. Would someone please
> > tell me if this is possible and what I need to do to make it happen.
> >
> > Regards,
> > Linda
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------ --------- --------- ------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must have already linked your email address to a yahoo id to enable
> > access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> > .
> > (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> > (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> > Groups Links
> >
> >
> >
> >
> >
> > ------------ --------- --------- ------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must have already linked your email address to a yahoo id to enable
> > access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> > .
> > (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> > (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> > Groups Links
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>







[Non-text portions of this message have been removed]

[system]

Hi,

I think Ive got it almost working.

I have created a BAQ with Contact Name, Customer Name, Addr 1 etc.

From that I have created a Dashboard.

On the top level (query) on the Dashboard, I have set a filter Customer.CustID = Dashboard Browse.

I have added a new sheet in the Customer Maintenance > Contact tab and added the Dashboard.

I have subscribed to UI data (includes retrieve button) and linked it on CustID.

When I view a customer's page for the first time, I can go to the tab and view a list of all contacts in the Dashboard.

However, there are a couple of things I can't quite work out ...

1) How can I shrink the results of the DB down further so it only shows the contact's information for the contact that I am viewing? This way I would get a label for EVERY contact when I click print (which I dont want). Im guessing I need at add another filter to the DB, but it can't be another Dashboard browse. What can it be?

2) If I add another contact, the dashboard doesn't automatically refresh. It doesnt refresh even if I click on the Retrieve button. The only way to view the new contact's details in the dashboard is to go to a different customer's details, then go back to the previous user's details. I dont know if this is just how it works, or if it isa bug with E9?

3) When I am ready to print, how can I change the format (in Crystal) to fit the results on to a label? I would have thought it would generate a .rpt for the DB, but it doesn't look like it does.


Any help with this would be greatly appreciated.

Regards,


CHRIS THOMPSON




________________________________
From: DD <ddavis4569@...>
To: vantage@yahoogroups.com
Sent: Monday, 6 July, 2009 20:48:51
Subject: Re: [Vantage] Print Report from Button





I have created a button on a form to write the data to an excel file.
Then the crystal report could use the excel file for the data file.
Â
Another Idea is to create a dashboard and add it to a new page on the form.
The form could publish the data and the dashboard can subscribe to the data published from the form. Then there would be a crystal report from the dashboard. Dashboard reports are a little different from BAQ designer reports. It does allow you to pass the data to the Dashboard.
Â

--- On Mon, 7/6/09, Chris Thompson <chriselectrix@ ymail.com> wrote:

From: Chris Thompson <chriselectrix@ ymail.com>
Subject: Re: [Vantage] Print Report from Button
To: vantage@yahoogroups .com
Date: Monday, July 6, 2009, 10:56 AM

Hi Ross,

I would be interested to give it a go if you dont mind.

Not sure about all this UD table stuff but I will give it a go in our test environment.

Cheers,

CHRIS

____________ _________ _________ __
From: Ross Hughes <ross.hughes@ comcast.net>
To: "vantage@yahoogroup s .com" <vantage@yahoogroup s .com>
Sent: Monday, 6 July, 2009 16:49:24
Subject: Re: [Vantage] Print Report from Button

If the baq report is always drawn from the same module you could write
the variables to a UD table and then have the baq report onload event
pick them up on start up. I have had success with this but am unable
to autopreview the report. I have to press preview again in the
report dialog box. Not a real inconvenience.

I can post the code if you are interested.

Ross

On Jul 6, 2009, at 7:34 AM, "Vic Drecchio" <vic.drecchio@ timco.aero>
wrote:

> Chris,
>
> This has been a topic of discussion in the past. It sure would be a
> great feature to be able to pass context parameters to any BAQ
> report but I don't know of any.
>
> If you are on the Customer Maintenance screen and have Customer
> ABC123 in context and press a button to launch a BAQ report, there
> is no way I know of to pass "ABC123" to the BAQ Crystal Report. We
> all know Crystal Reports has the capability but the Vantage UI lacks
> the capability to extract and send that value to the report.
>
> If there is a solution, I'm all ears. :-)
>
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email: vic.drecchio@ timco.aero
> Mobile: 704.530.3092
>
> -----Original Message-----
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
> Behalf Of Chris Thompson
> Sent: Friday, July 03, 2009 10:33 AM
> To: vantage@yahoogroups .com
> Subject: Re: [Vantage] Print Report from Button
>
> Hi All,
>
> Does is there a way where I can use the below to launch a report to
> print a label with the data that is on the screen?
>
> I want to add a button to the Contact tab in Customer Maintenance so
> if we need to send that contact a letter after adding them, we can
> press the button and it will print a label (or default letter) with
> their name and company address on the label.
>
> Im surprised Epicor/Vantage dont have this as standard (well not
> that suprised considering! :-) ).
>
> Cheers,
>
>
>
> CHRIS THOMPSON
>
>
>
>
> ____________ _________ _________ __
> From: Linda Lowney <llowney@pridesigns . com>
> To: vantage@yahoogroups .com
> Sent: Friday, 24 April, 2009 14:03:43
> Subject: [Vantage] Print Report from Button
>
>
>
>
>
> Thank you Rob and Stephen for pointing me in the right direction. I
> was
> able to add the report to the button, but now I would like to pass the
> job number parameter to the Crystal Report. Is that possible?
>
> Regards,
>
> Linda
>
> Rob is correct,
>
> It can be done
>
> The syntax is
> ProcessCaller. LaunchForm( oTrans,"YourMenu ID")
>
> Create a menu id in menu maintenance this is what you
> use.
>
> The menu would be either a crystal
> report or BAQ report.
>
> Regards,
>
> Stephen
>
> ------------ --------- --------
>
> Might be possible by sticking a LaunchProcessCaller () statement
> (...hope
> that's the right VB keyword... Replying on a Palm w/out access to
> Vantage to verify syntax) within a Sub triggered by clicking on your
> custom button control.
>
> Never tried it personally so don't know if Crystal complicates it.
> Pretty sure our primary programmer did something like this in one the
> Receiving apps though (although it may not have been a BAQ report).
>
> Hope that heads you in some useful direction. Be glad to dig deeper
> tomorrow if you need.
> Rob
>
> ------------ --------- ---------
>
> Hi Group,
>
> I would like to print a BAQ report from a button. Would someone please
> tell me if this is possible and what I need to do to make it happen.
>
> Regards,
> Linda
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> .
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> Groups Links
>
>
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> .
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> Groups Links
>
>
>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]

[system]

OK you are almost there.
The dashboard has the information of the contacts for the customer contacts.
Now create a Crystal report from the dashboard.
From the Dashboard editor select Tools / Report Tools / Design Crystal reports.
Note Where is put the data file and the name of the data file.
This report will have to be written from a blank report then link in the data file.
Create a Parameter field that can be a list of the Contacts from the dashboard.
They will select the contact that they want to print the label for.
Use this parameter in the select expert in Crystal.
Format the page size to match the label size in Crystal.
Â
Let me know if you need help setting up the Report options or in setting up the Crystal Report.
Do you have a printer driver for your label printer?

--- On Tue, 7/7/09, Chris Thompson <chriselectrix@...> wrote:


From: Chris Thompson <chriselectrix@...>
Subject: Re: [Vantage] Print Report from Button
To: vantage@yahoogroups.com
Date: Tuesday, July 7, 2009, 4:47 AM








Hi,

I think Ive got it almost working.

I have created a BAQ with Contact Name, Customer Name, Addr 1 etc.

From that I have created a Dashboard.

On the top level (query) on the Dashboard, I have set a filter Customer.CustID = Dashboard Browse.

I have added a new sheet in the Customer Maintenance > Contact tab and added the Dashboard.

I have subscribed to UI data (includes retrieve button) and linked it on CustID.

When I view a customer's page for the first time, I can go to the tab and view a list of all contacts in the Dashboard.

However, there are a couple of things I can't quite work out ...

1) How can I shrink the results of the DB down further so it only shows the contact's information for the contact that I am viewing? This way I would get a label for EVERY contact when I click print (which I dont want). Im guessing I need at add another filter to the DB, but it can't be another Dashboard browse. What can it be?

2) If I add another contact, the dashboard doesn't automatically refresh. It doesnt refresh even if I click on the Retrieve button. The only way to view the new contact's details in the dashboard is to go to a different customer's details, then go back to the previous user's details. I dont know if this is just how it works, or if it isa bug with E9?

3) When I am ready to print, how can I change the format (in Crystal) to fit the results on to a label? I would have thought it would generate a .rpt for the DB, but it doesn't look like it does.

Any help with this would be greatly appreciated.

Regards,

CHRIS THOMPSON

____________ _________ _________ __
From: DD <ddavis4569@yahoo. com>
To: vantage@yahoogroups .com
Sent: Monday, 6 July, 2009 20:48:51
Subject: Re: [Vantage] Print Report from Button

I have created a button on a form to write the data to an excel file.
Then the crystal report could use the excel file for the data file.
Â
Another Idea is to create a dashboard and add it to a new page on the form.
The form could publish the data and the dashboard can subscribe to the data published from the form. Then there would be a crystal report from the dashboard. Dashboard reports are a little different from BAQ designer reports. It does allow you to pass the data to the Dashboard.
Â

--- On Mon, 7/6/09, Chris Thompson <chriselectrix@ ymail.com> wrote:

From: Chris Thompson <chriselectrix@ ymail.com>
Subject: Re: [Vantage] Print Report from Button
To: vantage@yahoogroups .com
Date: Monday, July 6, 2009, 10:56 AM

Hi Ross,

I would be interested to give it a go if you dont mind.

Not sure about all this UD table stuff but I will give it a go in our test environment.

Cheers,

CHRIS

____________ _________ _________ __
From: Ross Hughes <ross.hughes@ comcast.net>
To: "vantage@yahoogroup s .com" <vantage@yahoogroup s .com>
Sent: Monday, 6 July, 2009 16:49:24
Subject: Re: [Vantage] Print Report from Button

If the baq report is always drawn from the same module you could write
the variables to a UD table and then have the baq report onload event
pick them up on start up. I have had success with this but am unable
to autopreview the report. I have to press preview again in the
report dialog box. Not a real inconvenience.

I can post the code if you are interested.

Ross

On Jul 6, 2009, at 7:34 AM, "Vic Drecchio" <vic.drecchio@ timco.aero>
wrote:

> Chris,
>
> This has been a topic of discussion in the past. It sure would be a
> great feature to be able to pass context parameters to any BAQ
> report but I don't know of any.
>
> If you are on the Customer Maintenance screen and have Customer
> ABC123 in context and press a button to launch a BAQ report, there
> is no way I know of to pass "ABC123" to the BAQ Crystal Report. We
> all know Crystal Reports has the capability but the Vantage UI lacks
> the capability to extract and send that value to the report.
>
> If there is a solution, I'm all ears. :-)
>
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email: vic.drecchio@ timco.aero
> Mobile: 704.530.3092
>
> -----Original Message-----
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
> Behalf Of Chris Thompson
> Sent: Friday, July 03, 2009 10:33 AM
> To: vantage@yahoogroups .com
> Subject: Re: [Vantage] Print Report from Button
>
> Hi All,
>
> Does is there a way where I can use the below to launch a report to
> print a label with the data that is on the screen?
>
> I want to add a button to the Contact tab in Customer Maintenance so
> if we need to send that contact a letter after adding them, we can
> press the button and it will print a label (or default letter) with
> their name and company address on the label.
>
> Im surprised Epicor/Vantage dont have this as standard (well not
> that suprised considering! :-) ).
>
> Cheers,
>
>
>
> CHRIS THOMPSON
>
>
>
>
> ____________ _________ _________ __
> From: Linda Lowney <llowney@pridesigns . com>
> To: vantage@yahoogroups .com
> Sent: Friday, 24 April, 2009 14:03:43
> Subject: [Vantage] Print Report from Button
>
>
>
>
>
> Thank you Rob and Stephen for pointing me in the right direction. I
> was
> able to add the report to the button, but now I would like to pass the
> job number parameter to the Crystal Report. Is that possible?
>
> Regards,
>
> Linda
>
> Rob is correct,
>
> It can be done
>
> The syntax is
> ProcessCaller. LaunchForm( oTrans,"YourMenu ID")
>
> Create a menu id in menu maintenance this is what you
> use.
>
> The menu would be either a crystal
> report or BAQ report.
>
> Regards,
>
> Stephen
>
> ------------ --------- --------
>
> Might be possible by sticking a LaunchProcessCaller () statement
> (...hope
> that's the right VB keyword... Replying on a Palm w/out access to
> Vantage to verify syntax) within a Sub triggered by clicking on your
> custom button control.
>
> Never tried it personally so don't know if Crystal complicates it.
> Pretty sure our primary programmer did something like this in one the
> Receiving apps though (although it may not have been a BAQ report).
>
> Hope that heads you in some useful direction. Be glad to dig deeper
> tomorrow if you need.
> Rob
>
> ------------ --------- ---------
>
> Hi Group,
>
> I would like to print a BAQ report from a button. Would someone please
> tell me if this is possible and what I need to do to make it happen.
>
> Regards,
> Linda
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> .
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> Groups Links
>
>
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> .
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> Groups Links
>
>
>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



















[Non-text portions of this message have been removed]

[system]

Hi,

I think that I am almost there.

I have Generated Sample Data from the DashBoard and brought that data into a new .rpt file.

I have set the CustCnt.Name as the parameter field and used it in 'Select Expert ...'.

The only things I can't do now are:

1)Â set the new report to be the default report for the dashboard

2) get the embedded dashboard on my Cutomer Maintenence page to update instantly when I add a contact (without having to view a different customer then re-visit the customer where I have added the contact). The retrieve button doesn't seem to do anything.

3) i do have a print driver for my printer - can this be embedded so it always prints to the correct printer?

Any help would be appreciated.




________________________________
From: DD <ddavis4569@...>
To: vantage@yahoogroups.com
Sent: Tuesday, 7 July, 2009 21:53:30
Subject: Re: [Vantage] Print Report from Button





OK you are almost there.
The dashboard has the information of the contacts for the customer contacts.
Now create a Crystal report from the dashboard.
From the Dashboard editor select Tools / Report Tools / Design Crystal reports.
Note Where is put the data file and the name of the data file.
This report will have to be written from a blank report then link in the data file.
Create a Parameter field that can be a list of the Contacts from the dashboard.
They will select the contact that they want to print the label for.
Use this parameter in the select expert in Crystal.
Format the page size to match the label size in Crystal.
Â
Let me know if you need help setting up the Report options or in setting up the Crystal Report.
Do you have a printer driver for your label printer?

--- On Tue, 7/7/09, Chris Thompson <chriselectrix@ ymail.com> wrote:

From: Chris Thompson <chriselectrix@ ymail.com>
Subject: Re: [Vantage] Print Report from Button
To: vantage@yahoogroups .com
Date: Tuesday, July 7, 2009, 4:47 AM

Hi,

I think Ive got it almost working.

I have created a BAQ with Contact Name, Customer Name, Addr 1 etc.

From that I have created a Dashboard.

On the top level (query) on the Dashboard, I have set a filter Customer.CustID = Dashboard Browse.

I have added a new sheet in the Customer Maintenance > Contact tab and added the Dashboard.

I have subscribed to UI data (includes retrieve button) and linked it on CustID.

When I view a customer's page for the first time, I can go to the tab and view a list of all contacts in the Dashboard.

However, there are a couple of things I can't quite work out ...

1) How can I shrink the results of the DB down further so it only shows the contact's information for the contact that I am viewing? This way I would get a label for EVERY contact when I click print (which I dont want). Im guessing I need at add another filter to the DB, but it can't be another Dashboard browse. What can it be?

2) If I add another contact, the dashboard doesn't automatically refresh. It doesnt refresh even if I click on the Retrieve button. The only way to view the new contact's details in the dashboard is to go to a different customer's details, then go back to the previous user's details. I dont know if this is just how it works, or if it isa bug with E9?

3) When I am ready to print, how can I change the format (in Crystal) to fit the results on to a label? I would have thought it would generate a .rpt for the DB, but it doesn't look like it does.

Any help with this would be greatly appreciated.

Regards,

CHRIS THOMPSON

____________ _________ _________ __
From: DD <ddavis4569@ yahoo. com>
To: vantage@yahoogroups .com
Sent: Monday, 6 July, 2009 20:48:51
Subject: Re: [Vantage] Print Report from Button

I have created a button on a form to write the data to an excel file.
Then the crystal report could use the excel file for the data file.
Â
Another Idea is to create a dashboard and add it to a new page on the form.
The form could publish the data and the dashboard can subscribe to the data published from the form. Then there would be a crystal report from the dashboard. Dashboard reports are a little different from BAQ designer reports. It does allow you to pass the data to the Dashboard.
Â

--- On Mon, 7/6/09, Chris Thompson <chriselectrix@ ymail.com> wrote:

From: Chris Thompson <chriselectrix@ ymail.com>
Subject: Re: [Vantage] Print Report from Button
To: vantage@yahoogroups .com
Date: Monday, July 6, 2009, 10:56 AM

Hi Ross,

I would be interested to give it a go if you dont mind.

Not sure about all this UD table stuff but I will give it a go in our test environment.

Cheers,

CHRIS

____________ _________ _________ __
From: Ross Hughes <ross.hughes@ comcast.net>
To: "vantage@yahoogroup s .com" <vantage@yahoogroup s .com>
Sent: Monday, 6 July, 2009 16:49:24
Subject: Re: [Vantage] Print Report from Button

If the baq report is always drawn from the same module you could write
the variables to a UD table and then have the baq report onload event
pick them up on start up. I have had success with this but am unable
to autopreview the report. I have to press preview again in the
report dialog box. Not a real inconvenience.

I can post the code if you are interested.

Ross

On Jul 6, 2009, at 7:34 AM, "Vic Drecchio" <vic.drecchio@ timco.aero>
wrote:

> Chris,
>
> This has been a topic of discussion in the past. It sure would be a
> great feature to be able to pass context parameters to any BAQ
> report but I don't know of any.
>
> If you are on the Customer Maintenance screen and have Customer
> ABC123 in context and press a button to launch a BAQ report, there
> is no way I know of to pass "ABC123" to the BAQ Crystal Report. We
> all know Crystal Reports has the capability but the Vantage UI lacks
> the capability to extract and send that value to the report.
>
> If there is a solution, I'm all ears. :-)
>
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email: vic.drecchio@ timco.aero
> Mobile: 704.530.3092
>
> -----Original Message-----
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
> Behalf Of Chris Thompson
> Sent: Friday, July 03, 2009 10:33 AM
> To: vantage@yahoogroups .com
> Subject: Re: [Vantage] Print Report from Button
>
> Hi All,
>
> Does is there a way where I can use the below to launch a report to
> print a label with the data that is on the screen?
>
> I want to add a button to the Contact tab in Customer Maintenance so
> if we need to send that contact a letter after adding them, we can
> press the button and it will print a label (or default letter) with
> their name and company address on the label.
>
> Im surprised Epicor/Vantage dont have this as standard (well not
> that suprised considering! :-) ).
>
> Cheers,
>
>
>
> CHRIS THOMPSON
>
>
>
>
> ____________ _________ _________ __
> From: Linda Lowney <llowney@pridesigns . com>
> To: vantage@yahoogroups .com
> Sent: Friday, 24 April, 2009 14:03:43
> Subject: [Vantage] Print Report from Button
>
>
>
>
>
> Thank you Rob and Stephen for pointing me in the right direction. I
> was
> able to add the report to the button, but now I would like to pass the
> job number parameter to the Crystal Report. Is that possible?
>
> Regards,
>
> Linda
>
> Rob is correct,
>
> It can be done
>
> The syntax is
> ProcessCaller. LaunchForm( oTrans,"YourMenu ID")
>
> Create a menu id in menu maintenance this is what you
> use.
>
> The menu would be either a crystal
> report or BAQ report.
>
> Regards,
>
> Stephen
>
> ------------ --------- --------
>
> Might be possible by sticking a LaunchProcessCaller () statement
> (...hope
> that's the right VB keyword... Replying on a Palm w/out access to
> Vantage to verify syntax) within a Sub triggered by clicking on your
> custom button control.
>
> Never tried it personally so don't know if Crystal complicates it.
> Pretty sure our primary programmer did something like this in one the
> Receiving apps though (although it may not have been a BAQ report).
>
> Hope that heads you in some useful direction. Be glad to dig deeper
> tomorrow if you need.
> Rob
>
> ------------ --------- ---------
>
> Hi Group,
>
> I would like to print a BAQ report from a button. Would someone please
> tell me if this is possible and what I need to do to make it happen.
>
> Regards,
> Linda
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> .
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> Groups Links
>
>
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto: http://groups. yahoo.com/ group/vantage/ files/
> .
> (2) To search through old msg's goto: http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups. yahoo.com/ group/vantage/ linksYahoo!
> Groups Links
>
>
>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]