.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

HistoryID pertaining to changing report history

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :ASP.Net

I am trying to change the historical data in an apartment vacancy report. 

Below you will see the actual report [exported as PDF]. Here you will see the form as users enter report requests:

Here is the report [exported to PDF] - the red box indicates what I would like to change.

Currently it looks like the History is reported as previous quarter (March '10), quarter before that (Dec '09), etc... going four or five quarters back. I need help changing the History reported [and it's respective data] to report: Six (6) months ago (ie Dec '09 first), 1 yr ago (ie June '09), 2 years ago (ie June '08) and 3 years ago (ie June '07). The related information I found as it correlates to this issue is as follows:


As you can see under Year built is the expression


I do not understand how I can change that expression to reflect the correct historical data in our database. If that is not the file you need to help me, perhaps the XML file is (Microsoft.ReportViewer.WebForms.xml). The only reference to "History" I found was this:<

View Complete Post

More Related Resource Links

Backfilling Report History

Hi Here is the problem, I have some reports that get store in the history of SSRS every day that works fine, now let's say that my backend system is down during the time the history schedule runs then my report is not generated and don't store in History becuase the data sources throw an error becuase they could not connect to my backend, that's ok too. Now by backend connections is restore and online there is any way that I can run my report and do a manual snapshot, then change the time and place the report snaphot at the right time in the history tables. for example: my backend is in a remote location and some times the connection is lost even for a couple of dates, can I refill the SSRS when the backend is online? I mean run the report with right parameters so I get as it suppose to be  1 or 2 dates ago and then do the manual snapshot then move the report to the right place in History? I have been thinking in a couple of options 1.- A store procedure that I can pass the report name and the datetime when I run the report and the datetime when I want the report to be place in history, then the store procesure will move my latest report to the right place in History, it that posible? could you please tell me or pointme in the right direction? 2.- same as before but using the WebServices and a .Net Application. I don't know if just changing the

How to compare ssrs snapshots in report history

Is there any possibility to create a report that compares snapshots of a different report? I have created scheduled snapshots of an SSRS report in SharePoint to display monthly financial data. Now I would like to create a different report that compares these snapshots. The idea is that I can end up with a report that shows what has changed between the snapshots of the last two months. Does anybody know how to do this? I have considered using subscriptions instead of snapshots, but still cannot come up with a solution that is entirely automated.

Report Parameter value not changing


I have a report (that I will use as a sub report later) with a parameter declared like this:

Name: MyID

Prompt: My ID

Data Type: Integer

Select parameter visibility: Hidden

I then insert a sub report onto my report and point it to my 'sub' report above. My question is, how do I setup a parameter in the main report that passes my ID form the report to the MyID parameter of the sub report?

I have tried setting up the report parameter like this:

Name: LinkToSubReport

Data Type: Integer

Select Parameter Visibility: Internal

Now, in the Availbale Values and Default Values tabs, I have set teh Dataset to my dataset, and the value fields to my ID field, but when I run the report and flick through the pages of result, my sub report values do not change.

Changing the report width.


Hi All,

I have an sql server 2008 report with two tablixes: small one and a very wide one. The report has a Yes/No parameter which I use to show/hide appropriate tablix.

Is there way to shrink the report width when a user chooses to see small tablix? 


Changing the Title of Report in SSRS 2008



I have deployed my reports in SSRS 2008. Everything is running fine now, but i am facing a little issue with all the reports. Whenever i access any report from the application, the report name on the top tab bar of the new opened window comes as 

"Report Viewer - Windows Internet Explorer provided by Softpedia"

which should actually be the name of the report which is getting generated like "rptCustomerDetails"

Can somebody tell me how can i make it appear as my report name?

I would be very grateful if someone can respond and help me with this..



Changing the graphics on the home page of a SharePoint site

When you create a site in Microsoft Windows SharePoint Services by using the default Team Site template, the home page includes two default graphics. A Windows SharePoint Services graphic appears in the body of the page, and a picture of a house in a circle appears near the site title. You can change these graphics to customize your site. Changing the smaller graphic requires a Windows SharePoint Services compatible Web page editor

Convert English to Arabic number without changing any regional settings in .net

Well, most applications that I worked with was multilingual that supports English UI and Arabic UI.

And one of the major issue that we have faced is displaying Arabic numbers without the need of changing the regional settings of the PC.

So the code below will help you to display Arabic number without changing any regional settings.

Alternating row background for first column of a report


is there a way to make the first column of a report use the an alternating background color? 

I have the background color set for the entire row however it does not work for the first column if the color is set to an expression.  If I just set it to a color i.e. red it works just fine. If I insert a dummy column to the left it works just fine (but the dummy column does not work, presumably because it is first??).

In the file below only the textbox for part number does not show an alternating background.  All others work correctly.

                    <Textbox Name="PartNumber">

Problem with changing language using culture info


I'm using the following msdn article to use different languages in my web application:


I'm following the instructions step by step in VS 2010, and it creates the resource files exactly how it's supposed to. 

However, when I run the program it just doesn't apply it. I don't see the different values from the resource file. 

If I leave my resource file name as sample.aspx.resx, it works. But when I change it to sample.aspx.en-us.resx, it doesn't work. I'm supplying culture from the aspx page's Culter and UICulture properties. I'm being very careful in choosing the correct file name, as that could be the issue,  but it just doesn't work. I also tried changing the culture in the backend code this way:

Changing direction of pop-ups/alerts in RTL


Hello All,

I am not able to change the direction of popups/Alerts in Arabic culture which should be RTL direction.

Rest of my application is changed in above culture, only problem is with popups and alerts.

Thanks in advance.

Changing from Local to WCF


I've been handed an application thats connection string implies a local host connection.

I want to make this connection a remote connection, to a database located on a Server.  I want the client and server to be able to communicate with one another remotely, instead of a local connection.

How does one create the Data Service, and establish end points to Server and Client?  Is it as simple as creating a contract (which I have limited knowledge on constructing), between the two locations, setting up the dataservice, security, and ratifying the 'connetions'?

A smidge of insight, please ;-)

