Report does not render

When I go out to Reports I can see the reports but when you click on
them all yo get is the properties tab and they will not render. If I
go out the the Reportsserver they will run fine. Is there a reason
why they will not give me the option to render?Just two things, check for the access from the RM, and clear the cache and
then try deploy and run the report. I faced the same before.
Amarnath, MCTS.
"captkirkrules" wrote:
> When I go out to Reports I can see the reports but when you click on
> them all yo get is the properties tab and they will not render. If I
> go out the the Reportsserver they will run fine. Is there a reason
> why they will not give me the option to render?
>

Report Continually Refreshing

Hi All,

I had an interesting problem come up today. I have a report that when you preview on vs or click view report on the report server, the report continually refreshes itself. I cannot see that I have written anything different in this report than any other report.

I saw one other append here on a continually refreshing report but that was linked to a document map and this report has not document map.

Has anyone seen this problem of a continually refreshing report?

It's not a big deal as I figure I will just have to write it from scratch again, but I am interested to see if I can stop it before I re-write it.

Thanks in Advance

Peter

Peter, there is option in Report Properties that allows you to set a refresh rate. Click in the body of your report layout and then select Report and then Report Properties from the toolbar. At the bottom of the General tab you should see the option to check AutoRefresh and a number of seconds. Unselect this and the report should stop refreshing.

|||

Hi Cuck,

thanks very much for that...I have no idea how the refresh rate got set to 1 second but that was the problem.

I read about that option when I first started with Report Services but forgot it was there.

Thanks Again.

Peter

Report Continually Refreshing

Hi All,

I had an interesting problem come up today. I have a report that when you preview on vs or click view report on the report server, the report continually refreshes itself. I cannot see that I have written anything different in this report than any other report.

I saw one other append here on a continually refreshing report but that was linked to a document map and this report has not document map.

Has anyone seen this problem of a continually refreshing report?

It's not a big deal as I figure I will just have to write it from scratch again, but I am interested to see if I can stop it before I re-write it.

Thanks in Advance

Peter

Peter, there is option in Report Properties that allows you to set a refresh rate. Click in the body of your report layout and then select Report and then Report Properties from the toolbar. At the bottom of the General tab you should see the option to check AutoRefresh and a number of seconds. Unselect this and the report should stop refreshing.

|||

Hi Cuck,

thanks very much for that...I have no idea how the refresh rate got set to 1 second but that was the problem.

I read about that option when I first started with Report Services but forgot it was there.

Thanks Again.

Peter

sql

Report ciew correct but print no

Hi,
first
Program language visual basic 6 +SP5
Crystal Report 8.5
SQL Server2000

Day2(Namr of report)

the problem
i use these code so when any one click print in report view he can select the printer

UseDefault = False
Day2.PrinterSetup Me.hwnd
Day2.PrintOut True

first time view report its print ok but if i open report again with differnet parameters its showing correct data in report view but after i click print and choose printer it still print the first report

why these happen?I've seen this problem before, a few years ago.
I don't work at the same place now, so I can't go back into SourceSafe and check the code, but I seem to recall we had this problem due to originally not properly disposing of the report object.
If you have a report object open (instantiated) and you then reset some parameters, it may not function properly unless you dispose of the object when you next start a "view" process.
So, when you click on a button to regenerate your view of the report, make sure you do something like this;

set objReport = Nothing
set objParams = Nothing

and then provide code to recreate the objects, which should flush the report object and all objects is has created, and then create a clean new object so you can set parameters.

Davesql

report bulder error(urgent)

report builder not launched once i click the ssrs 2005 report builder. what is the reason?
think you might need to be a bit more descriptive than this!

And maybe posting it in the reporting services forum, probably more experts aware of your problem in that forum.

Cheers

Matt

Report Builder will not launch

I am having problems launching the Report Builder. I click the button and nothing happens. I did see the other suggestions about re-installing the .NET 2.0 Framework but that did not help. I tried to launch it directly from the address bar and I am getting the same reponse as when I click on the Report Builder button. I can access the Report Builder from other machines and it works fine. I did just recently install IE 7 and I tried to uninstall it and go back to IE 6 but I got the same results.

Any help would be appreciated.

Thanks Tim

Does navigating to http://localhost/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application work? Try adding localhost to trusted sites.|||

I tried using this link http://localhost/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application and adding it to trusted sites and it did not work. Maybe I have some corrupted or missing files on my machine. Does anyone know what files I could possibly delete to make Reporting Services think I have never launched the Report Builder and have it re-update my machine.

Tim

Report Builder Question

Please help!!!!

We have recently implemented an SQL Server 2005 and when i click on the report builder button (reporting services) for the user i am getting the message "Application Download did not succeed. Check your network connection or contact your system administrator or Network Service Provider"

This is actually performed while the user has administrator privledges.

If someone has this problem or a solution, could you please post.

Thanks

This sounds like at authentication problem. If the logged-in user's default Windows credentials are not appropriate or sufficient for authenticating to the report server, then ClickOnce cannot download the application. In these cases (i.e. when you are not using Windows Auth), you need to go into IIS and allow anonymous access to the ReportBuilder virtual folder.

Hope that helps.

sql

Report Builder Error

When I create a report using Report Builder I receive the following error when I click Run Report. Any help would be appreciated. (I do not have a data source named datasource1!!!?)

w3wp!webserver!c!07/10/2006-10:30:39:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'dataSource1'. > System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

dataSource1 is the default datasource for the model.

I am assuming you are trying to run IIS without authentication. Do you have to run it that way or can you turn it on? From everything I read (and opinions will differ here) it seems that RS really wants to have authentication. Without it, how will you control who can deploy a model to your server?

Once you have authentication fixed, you can setup an impersonated user to access the database. Letting 'NT AUTHORITY\ANONYMOUS LOGON' access your SQL Server is a really bad idea.

R

|||Anonymous Access is disabled in IIS on the Report Server. (Integrated Windows Authentication is checked). That is why I cannot figure out why the Anonymous Logon account is attemtping to access the database?|||My problem was related to the Report Builder Model's Data Source. I changed the authentication method to SQL Server authentication and voila! It worked.|||Has anyone gotten the Report Builder to work with Integrated Security (given this is Microsoft's preferred authentication method)?

Report Builder Error

When I create a report using Report Builder I receive the following error when I click Run Report. Any help would be appreciated. (I do not have a data source named datasource1!!!?)

w3wp!webserver!c!07/10/2006-10:30:39:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'dataSource1'. > System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

dataSource1 is the default datasource for the model.

I am assuming you are trying to run IIS without authentication. Do you have to run it that way or can you turn it on? From everything I read (and opinions will differ here) it seems that RS really wants to have authentication. Without it, how will you control who can deploy a model to your server?

Once you have authentication fixed, you can setup an impersonated user to access the database. Letting 'NT AUTHORITY\ANONYMOUS LOGON' access your SQL Server is a really bad idea.

R

|||Anonymous Access is disabled in IIS on the Report Server. (Integrated Windows Authentication is checked). That is why I cannot figure out why the Anonymous Logon account is attemtping to access the database?|||My problem was related to the Report Builder Model's Data Source. I changed the authentication method to SQL Server authentication and voila! It worked.|||Has anyone gotten the Report Builder to work with Integrated Security (given this is Microsoft's preferred authentication method)?