I have to create a report, where I have to show the columns dynamically according to the parameters. i.e. I have a date selection criteria may 2008 to june 2008 or june 2009. Now the report will be shown by the month of different locations. Here numbers of month are changing according to the selected date. I have used matrix, could not change the column dynamically. Is there any method to achieve this?
There are 12 months in the column, but when I select a date range i.e. March, April and December of 2009 then there would be only 3 month columns. So its depends on the selected date range. Months column can be increased/decrease according to the selected date range. Since I have to show in the matrxi form because I am also selecting the location/country with date range then it will show the records by location and by selected date. I have used Sql Server procecdure where I have to pass the date range and location information then it shows the result in the following manner
State January March April
A 20 30 40
B 5 6 30
Hera state rows and columns are generated dynamically. This the report in SSRS 2005. I did not get any solution to show this type of records where columns are generated dynamically.
I got a solution by which I can hide the column in the column expression. i.e. I have selected Jul column
Select Column -> Propeties -> Visibility -> Select Expression radio button and type the following expression
However this is not the perfect solution. If I fetch records which contains Jun, Jul, Aug and write the above expression to hide the jul column then the Jul column will be hide but there would be space between the Jun and Aug. I want the space should not be there if the column does not hide. I am getting the following formate
State Jun Jul Aug
A 10 12 12
B 12 14 15
State Jun <--space--> Aug
A 10 <--space--> 12
B 12 <--space--> 15
Requirment is to use "reset" functionality without postback.
1. We can use standard reset button. It will be part of a form. It will clear the form elements just clicking it. No separate code required to clear the elements. Moreover, post back will not take place.
2. If we donot use standard "reset" button, but use HTML button for reset, then we will have to write our own code to reset. Moreover page post back will also take place. It can be done without writing code also if we user server.transfer("same page").
My requirement gets fulfilled with option 1. But issue is that I am using master(content) template in all web forms. Because of this <form> </form> is not part of aspx file. In this case, when i try to use standard reset button, its functionality does not work because this button is not under <form> </form>.
So how to use reset functionality withot writing code and without post back in my requirement.
try using AddDay function of data object. First loop from start date to end date. For each iteration call add day with value 1 and then check returned date if its week end then increment your counter variable.
i want to display the please wait message along side the page is being loaded, i.e. the message and page load should run parallel to each other.
I dont want to show message first and then load the page.