I have in a report @StartDate and @EndDate but the thing that I want to know if it is possible to do is: if I select in @StartDate = 01/03/2011 that in @EndDate only can select the days until 01/09/2011 and the day after that can't be selected (disabled)
View 2 Replies
I need a reliable method to switch off users' access to SSRS dynamically. If you care about the reason, users are not allowed to access SSRS from home, but they are allowed access from within the factory walls.
I can generate a token or event when they arrive at work or leave, no problem, such is the sophistication of our security system.
So I can create a little .net app that pokes SSRS in some way and tells SSRS to allow that username to access reports. When the users leaves the premises, the .net app will prod SSRS to deny that username access.
I considered dynamically adding and removing usernames from the authentication section of web.config in the SSRS root dir, as in <deny=usernamelist />. But given the frequency of changes (dozens per hour at peak times), that seems too intrusive, as it probably causes the restart of the app.
I tried adding usernames to the ACL on the SSRS physical directory (Microsoft SQL ServerMSSQL.2Reporting ServicesReportServer) as deny reader, and for a few brief minutes I thought I had arrived at a solution, but for some reason SSRS decided to serve pages to denied users seemingly at random. Must be cached somewhere, although I can't for the life of me figure out why that would be happening seemingly at random.
I rather like the ACL idea from the perspective of ease of control, and if there's a simple thing i have overlooked in the way SSRS interacts with IIS and NTFS permissions, I hope someone can point it out so I can understand why the ACL seems to be mostly ignored.
There is a calendar control in asp.net
For selection mode, there is day, dayweek and dayweekmonth.
But I wanna select randomly like every monday for the selected month.. something like that.
For that, I need to do the custom method.
I am facing a different problem in using Ajax Calendar..
i.e., I am using ajax calendar properly
but whenever i am click calender image it displays ajax calender only 5 days instead of 7 days...
The preview of calendar is shown below
[URL=http://www.lazypic.com/view.php?filename=56ScreenShot.jpg][img]http://www.lazypic.com/images/56ScreenShot.jpg[/img][/URL]
I have a number of .rdl SSRS 2000 files that I want to convert to SSRS 2005 .rdl files.
I have installed BIDS 2005 and have opened the project in BIDS 2005.
When i open any file individually I get about 200 error messages.
Does anyone know what I need to do to convert the .rdl files to SSRS 2005?
I have created a drill down report in SSRS which works fine in Visual studio but when deployed and viewed using a report viewer on an asp.net web page it acts funny. It load fine the first time but as soon as i expand any of the drill downs the width of the report suddenly becomes very! lengthy and the details data disappears.
View 2 RepliesI am working with radcalender. it displays all months of the year. In any calender month it displays around 42 days. I dont want to display more than 31 days in any month.
View 1 RepliesI have a calendar for day view, month view and week view. In month view all the days in the particular month (month which user selects) will be displayed in a grid. Suppose if a month begins by wednesday/thursday then the cells of monday, tuesday remains blank. Instead I need to display last two days of previous month and similarly if the month ends on monday/tuesday then the remaining cells should be filled with starting dates of succeeding month. pls provide code for this functionality.
View 1 RepliesHow to do it. For example the calendar for march will also show days from feb and april. I dont want them to be shown. How to do. Anyone have sample code?
View 1 RepliesI need to be able to only allow certain days to be selected on a calendar extender. I have an application where I need users to run a report. The report has to be for a certain time length (2 weeks, from a sunday like 11/2/2011 to a saturday like 11/15/2011). Is there a way to accomplish this?
View 6 RepliesI want to count the number of days from selected days.I am having 2 calendar control on the form.I am selecting a dates from each calendar and passing values to textbox1 and textbox2.Suppose i am selecting 13/01/2010 from calendar1 and 18/01/2010 from calendar2. I want to count the number of days and display as 6.
View 5 Replieshow to keep selected multiple days in calendar control?
View 2 RepliesI'm trying to create a calendar control that is linked to a SQL database.
The meaning is to create an event calendar were the user can put in his info at a reservation page.
After filling everything in, the info is stored in a table on the database, the users must give in a start date of there reservation and an end date.
Now, I got everything to work so far, the calendar reads everything from the database, show it on the calendar and stuff... But only the first day.
I now what code to use for showing the first date, but I have no idea how to show the end date and all the days between.
Also the meaning is that when a person puts in a reservation, the background of the cell turns orange for "pending status", when the owner of the building agrees the color turns red for "reserved - not available"
This is the code I use for showing the dates:
[Code]....
I have a table with practice, ducode, du name, date, xxx,yyy,zzz,aaa. the record in the table are values for 3 consecutive days as queried from the main table. I need to display the table using ssrs wherein the records are seperated for the 3 days and displayed seperately but in a single table. The practice,ducode,duname is common. The xxx,yyy,zzz,aaa coloumns need to displayed for each of the particular dates. This is something similar to advanced pivots in asp. I did get the code to display the data in html format. But I need to display the table using reports or ssrs so that I can options to download the table to excel.
View 2 RepliesSo the asp:calendar control... I am able to place linkbuttons on the calendar to a specific date just fine. I'm a little lost on how to have the linkbutton stretch across multiple days. Vehicle is scheduled and now admins that use the app would like to see on a calendar the requests shown from start date to end date. Here is where I'm at.
[Code]....
The information should start on Jan 6 and end on Jan10.
I am building a report using the Matrix for the first time. It's showing duplicate days across the columns and I can't figure how to filter so that a unique day appears.
I have 2 row groups, quality_code and product_name, and 1 column group repair_dt. In the Date column I showing count of serial_id - associated with product_name this is what I am getting
12/15/2010 12/16/2010 12/17/2010 12/15/2010 12/17/2010
code A
product 1 1 2 0 0 1
I am doing a SSRS report to generate some kind of print outs.
I need to have different footers inside the whole print out.
e.g. After first several pages I need to use page number as page footer( this can be easily done). but after that i need have footers as Annex A -1, Annex A-2, or Annex B -1 , Annex C - 1, when the page is Annex A, Annex B...etc.
I'm a software manager that want to select a Reporting engine and develop international application , i want to know Dose SSRS support multi-languages environments(Special in Report Builder for end users) or not ?
View 1 RepliesI use SSRS to generate an XML file using XSLT. All is fine, except that the XML file starts with the letters 'EF BB BF' which I need to get rid of. How do I generate an XML file without it?
View 3 RepliesI have SSRS report and have customized the toolbar with textbox. User can enter the report page number and can press enter so that report will generate with report number. I have made autopostback=true to the textbox and below is my code in textbox_textchanged event
[Code]....
Suppose if I enter 2 in textbox and then press enter,it is not firing and if i press enter second time it is working. From page 2 if i enter 1 in textbox and press enter also it is not working.
I am using windows7 OS.How to install sql server reporting services.
First of all is it supported on windows 7
Can multiple SSRS share the same DB? We're getting into an SSRS customization scenario, which may adversely affect our existing SSRS features, and I wanted to see if it was possible.
View 1 RepliesI am new to SSRS report. I designed the report in BIDS and deployed it on the server. Now I have to use that report in my web application.
how do I do that using VB.NET.
The report path looks like this,
[URL]
I have SSRS (discountasp.net) and I currently display reports on my web page using Reportviewer and use .net code to authenticate them (username/password). Recently I have bought VPS (Windows Server 2008 Web Edition + .net 4.0) and would like to use SSRS the same way as above. I have never done this before so need some guidance on that just to ensure the server is still "safe". Below are some questions that I think are related but feel free to add other comments that I didn't think about.
1) Set up new user? What permissions are required?
2) Configure SSRS to for external connections?
3) Firewall?
Can we change the date format in the default parameters pane.(For eg : When we create a new parameter and select datatype as date time in report parameters.)
Default settings for this date picker control is mm/dd/yyyy.
I need to change the date to dd/mm/yyyy.
Is it possible to the change this date format to dd/mm/yyyy or any other custom format?
