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!
|
|
Report not generating
Posted: 27 Jul 07 1:05 AM
|
Hi All,
There seems to be some probblem with a particular report.
When this report is clicked in SLX client it does not throw any error but at the same time it does not work properly, opens up with blank tabs.
But if the same error is opened in SLX Architect, it opens perfectly showing the DB entries as well.
We even tried to re-release the report but still its not showing in client.
Can anyone provide any pointers to this..??
SLX v6.2.6
TIA.
Richa |
|
|
|
Re: Report not generating
Posted: 27 Jul 07 8:01 AM
|
Richa,
Who is logged in at the client? Who is logged in when in the Architect?
The provider provides security and filters data based on team membership. The possible situation you are running into is the client user does not have access to any of the data. The is especially likely if you are logging into the Architect as admin who has access to ALL data.
John G. |
|
|
|
Re: Report not generating
Posted: 27 Jul 07 8:04 AM
|
Richa,
Who is logged in at the client? Who is logged in when in the Architect?
The provider handles security and filters data based on team membership. The possible situation you are running into is the client user does not have access to any of the data in the report. The is especially likely if you are logging into the Architect as admin who has access to ALL data.
John G.
|
|
|
|
Re: Report not generating
Posted: 30 Jul 07 12:20 AM
|
Hi John,
I myself checked for this....both in the client and the Architect, with admin login....I could open the report in the Architect but not in the client. 
Richa |
|
|
|
Re: Report not generating
Posted: 01 Aug 07 2:49 PM
|
I'm in a similar situation, I can run a report in the Architect but in the client I get:
"Failed to retrieve data from the database. Details: Database Vendor Code: 33167768]"
Does anyone have any thoughts on this?
Thank you.
|
|
|
|
Re: Report not generating
Posted: 24 Sep 07 12:46 AM
|
Hi Ian.
I have this same problem as you. Do you have a resolution yet?
Regards
Ina |
|
|
|
Re: Report not generating
Posted: 24 Sep 07 9:27 AM
|
Can you confirm that the report is using OLE instead of ODBC? If it is not open the report in Crystal and click DATABASE - CONVERT DATABASE DRIVER and convert to OLEDB.
Also, open the report in Crystal and click DATABASE - VERIFY DATABASE. Then save and re-release the report in SalesLogix saving the credentials.
|
|
|
|
Re: Report not generating
Posted: 24 Sep 07 6:31 PM
|
One other "small" gotcha that's tripped up our technical support department. When you run this report in the Client, before hitting the "Preview" or "Print" buttons, ensure there is report filter set. Sometimes the client will default to "Current Record Only" and the report comes up blank.
If this really is the case, there is a simple way to fix that once and for all. Change the base table for the report (in it's properties) to not be Account, Contact, or Opportunity for the report. |
|
|
|
Re: Report not generating
Posted: 25 Sep 07 4:12 AM
|
Thanks David.
I think the issue was related to what you were saying. However, I did have the OLE DB selected. The only thing that I did not do was to check the "Integrated Security" box. Once I checked that, it worked fine. Do you know by any chance why that box need to be checked?
Thanks
Ina |
|
|
|
Re: Report not generating
Posted: 25 Sep 07 7:30 AM
|
Ina,
The "Integrated Security" has to do with what John said above where the provider handles security and filters data based on team membership.
Glad we could help arrive you to a solution!
|
|
|
|