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.
|
|
|
|
Custom Table Data Missing in Crystal Reports
Posted: 02 Aug 07 2:55 PM
|
I have a custom table that is linked to the SLX Opportunity table via the OpportunityID field. When I include data from this table on a Crystal Report, I can only see the custom data when I'm logged in as Admin. When I log in as a non-Admin user, I see the standard SLX data items, but the custom fields are empty.
This same phenomenon occurs within Crystal Reports itself as well. When I open the report directly in Crystal and log into the SLX database as Admin, I see the custom data on the report. When I log in as non-Admin, the custom data is missing.
Interestingly enough, that same custom data IS visible and accessible on my custom forms in SLX even when I am a non-Admin user.
I've tried changing permissions to the custom table within SQL Server, but nothing seems to change.
HELP!!!!!!!!! |
|
|
|
Re: Custom Table Data Missing in Crystal Reports
Posted: 03 Aug 07 8:19 PM
|
What's the structure of the Custom table? Do you by any chance have a field called "SECCODEID" on it?
If you are running SLX 6.2 SP3 and higher you can run the SLX Profiler while you open the report as a user other than Admin. It will show you how SLX is building the SQL Statement and that should clue you why the Custom Data isn't showing on the report. |
|
|
|
Re: Custom Table Data Missing in Crystal Reports
Posted: 06 Aug 07 3:58 PM
|
Raul,
Bulls Eye - your question hit the target! I found that my primary custom table did have a field called SECCODEID, and it was empty. Once I populated that field with the same data that existed in the Opportunitiy table, my reports worked properly!
Thanks!!!
Ron |
|
|
|
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!
|
|
|
|
|
|
|
|