AR Invoice Form - Different Form depending on Customer - Vantage

Yahoo Archive
1
Thanks, I forgot about that limitation.

The ARForm.rpt is full of subreports, so obviously my suggestion won't work.

It really depends on what kind of variations you're looking for, but it sounds like your approach is the only way to go for the ARForm.

-bws



Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Sean McDaniel
Sent: Tuesday, May 04, 2010 12:46 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405

Subreports might not be the best way to go on this. You are limited to only a single level of subreport, so this is usually the first problem in going this direction.



What you can do is right-click on a section and “add section below”, Copy from the above section and make any changes. Then on the section detail, create a suppression formula allowing only one section to be visible at a time.



Easy to do and no linking of subreports.







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brychan Williams

Sent: Tuesday, May 04, 2010 12:17 PM

To: vantage@yahoogroups.com

Subject: Re: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405











Hi,



Thanks , thats what I thought.... Would be a nice feature....







________________________________

From: Brian W. Spolarich <bspolarich@... <mailto:bspolarich%40advancedphotonix.com> >

To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

Sent: Tue, 4 May, 2010 14:23:26

Subject: RE: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405





I don't think you'll be able to do this in Vantage, at least not easily, so you'll need to do it in Crystal.



Here's one thought though: use subreports.



Basically suppress all of the sections of a blank report except for the report header.



Insert as many additional report header sections as you need for the number of different report variations you're going to have.



Insert one subreport in each of the report header sections. If you already have the report files for the intended variations, you can select them when you create the subreport. Otherwise import the base form and modify each subreport variation as you need to.



Link each subreport's data to the main reports data bringing in all tables.



Conditionally suppress each section based on the customer ID so that only one shows at a time.



That should do what you want.



-bws





Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix

bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com



-----Original Message-----

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of brychanwilliams

Sent: Tuesday, May 04, 2010 7:33 AM

To: vantage@yahoogroups .com

Subject: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405



Hi,



I was wondering wether there is way to automate a different ar invoice form depending on the customer. I know that you could have one crystal report and do some tricks to create different outputs but is there way to call a completely different crystal report automatically , rather than the user selecting a different report style .



Thanks in advance.



Hi



