ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
jknowlton	Posted - 02/16/2006 : 15:32:36 When you try and click a header to autosort on a sql report based off a stored procedure, it produces this error: Incorrect syntax near the keyword 'order'.; SQL: rst_DailyReport_Prd 0,1,'1/1/2006' order by 4 SQL: rst_DailyReport_Prd 0,1,'1/1/2006' order by 4 I suggest that the software automatically disable the autosort functionality when the report is based off of stored procedure. Thanks, Jeff
1 L A T E S T R E P L I E S (Newest First)
admin	Posted - 02/20/2006 : 12:12:15 Thanks for reporting this problem. A fix to it should be included in the next build. Meanwhile to use a temp table like so: [code] CREATE TABLE #temp ( ProductName varchar(100), UnitPrice money, Quantity int, Discount money, ExtendedPrice money ) insert into #temp exec CustOrdersDetail '::1' select * from #temp [/code]

ReportPortal