| Author |
 Topic  |
|
|
jknowlton
USA
6 Posts |
 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 |
|
|
admin
1643 Posts |
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] |
 |
|
| |
Topic |
|
|
|
Report Portal
sort bug for SQL Report based on stored procs
