Community
Showing results for 
Search instead for 
Do you mean 
Reply

Custom1, custom2, etc fields in Report Designer

Accepted Solution Solved
vb
Copper Contributor
Posts: 36
Country: USA
Accepted Solution

Custom1, custom2, etc fields in Report Designer

I am editing an envelope template in Act 2007.

 

I see the [Custom] fields in the layout.  I can see the results they create.  For example, City, State Zip concatanated all on one line.  I don't see how to:

 

-  View the definition of one of them, say Custom2?

-  How to create a custom field (like these) myself?

 

Thanks.


Accepted Solutions
Solution
Accepted by topic author vb
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Custom1, custom2, etc fields in Report Designer

In any given template they are defined but they aren't predefined such that you could copy the custom field and have the program script included..

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129

View solution in original post


All Replies
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Custom1, custom2, etc fields in Report Designer

You use Visual Basic script programming.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
vb
Copper Contributor
Posts: 36
Country: USA

Re: Custom1, custom2, etc fields in Report Designer

Okay, that is good to know.   I can see the OnPrint script that goes with the envelope.  Is there a description of what these various predefined System (custom) fields are?  Or do I always have to look inside the script to find out?

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Custom1, custom2, etc fields in Report Designer

The custom field is simply a target for the results of the VB programming script. They aren't predefined, you need to provide the programming.. The program scripts can be simple or complex, depending on needs. I've done report templates with over 700 lines of script programming.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
vb
Copper Contributor
Posts: 36
Country: USA

Re: Custom1, custom2, etc fields in Report Designer

You say that custom1, custom2, etc. aren't predefined, but I have a new Act 2007 database and it has an OnPrint script for the envelopes and fields created by that script called custom1, custom2, custom3 and custom4.  Didn't these come in the installed database?  Or did our database install vendor put them in?

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Custom1, custom2, etc fields in Report Designer

Just to help clarify, the 'Custom' you see on the templates aren't considered actual fields - but rather a script to pull information from fields.  The use of the 'Custom' script allows for information to be better manipulated.  A common example is for an address, when you want to close up the line that would be inserted for a Suite #.

 

Here is an article which explains how to create custom fields for removing spaces, it will give you a better idea of how 'Custom' works: KB Article 14331

Greg Martin
Sage
Solution
Accepted by topic author vb
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Custom1, custom2, etc fields in Report Designer

In any given template they are defined but they aren't predefined such that you could copy the custom field and have the program script included..

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129