11/25/2024 9:38:58 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
Ghost CR Templates Appearing in 'OTHER' Category
Posted: 25 Mar 08 5:13 PM
|
Hello all!
End users are currently seeing a host of old images of historic templates lodged in the 'other' category in the Report Main View (i.e., assuming the category was left blank). From Architect, these reports are not listed either in 'manage plug-ins' or 'manage reports' view. Are these remnants of someone with report generation capability who has been erased or retired from the user list? Is there any way to get at them to destroy them? Is this too many questions at once? None of these ghost reports are valuable, just old dupes of material that has since been updated by the appropriate 'Admin' logon, which are, of course, available for review, upgrade and release.
Thanks so much! |
|
|
|
Re: Ghost CR Templates Appearing in 'OTHER' Category
Posted: 02 Apr 08 10:16 AM
|
| Erik they may be appearing in the "Other" category because the report's true 'family' is not available in the report family picklist. There is some disparity in how SLX handles this in different areas. What you may want to do is look for the reports in manage plugins under a different family name - then see if that family name is in the picklist 'Report Families' under the 'plugin families' tab in manage picklists. If it is not, then add it, and you may see some of these issues clear up. |
|
|
|
Re: Ghost CR Templates Appearing in 'OTHER' Category
Posted: 03 Apr 08 1:59 PM
|
Thanks so much Matt -
alas, while I think I see what you are getting at, I could not bring it to resolution - These reports are duplicated on the client side (they appear in a category called 'Rosters' and then again in 'Other'), but only the version in Roster is current, the 'Other' is heritage (so they are independent documents)... the worst rub is that either in 'Manage Templates' or 'Manage Plug-ins' only one version is visible, the correct and most recent version. Nowhere else can I find or detect reference to the heritage versions. I also tried creating an 'Other' entry in the picklist you mentioned, but that just appeared empty in Architect and the Client (Client-side only had the 'ghost' Other still there)... So to sum, the reports that I *can* access look as though they have a valid Report Family association, and the most recent versions do appear there ('Rosters')
If you had any other ideas I'd be excited to hear!
Erik:: |
|
|
|
Re: Ghost CR Templates Appearing in 'OTHER' Category
Posted: 03 Apr 08 2:16 PM
|
if you feel comfortable working with the plugin table through SQL (always, ALWAYS backup your database before doing so) you can isolate the problem records by using the following query:
select name, displayname, family, type, basedon, version, company, companyversion, author, description, released, dev, releaseddate
from plugin
where
type = '19' and
family not in (select [text]
from picklist
where picklistid = (select a.itemid
from picklist a
where a.picklistid = 'PICKLISTLIST'
and a.[text] = 'Report Families')
)
This query will show you any report that is in a family that does not match the report families picklist. If no records show up, you can remove the 'family not in ...' clause and see all the reports. You WILL see what appear to be duplicate records (with the exception of the basedon column) don't be alarmed at this and don't remove the duplicates as the ones with a value in basedon are releases to groups, departments, users, etc. that point back to the actual plugin released.
What you would want to do is look for those report names in the plugin table that you know to be problematic. If you find them please try and post them here in the forum and we'll see if we can see what is going on (the plugin record for each troubled report) |
|
|
|
Re: Ghost CR Templates Appearing in 'OTHER' Category
Posted: 03 Apr 08 2:45 PM
|
Thanks so much Matt! If I can work up the cahones after backup, that's exactly what I was wondering, where and how to access the store of these documents themselves...
Thanks so much!
Erik:: |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|