11/25/2024 8:38:57 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.
|
|
|
|
Just migrated to 7.01, Updated reports to X1 Release 2. When running report based off groups SLX says "Invalid Crystal Query String" and display all records...
Posted: 04 May 07 11:06 AM
|
fiogf49gjkf0d Hi All,
We Just migrated to 7.01, Updated reports to X1 Release 2. When we run a report based off a custom group or even just the "All Contacts" group, the SalesLogix Report Manager says: "Invalid Crystal Query String" and then displays all records instead of the date range I need based on the group... Like I mentioned before, even "All Contacts" that SLX came with displays the same message when using that group. Using [All Records] and [Current Record] work fine on all reports, but [current group] does not work correctly. I have even tried the Edit button when using [All Records] and Matching By the group I select with this message on any group select: 'This Filter Contains a group that you do not have access to'. I'm logged in as the Admin so I'm a little confused as to why I wouldn't have access to a group I created. I've even tried to re-create the group and report and also release both to everyone just as a test.
Any clue as to why this is happening?
Thanks in advance, -RJ |
|
|
| |
| |
| |
| |
|
Re: Just migrated to 7.01, Updated reports to X1 Release 2. When running report based off groups SLX says "Invalid Crystal Query String" and display all records...
Posted: 16 May 07 8:17 AM
|
fiogf49gjkf0d Many of my custom reports required I make a hard copy, delete the current entry and re-add the report to SLX.
Sorry, I've been knee deep in a project here.
When we upgraded I did that very thing, saved the custom reports from the Architect to a folder. After the upgrade, I modified the custom reports outside of SalesLogix using Crystal Reports XI R2 (the SLX OEM version). After I was satisfied the reports were working fine outside of SLX, I deleted and added the reports back into SLX.
Something else we do here... the reports are under source control using Visual SourceSafe. This way we have the ability to go back to a previous report version if necessary. We also have any views or stored procedures created for reports in VSS as well.
John G.
|
|
|
| |
|
Re: Just migrated to 7.01, Updated reports to X1 Release 2. When running report based off groups SLX says "Invalid Crystal Query String" and display all records...
Posted: 09 Jan 08 10:00 AM
|
This is the SQL as reported by the SLX Profiler by the way (note the changes to my original SQL, which are the link to SECRIGHTS, the _ after CONTACTS and the ACCESSID on the contact table)
SELECT DISTINCT
A1.ACCOUNTID AccountID
, A1.ACCOUNT Account
, A1.TYPE AccountType
, A3.RESPONSIBLE_TEAM ResponsibleTeam
, A2.SUBSCRIPTION_FEE SubFee
, COUNT(DISTINCT CASE Web.RESOURCE_TYPE
WHEN 'hr' THEN CONVERT(varchar(10),Web.CREATEDATE,20)+WEB.CONTACTID
ELSE NULL
END) HRCounter
, COUNT(DISTINCT CASE Web.RESOURCE_TYPE
WHEN 'docman' THEN CONVERT(varchar(10),Web.CREATEDATE,20)+WEB.CONTACTID+CONVERT(varchar,WEB.RESOURCE_ID)
ELSE NULL
END) DocManCounter
, COUNT(DISTINCT Escrow.PY3_SERVICESID) EscrowCounter
, COUNT(DISTINCT Room.PY3_SERVICESID) RoomCounter
FROM ACCOUNT A1 INNER JOIN SECRIGHTS S_AA ON (S_AA.ACCESSID = 'U6UJ9A000008' AND A1.SECCODEID = S_AA.SECCODEID )
LEFT JOIN PY3_ACCOUNT A2 ON (A1.ACCOUNTID=A2.ACCOUNTID)
LEFT JOIN PY3_COMPANY_INFO A3 ON (A1.ACCOUNTID=A3.ACCOUNTID)
LEFT JOIN CONTACT_ C1 ON (A1.ACCOUNTID=C1.ACCOUNTID) AND C1.ACCESSID_='U6UJ9A000008'
LEFT JOIN PY3_SERVICES Escrow ON (C1.CONTACTID=Escrow.CONTACTID AND Escrow.CATEGORY = 'escrow active' AND Escrow.CONTACT_ROLE = 'escrow owner')
LEFT JOIN PY3_SERVICES Room ON (C1.CONTACTID=Room.CONTACTID AND Room.SERVICE_TYPE = 'Room Booking' AND Room.STARTDATE BETWEEN DATEADD(year, -1, CONVERT(varchar(7), GETDATE(), 20)+'-01 00:00:00') AND DATEADD(day, -1, CONVERT(varchar(7), GETDATE(), 20)+'-01 23:59:59'))
LEFT JOIN WEBHISTORY Web ON (A1.ACCOUNTID=Web.ACCOUNTID AND Web.CREATEDATE BETWEEN DATEADD(year, -1, CONVERT(varchar(7), GETDATE(), 20)+'-01 00:00:00') AND DATEADD(day, -1, CONVERT(varchar(7), GETDATE(), 20)+'-01 23:59:59'))
GROUP BY
A1.ACCOUNTID
, A1.ACCOUNT
, A1.TYPE
, A3.RESPONSIBLE_TEAM
, A2.SUBSCRIPTION_FEE
ORDER BY A1.ACCOUNT |
|
|
| |
| |
| |
|
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!
|
|
|
|
|
|
|
|