Showing posts with label refreshed. Show all posts
Showing posts with label refreshed. Show all posts

Monday, March 26, 2012

Report not refreshed

I have created an asp.net application in which i have a textbox and botton.T

he textbox value is passed as parameter to a report and the corresponding report is generated on button click.The problem is that once i add a report to any application the same report is displayed each time i.e. the report is not updating whenever there is a change in the database values.

Iam refreshing the datasource in the original report and change is reflected there in original report but in the dotnet application always the old report is maintained......

Can anybody help me out......

I had the same problem reportviewer1.reset nd I sovled it by added a line code before refreshing the report:

reportviewer1.reset

|||

I had the same problem and I sovled it by added a line of code before refreshing the report:

reportviewer1.reset

|||

Thanx Frankmeng for your suggestion but it is not working....

It is giving me build error.

Error 1 'Microsoft.Reporting.WebForms.ReportViewer' does not contain a definition for 'Reset'
Can u help me with this?

I would also like to know whether we can set the paging property of the report so that only desired number of records are displayed in a page and the user doesn't have to scroll up and down.

Thanx.

|||

Arun:

It is sovled by added a line of code in the Button click event.

reportviewer1.localreport.refresh()

|||Thanks a lot Arun its working...Yes

Wednesday, March 7, 2012

Report interface getting refreshed

All of a sadden my report refreshes its interface every time I choose
something from dropdowns. Any reason for that?
ThanksYou must have cascading parameters (one parameter dependent on another).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:e$fMgNEkIHA.2396@.TK2MSFTNGP05.phx.gbl...
> All of a sadden my report refreshes its interface every time I choose
> something from dropdowns. Any reason for that?
> Thanks
>|||And if I do then that's how it works?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O3EI2TEkIHA.4684@.TK2MSFTNGP06.phx.gbl...
> You must have cascading parameters (one parameter dependent on another).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:e$fMgNEkIHA.2396@.TK2MSFTNGP05.phx.gbl...
>> All of a sadden my report refreshes its interface every time I choose
>> something from dropdowns. Any reason for that?
>> Thanks
>|||It's refreshing the page to update the dependent parameter. I only see this
behavior when I have dependent parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:e8n$TZEkIHA.2268@.TK2MSFTNGP02.phx.gbl...
> And if I do then that's how it works?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:O3EI2TEkIHA.4684@.TK2MSFTNGP06.phx.gbl...
>> You must have cascading parameters (one parameter dependent on another).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:e$fMgNEkIHA.2396@.TK2MSFTNGP05.phx.gbl...
>> All of a sadden my report refreshes its interface every time I choose
>> something from dropdowns. Any reason for that?
>> Thanks
>>
>

Tuesday, February 21, 2012

Report gets refreshed automatically

Hi,

I created a report using SQL 2000 Reporting Services. I have 3 input fields viz., Start Date, End Date and Configuration Item. First 2 are textboxes and the last one is a dropdown. I also have a button 'View Report' clicking which the report page will be refreshed. When I deploy the Reports in report manager, when I give the Start Date then the End date, before I could select a value from the Dropdown, the report page is getting refreshed automatically before I click View Report button. i.e., the report gets refreshed on lifting the focus from the End date textbox. Why does this happen? Note that I have not set the Auto refresh property for this report.

The most likely reason the report is being refreshed is because the "Configuration Item" parameter has a dynamic value that may depend on the values of "Start Date" and/or "End Date". The report is refreshed as soon as the value for "End Date" changes to ensure that the valid values for "Configuration Item" are accurate.

For example, RS will assume that "Configuration Item" depends on "End Date" if:

"Configuration Item" is populated from a query that uses expressions in the query, filters, calculated fields, or query parameters|||

I also faced the same problem.

In my case, by mistake I set the Report Properties " AutoRefresh " as 1 insted of 0 in properties window on right hand side

so just check whether its 1 or 0