[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
2
Hi,

I was wondering wether there is way to automate a different ar invoice form depending on the customer. I know that you could have one crystal report and do some tricks to create different outputs but is there way to call a completely different crystal report automatically , rather than the user selecting a different report style .

Thanks in advance.
3
Sure based on a field equaling something or not equaling something you could conditionally suppress another field or logo


I have one rpt for 4 different logos and addresses based on the custid
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "brychanwilliams" <brychanwilliams@...>
Date: Tue, 04 May 2010 11:33:16
To: <vantage@yahoogroups.com>
Subject: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405

Hi,

I was wondering wether there is way to automate a different ar invoice form depending on the customer. I know that you could have one crystal report and do some tricks to create different outputs but is there way to call a completely different crystal report automatically , rather than the user selecting a different report style .

Thanks in advance.




[Non-text portions of this message have been removed]
4
I don't think you'll be able to do this in Vantage, at least not easily, so you'll need to do it in Crystal.

Here's one thought though: use subreports.

Basically suppress all of the sections of a blank report except for the report header.

Insert as many additional report header sections as you need for the number of different report variations you're going to have.

Insert one subreport in each of the report header sections. If you already have the report files for the intended variations, you can select them when you create the subreport. Otherwise import the base form and modify each subreport variation as you need to.

Link each subreport's data to the main reports data bringing in all tables.

Conditionally suppress each section based on the customer ID so that only one shows at a time.

That should do what you want.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of brychanwilliams
Sent: Tuesday, May 04, 2010 7:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405

Hi,

I was wondering wether there is way to automate a different ar invoice form depending on the customer. I know that you could have one crystal report and do some tricks to create different outputs but is there way to call a completely different crystal report automatically , rather than the user selecting a different report style .

Thanks in advance.
5
Hi,

Thanks , thats what I thought.... Would be a nice feature....

Â



________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Tue, 4 May, 2010 14:23:26
Subject: RE: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405

Â
I don't think you'll be able to do this in Vantage, at least not easily, so you'll need to do it in Crystal.

Here's one thought though: use subreports.

Basically suppress all of the sections of a blank report except for the report header.

Insert as many additional report header sections as you need for the number of different report variations you're going to have.

Insert one subreport in each of the report header sections. If you already have the report files for the intended variations, you can select them when you create the subreport. Otherwise import the base form and modify each subreport variation as you need to.

Link each subreport's data to the main reports data bringing in all tables.

Conditionally suppress each section based on the customer ID so that only one shows at a time.

That should do what you want.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of brychanwilliams
Sent: Tuesday, May 04, 2010 7:33 AM
To: vantage@yahoogroups .com
Subject: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405

Hi,

I was wondering wether there is way to automate a different ar invoice form depending on the customer. I know that you could have one crystal report and do some tricks to create different outputs but is there way to call a completely different crystal report automatically , rather than the user selecting a different report style .

Thanks in advance.



Hi




[Non-text portions of this message have been removed]
6
Subreports might not be the best way to go on this. You are limited to only a single level of subreport, so this is usually the first problem in going this direction.

What you can do is right-click on a section and “add section below”, Copy from the above section and make any changes. Then on the section detail, create a suppression formula allowing only one section to be visible at a time.

Easy to do and no linking of subreports.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brychan Williams
Sent: Tuesday, May 04, 2010 12:17 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405





Hi,

Thanks , thats what I thought.... Would be a nice feature....



________________________________
From: Brian W. Spolarich <bspolarich@... <mailto:bspolarich%40advancedphotonix.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, 4 May, 2010 14:23:26
Subject: RE: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405


I don't think you'll be able to do this in Vantage, at least not easily, so you'll need to do it in Crystal.

Here's one thought though: use subreports.

Basically suppress all of the sections of a blank report except for the report header.

Insert as many additional report header sections as you need for the number of different report variations you're going to have.

Insert one subreport in each of the report header sections. If you already have the report files for the intended variations, you can select them when you create the subreport. Otherwise import the base form and modify each subreport variation as you need to.

Link each subreport's data to the main reports data bringing in all tables.

Conditionally suppress each section based on the customer ID so that only one shows at a time.

That should do what you want.

-bws



Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of brychanwilliams
Sent: Tuesday, May 04, 2010 7:33 AM
To: vantage@yahoogroups .com
Subject: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405

Hi,

I was wondering wether there is way to automate a different ar invoice form depending on the customer. I know that you could have one crystal report and do some tricks to create different outputs but is there way to call a completely different crystal report automatically , rather than the user selecting a different report style .

Thanks in advance.

Hi

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





[Non-text portions of this message have been removed]
7
Thanks for the insight




________________________________
From: Sean McDaniel <smcdaniel@...>
To: vantage@yahoogroups.com
Sent: Tue, 4 May, 2010 17:46:07
Subject: RE: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405

Â
Subreports might not be the best way to go on this. You are limited to only a single level of subreport, so this is usually the first problem in going this direction.

What you can do is right-click on a section and “add section below”, Copy from the above section and make any changes. Then on the section detail, create a suppression formula allowing only one section to be visible at a time.

Easy to do and no linking of subreports.



From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Brychan Williams
Sent: Tuesday, May 04, 2010 12:17 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405





Hi,

Thanks , thats what I thought.... Would be a nice feature....



____________ _________ _________ __
From: Brian W. Spolarich <bspolarich@advanced photonix. com <mailto:bspolarich% 40advancedphoton ix.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Tue, 4 May, 2010 14:23:26
Subject: RE: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405


I don't think you'll be able to do this in Vantage, at least not easily, so you'll need to do it in Crystal.

Here's one thought though: use subreports.

Basically suppress all of the sections of a blank report except for the report header.

Insert as many additional report header sections as you need for the number of different report variations you're going to have.

Insert one subreport in each of the report header sections. If you already have the report files for the intended variations, you can select them when you create the subreport. Otherwise import the base form and modify each subreport variation as you need to.

Link each subreport's data to the main reports data bringing in all tables.

Conditionally suppress each section based on the customer ID so that only one shows at a time.

That should do what you want.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf Of brychanwilliams
Sent: Tuesday, May 04, 2010 7:33 AM
To: vantage@yahoogroups .com
Subject: [Vantage] AR Invoice Form - Different Form depending on Customer - Vantage - 8.03.405

Hi,

I was wondering wether there is way to automate a different ar invoice form depending on the customer. I know that you could have one crystal report and do some tricks to create different outputs but is there way to call a completely different crystal report automatically , rather than the user selecting a different report style .

Thanks in advance.

Hi

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




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


Than




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