Solved

Goldmine report yields blank output

Posted on 2011-09-13
13
632 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ODBC Question 3 40
SonarQube on Linux vs Windows 3 23
tried to place tif image in 6.5 2 20
Isolate Drive C without physically disconnecting other hard drives 7 31
A list of useful business intelligence software.
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

813 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

16 Experts available now in Live!

Get 1:1 Help Now