| Deleting Reports | |
Posted: Fri Jan 20, 2017 4:53 pm |
Points: 0 |
|
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 |
|
|
|
|
Posted: Sat Jan 21, 2017 1:41 am |
Points: 0 |
|
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. |
|
|
|
|
| | |
Posted: Sun Jan 22, 2017 8:01 pm |
Points: 0 |
|
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. |
|
|
|
|
| | |
Posted: Sun Jan 22, 2017 8:15 pm |
Points: 0 |
|
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. |
|
|
|
|
Posted: Mon Jan 23, 2017 9:41 am |
Points: 0 |
|
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. |
|
|
|
|
Posted: Mon Jan 23, 2017 10:11 am |
Points: 0 |
|
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... ? |
|
|
|
|
Posted: Mon Jan 23, 2017 7:32 pm |
Points: 0 |
|
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. |
|
|
|
|
Posted: Mon Jan 23, 2017 7:36 pm |
Points: 0 |
|
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. |
|
|
|
|
Posted: Mon Jan 23, 2017 10:31 pm |
Points: 0 |
|
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 |
|
|
|
|
Posted: Wed Jan 25, 2017 8:49 am |
Points: 0 |
|
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. |
|
|
|
|
Posted: Wed Jan 25, 2017 9:08 am |
Points: 0 |
|
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. |
|
|
|
|
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
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|