July 24, 2012 at 1:35 am
Hi Experts,
I am using SSRS 2005 .. I prepared a report and deployed it works fine in localhost/reports..
but when i connect this report with Aspx page on reportviewer then i got below error..
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'DropDownEmp'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
I am using two query for this report
for dropdown i am using ---
dataset name is DropdownEmp
Query -- select UserID from TblMUser where UserID not in( ' --Select--', ' ALL', 'Admin') order by UserID
for select query with parameters
select UniqueIDTxtDump,SubmitDateTime,convert(varchar,RecordDate,110) as RecordDate,UserID,Client,Process,MainActivity,SubActivity,((case when len(TimeHH) = 1 then '0'+convert(varchar(2),TimeHH) else convert(varchar(2),TimeHH) end)+ ':'+(case when len(TimeMM) = 1 then '0'+convert(varchar(2),TimeMM) else convert(varchar(2),TimeMM) end)) as 'Time Taken (HH:MM)',Remarks from TblTxtDump where
(RecordDate between @StartRecordDate and @EndRecordDate) and (UserID in(@UserName))
THis is really urgent for me........
July 24, 2012 at 3:18 am
login to SSMS and connect to your SSRS server
change the properties of the server to enable remote errors
run the report and post the full remote error
July 24, 2012 at 4:04 am
You might want to check permissions on the view/sp that populates the dropdown. Does the executing user have the correct permissions to run it?
Bex
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply