Fields/Tables in Goldmine 6.0??

[sandingdude]

I am trying to find out what fields/tables are available for writing reports in Goldmin 6.0? I am trying to write a customer report and I need to know what are &syfields? As well as how to write a macro? Please help. I am very confused. Thank you in advance.

 

[groundedagain]

You can find a manual on writing goldmine reports here

http://support.frontrange.com/attachments/manuals/goldmine/5/GoldMine5Reports.PDF

Jason Wienert
Central City Communications
Brisbane, Australia.

 

[sandingdude]

Thank you so much!

 

[sandingdude]

Jason

Thanks for the document. I'm trying to insert the following expression, but I'm receiving a field type mismatch. Any ideas? Thanks again.

.if.(&syfield12)="0".then."No Sales".else.(calc->closepert)

 

[groundedagain]

Can you please explain what you are trying to achieve and what sort of report you are using in GoldMine?



Jason Wienert
Central City Communications
Brisbane, Australia

http://www.centralcity.com.au

GoldMine, ACCPAC CRM

 

[sandingdude]

Hi Jason

This is what I trying to do with the above expression:

&syfield12 is I believe successful calls in the completed analysis report

I wrote a new expression of the report which takes the completed sales/successful calls x 100 = % of closed sales out of success calls - I defined this expression as CLOSEPERT

Im writing the above expression so incase the successful calls (&syfield12) equals 0 I dont get an error stating that "can't define by zero"

But when Im using the following expression in the report:

.if.(&syfield12)="0".then."No Sales".else.(calc->closepert)

I receive a type field mismatch.

Any Ideas? Did I define the calc->closepert correctly?

Thank you in advance.

 

[sandingdude]

Jason I was able to figure it out.

THanks for your help.

I posted another post in the Goldmine Forum with questions about a custom report. Is this something you can help me with?

Thanks

 

[groundedagain]

Yes probably, I have been very busy so haven't been doing much on the forums of late but give us a go.

Regards

Jason

Jason Wienert
Central City Communications
Brisbane, Australia

http://www.centralcity.com.au

GoldMine, ACCPAC CRM