Solved

Goldmine report yields blank output

Posted on 2011-09-13
13
644 Views
Last Modified: 2012-05-12
I use Goldmine version 9.0.2. Currently trying to print labels, using Goldmine reports feature. The reports center features various pre-existing labels. However, the address block in existing labels is defined by a macro "&Company&Address". The output of this macro does not include "Title" from the database. I tried customizing an existing label by changing its macro to "&Name&Address", which includes Title, but the output is blank.

This effort is to enable us print labels directly from Goldmine, without having to export contacts firt to Microsoft Excel.
0
Comment
Question by:bobox00
  • 8
  • 5
13 Comments
 
LVL 12

Expert Comment

by:GMGenius
ID: 36530739
&Name is not valid

try

&NameTitleAddress


instead
0
 

Author Comment

by:bobox00
ID: 36530818
GMGenius kindly review the list on page 47 of this link http://support.frontrange.com/attachments/manuals/goldmine/5/GoldMine5Reports.PDF. &Name&Address is there, but I'm not sure whether the list is a valid one.
0
 
LVL 12

Expert Comment

by:GMGenius
ID: 36531443
I tested it and it was not valid in 9
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:bobox00
ID: 36531486
I just tried &NameTitleAddress. Still getting blank output.
0
 
LVL 12

Expert Comment

by:GMGenius
ID: 36531760
when in GoldMine, press CTRL+SHIFT+D (must be a master user) you can then test the & Macros there

&NameTitleAddress should work

Can you attach the lable report file to this and I can check it
0
 

Author Comment

by:bobox00
ID: 36531834
&NameTitleAddress works when use the CTRL+Shift+D dialog box. However, in that same dialog box &Company&Address doesn't work.

It appears that the report center uses a different a different set of macros, from the ones used by CTRL+Shift+D
0
 

Author Comment

by:bobox00
ID: 36531862
To see the image below, in GoldMine 9
1. Click Go To menu > Reports > Report
2. Expand Goldmine Reports > Labels and Envelopes
3. Right-click Avery 5164 Primary Contacts and select Layout
gmlabel-reportcentermacro.jpg
0
 
LVL 12

Expert Comment

by:GMGenius
ID: 36531905
&Company&Address is 2 macros, so they are &Company and then &Address

I will test and return
0
 
LVL 12

Accepted Solution

by:
GMGenius earned 500 total points
ID: 36532274
Ok, looks like GM9 is bugged (what a surprise!!!)

Best solution is to remove the field and insert 2 new ones F3 (Insert > Expression Field)

 Fields
In the first one add the following code
contact1->contact+sys->para_break+contact1->title

Open in new window

place it then double click and set the dialog as pictured.

 Dialog
In the second expression field add

(.if.contact1->address1<>"".then.contact1->address1+sys->para_break)+(.if.contact1->address2<>"".then.contact1->address2+sys->para_break)+(.if.contact1->city<>"".then.contact1->city+sys->para_break)+(.if.contact1->state<>"".then.contact1->state+sys->para_break)+contact1->zip

Open in new window

0
 

Author Comment

by:bobox00
ID: 36532530
What can i say? You're a Goldmine genius indeed. Thanks you so, so much!!
0
 

Author Closing Comment

by:bobox00
ID: 36532539
Great solution!
0
 

Author Comment

by:bobox00
ID: 36532550
GMGenius, I would like to have city, state and zip as seen below:

City, State Zip

Kindly help with this.
0
 

Author Comment

by:bobox00
ID: 36532628
Got it!
(.if.contact1->address1<>"".then.contact1->address1+sys->para_break)+(.if.contact1->address2<>"".then.contact1->address2+sys->para_break)+&citystatezip

Open in new window

0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
All of the resources available today make learning a new digital media easier than ever-- if you know where to begin. This is a clear, simple guide to a few of the basic digital art mediums and how to begin learning them on your own.
The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.
Using Adobe Premiere Pro, the viewer will learn how to set up a sequence with proper settings, importing pictures, rendering, and exporting the finished product.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question