How to use report viewer 2010 in VS 2008


I downloaded report viewer 2010 from here


Now I want to actually use it in a website.  How do I do that?  Do I have to modify some part of web.config?  Specifically, what do I need to change?


populate report viewer by code


Hi all

I have a button "Show Report" to show some data from table

what I should write under this button to populate the reports ?

A connection could not be made to the report server http://localhost/ReportServer.



  • I created a Report using Business Intelligence Studio. Its working working well, i can able to view records. But when i try to deploy the report an error occurs specifying that "A connection could not be made to the report server http://localhost/ReportServer. (Microsoft Report Designer)".
  • I open the IIS 7 and find out virtual directories "Reports" and "ReportServer" are available.
  • I check on the browser and type "http://localhost/reports".  I find the browser direct to this url: http://localhost/reports/Pages/Folder.aspx and find error specifying the following one:

         Error:The report server is not responding. Verify that the report server is running and can be accessed from this computer.

  • when i type http://localhost/reportmanager, i found the error:

    HTTP Error 404.0 - Not Found

    The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.


Stop Sorting Cross Tab Report Header


Dear, I want to stop sorting in cross tab report header. And also want to sort in specific order. How can i do that? Please help me. Its urgent


May i use the collapse and expand feature (like tree menu) in Report ?


HI all,

May i use the collapse and expand feature (like tree menu) at Report iam using the Report viewer  Control for displaying the Report on my Asp.net Page .


I have number records and each record have detail as i clicked or expand the record then details will be shown is it possible with report viewer control 
If any one have experince before please share the ideas.


Best Regards

Cannot Display Image in Report


 I have a report using an image control that needs to display an image inside subfolder "Images\InstitutionLogos\".

On properties of image control i have the following properties set:

MIMEType= "image/png"

Source      = Database

Value        ="\Images\InstitutionLogos\" +Fields!InstitutionID.Value+".png"

Inside subfolder "Images\InstitutionLogos\" each image is named with a number which represents Fields!InstitutionID.,(ex, 1.png, 2.png, 10.png)

However, when i run the report the image just displays an X, what am i missing?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend