Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition) » Deleting Reports
Post new topic  Reply to topic View previous topic :: View next topic 
Deleting Reports
PostPosted: Fri Jan 20, 2017 4:53 pm Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




In the Reports Center, GMPE 2016.1 the Analysis Reports then Forecasted by Users, they have over 2,000 reports most of which are not assigned to users which need to be deleted.

Question, where are these reports located so that I can probably delete selected reports maybe using SQL Query tools

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Sat Jan 21, 2017 1:41 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




Sure, they're in the REPORT32 table, the rectype represents the category, the userid is the owner.

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Sun Jan 22, 2017 8:01 pm Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




Many thanks for confirming my thoughts. The reason for my question is that when I go to GoldMine Reports, Analysis Reports, and then Forecasted Sales by Users; it lists 2,397 sales and Company Sales, 1,368,958,042.00. In this area, 49 are assigned to users and 2,348 are not listed to users (these are the one needed to be deleted).
In SQL Server when I do a count of Reports32, and it lists only 111 count for the 2 users.

My count in Reports32 does not match the number of listings I got from GoldMine's Reports. This is the source of my confusion.

I might add that many of the listings in GoldMine's Reports were generated a long time ago in the large, old GM 6.7.

This is the basis for my question and many thanks.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Sun Jan 22, 2017 8:15 pm Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




I just want to correct one sentence I just posted where I said "In SQL Server when I do a count of Reports32, and it lists only 111 count for the 2 users."

The total count in Reports 32 was 111 and only 1 was listed for the two users.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Mon Jan 23, 2017 9:41 am Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




While the basic reports are stored in the [dbo].[REPORT32] table, it appears the the listing for the "Forecasted Sales by Users may be some place else.

Thanks for your assistance.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Mon Jan 23, 2017 10:11 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




I'm lost. I'm no longer sure if we're talking about reports or sale (CAL) records... ?

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Mon Jan 23, 2017 7:32 pm Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




A good comment and I agree. To see that list in GM, I go to
Reports
Analysis Reports
Forecasted Sales by users
In the Foercasted Sales by users, it says that the “file name is SM0FU.FP”
I looked and could not find that file name in any location in the server of SQL Server. I just do not understand what or where it is.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Mon Jan 23, 2017 7:36 pm Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




try this:

Code:
select * from report32 where repdesc like 'forecasted%'


And look at the linkeddoc field.

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Mon Jan 23, 2017 10:31 pm Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




Many thanks. I have found the reference to the field so now I a looking for that field. Still not finding it but am sure looking more. Thanks much for your helpl

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Wed Jan 25, 2017 8:49 am Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




I have found the files (Many thanks for your help) and am not trying ti figure out how to open the FP and JPG files.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Wed Jan 25, 2017 9:08 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




FP files are the GoldMine report layout files. You would use the reports center to edit them, if necessary.
JPG files are simply standard image files for use in the preview window in the reports center-- screenshots to give the user some idea of what the report might look like.

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

Deleting Reports
  ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition)
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin