Showing posts with label upload. Show all posts
Showing posts with label upload. Show all posts

Friday, March 30, 2012

Report works fine on VS.NET 2003, get error when uploaded

Hello,

I created a report and use stored procedure to retrieve data. The report works perfect on VS.NET 2003 IDE. But when I upload the .rdl file to the report server, it doesn't work. The error msg I got is:

Reporting Services Error

An error has occurred during report processing. (rsProcessingAborted)Get Online HelpQuery execution failed for data set 'dsTransTime'. (rsErrorExecutingCommand)Get Online HelpProcedure 'usp_RPT_Procedure_Name' expects parameter '@.Parameter1', which was not supplied.
Anyone know the problem?
Thanks,Finally, I make it works. But I still don't know how I made it.
I cannot find a similiar errors from google. So everything I did is based on guess. Becasuse the error msg shows the report cannot take the parameter, I removed the parameter and re-created it again. Also, I use refresh button on the Data view to refresh the dataset.

Sometime I feel waired about Reporting services.

Wednesday, March 21, 2012

Report updates not Saving

Hi,

I have a problem when uploading changes/ new reports to the report manager. I can get to the upload file screen, I can even browse to the .rdl file that I want to upload, but then the "OK" button seems to be disabled. I cannot seem to get the Report manager to accept any new reports or changes to the old ones.

I have System Administrator access and everything was working perfectly untill about a week or two ago, no changes were made that I can see.

Please help!

See this tread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=173608&SiteID=1

Report updates not Saving

Hi,

I have a problem when uploading changes/ new reports to the report manager. I can get to the upload file screen, I can even browse to the .rdl file that I want to upload, but then the "OK" button seems to be disabled. I cannot seem to get the Report manager to accept any new reports or changes to the old ones.

I have System Administrator access and everything was working perfectly untill about a week or two ago, no changes were made that I can see.

Please help!

See this tread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=173608&SiteID=1

Report Title

hi, We have a lot of reports done in Reporting services. Now here is the
thing. When you upload a report it gives the report the name of the rdl
file. ex. HoursbyClient.rdl the title will be HoursbyClient. We change
this in RS to Hours by Client. Now if for some reason the server crashes
and we have to re upload those reports is there a way to perserve the name
we gave the report So we don't have to go and re type the names of hundreds
of reports?Patrick Hill wrote:
> hi, We have a lot of reports done in Reporting services. Now here is the
> thing. When you upload a report it gives the report the name of the rdl
> file. ex. HoursbyClient.rdl the title will be HoursbyClient. We change
> this in RS to Hours by Client. Now if for some reason the server crashes
> and we have to re upload those reports is there a way to perserve the name
> we gave the report So we don't have to go and re type the names of hundreds
> of reports?
Well, two obvious solutions:
1) give the reports the right name when you create them in Visual
Studio so you don't have to rename them. Why bother with two sets of
names?
2) backup the reports database, and restore the backup as neededsql