Solved

Goldmine report yields blank output

Posted on 2011-09-13
13
606 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
 

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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

If your app took Google’s lash recently, here are the 5 most likely reasons.
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
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.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now