Solved

Goldmine report yields blank output

Posted on 2011-09-13
13
670 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

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

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

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

As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
Viewers will learn how to use the Hootsuite Dashboard.
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.

724 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