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!

Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Reporting | New Thread

View: Search:

Author

Thread: SSRS 2008

Dan Carvin
Posts: 227

SSRS 2008 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 Nov 09 7:12 PM

I'm experimenting with creating SLX reports in SSRS 2008.

I can create a data source through the SLX Provider and successfully test it, but when I open the query builder it crashes VS 2008. I have created reports using Windows Authentication and with the sysdba login.

Can I create a report using the SLX Provider security enabled?

[Reply][Quote]

Dan Carvin
Posts: 227

Re: SSRS 2008 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Nov 09 12:34 PM

Update:

I have found that I can run reports through the SLX Provider if I write the SQL Select statement manually or copy & past it from some other tool. But the SSRS Query Builder crashes VS every time when launched through the Provider. So it is possible to build reports for SLX, just more cumbersome than it should be.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: SSRS 2008 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Nov 09 4:25 AM

Hi Dan, have you worked out what the difference is between the two SQL statements? Is it maybe to do with the SYSDBA prefix being added by SSRS?

[Reply][Quote]

Dan Carvin
Posts: 227

Re: SSRS 2008 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Nov 09 11:15 AM

Don't think so. When I connect through SQL Client as sysdba, the query builder builds the statement correctly and the report runs (although without SLX Team security applied). When I connect through the SLX Provider, it crashes once I click the query builder button, before I've had a chance to select the tables.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: SSRS 2008 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Nov 09 11:21 AM

Ah yes, that rings a bell, now you mention it. The query builder stuff does not seem to be supported by the SLX provider - doesn't work in 2005 either.

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 6:47:26 AM