Hello. Is there any way to stop the web page from refreshing when selecting a date from the calendar control in SSRS 2005? I've done some digging around, and the only 'fix' found so far is to set the default date values from a dataset; which I've done, but Im still seeing the same results. I have a Start and End date parameter, both defined as datetime parameters, neither have any dependencies on any other report parameters, no cascading between any parameters in the report....nothing; as generic as it comes. I see there is an onclick Javascript event firing everytime a date is selected from this control. Is this what is causing the page refresh? Is there no way to turn this behavior off?
We have developed several reports using VS 2005 and deployed them to our SQL 2005 reporting server. As most of our reports use date parameters we would like to incorporate a calendar control to allow users to select their date range as opposed to typing them in. I have done some reseach online but can only find vague references on how to do this. Has anyone out there been able to successfully deploy a calendar control onto an SQL report? Thanks!
I have 3 parameters in the report. When user selects 1st one from dataset, one of the fields gives me object creation date. Calendar control is supposed to be filtered to allow users select the dates greater than selected one.
How can I filter (disable dates in) calendar control?
The Calendar control that is used to select dates on a parameterized report that runs on a report server has been disabled for Safari. Users must type the dates that they want to use. http://technet.microsoft.com/en-us/library/ms156511.aspx
Does anyone know the reason why this was disabled? Will/Can it be enabled? I have clients that desire this functionality. How do I "Make a Suggestion" for the next release?
Hi,I m trying to implement a calendar, where you can select certain dates and view list of events for that day. The list is generated from database. I found a script on the web that is quite similar to what i want to achieve. I tried to run this script, however I get an exeption saying:An error has occurred while establishing a connection to the server. .... error: 40 - Could not open a connection to SQL Server)This is the code:SqlConnection mycn; SqlDataAdapter myda; DataSet ds = new DataSet(); DataSet dsSelDate; String strConn; private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here strConn = "Data Source=localhost;Initial Catalog=pubs"; mycn = new SqlConnection(strConn); myda = new SqlDataAdapter("Select * FROM EventsTable", mycn); myda.Fill(ds, "Table"); //This where I get the exeption } protected void CalendarDRender(object sender, System.Web.UI.WebControls.DayRenderEventArgs e) { // If the month is CurrentMonth if (!e.Day.IsOtherMonth) { foreach (DataRow dr in ds.Tables[0].Rows) { if ((dr["EventDate"].ToString() != DBNull.Value.ToString())) { DateTime dtEvent = (DateTime)dr["EventDate"]; if (dtEvent.Equals(e.Day.Date)) { e.Cell.BackColor = System.Drawing.Color.PaleVioletRed; } } } } //If the month is not CurrentMonth then hide the Dates else { e.Cell.Text = ""; } } private void Calendar1_SelectionChanged(object sender, System.EventArgs e) { myda = new SqlDataAdapter("Select * from EventsTable where EventDate='" + Calendar1.SelectedDate.ToString() + "'", mycn); dsSelDate = new DataSet(); myda.Fill(dsSelDate, "AllTables"); if (dsSelDate.Tables[0].Rows.Count == 0) { DataGrid1.Visible = false; } else { DataGrid1.Visible = true; DataGrid1.DataSource = dsSelDate; DataGrid1.DataBind(); } } Can some one tell me what is wrong with the code.Thank You WATCH THIS SPACE
I'm running SSRS reports on my local server - having deployed them locally. The calendar control is rendering dates in US format, i.e. 03/31/2008 and I need the British format of 31/03/2008.
The weird thing is that when I access the reports using the link:
produces the US format. My Regional setting is using English UK and the server is British English. What on earth is going on here? By the way cbada00272 is synonymous with localhost.
Inside my SQL 2005 database I have a SmallDateTime with the layout "mm/dd/yyyy hh:mm:ss AM/PM" and then on a selected date of a calendar control it returns the date with 12:00:00 AM which obviously doesn't match with my database's time.
So, I'm looking for a way to drop the time off completely (for the query purpose) the database date when running a select statement. I don't want to touch SQL table data by modifying it, I just want to be able to query sql table using calendar control. Does anyone now how to accomplish this? Thank you in advance. - Nietzky
I'm creating a report with a Datetime parameter. There's no available values, so the calendar control comes out automatically when I run/preview the report. Now, when I select the date in my calendar control, say for example I select 2/5/07 (2nd of May) and run the report, it gives me data from 5th of Feb. Can anyone help me with this date format problem ???
Not sure if it's related to my problem, I did edit the language tag in the XML source code of my report to have en-AU so that the dates field is showing in the correct dd/mm/yyyy format.
I defined my input parameter as date/time but it doesn't have a time picker where we can accept user input.
The calendar is great but time picker is missing.
Is there any add-in or tweaks I can use to get that feature ?
The alternative solution which uses drop down with some preset values are not feasible for me. All I need is just the time picker similar to adjust time in Windows.
I have created an ASP.NET website with a ReportViewer on. The report renders fine, but when I change one of the parameters (manually), the report seems to invalidate itself and a blank while area is drawn. I would like the same behaviour as in the WinForms variant, where rhe rendered report remains the same until the 'View Report' button is pressed.
I am trying to find a way to implement a page refresh using an SQL Server procedure for an HTML Page. The user will indicate the time for refresh and this would be genereated using the stored procedure..any ideas?????
I have a problem with the parameters in SSRS2005. In fact I have for example a parameter month on a MDX request (See below). When I change the value in the listbox, Reporting services post the page and I am waiting 3s before to click on "view report" Do you have an idea why this post is called ? For me there is no reason !!!
WITH
MEMBER [Measures].[ParameterCaption] AS '[DIM CALENDRIER].[ANNEE SCOL - MOIS - JOUR].CURRENTMEMBER.MEMBER_CAPTION'
MEMBER [Measures].[ParameterValue] AS '[DIM CALENDRIER].[ANNEE SCOL - MOIS - JOUR].CURRENTMEMBER.UNIQUENAME'
MEMBER [Measures].[ParameterLevel] AS '[DIM CALENDRIER].[ANNEE SCOL - MOIS - JOUR].CURRENTMEMBER.LEVEL.ORDINAL'
I have a table which gets updated roughly every 6 seconds with data. I have setup an aspx page with a datagrid to meta tag refresh every 3 seconds.
Because the data sometimes stops for a couple of minutes or even hours, I was thinking of a way to update/refresh the aspx page only when the table data gets entered ( to stop page flickering every 3 seconds).
I was thinking about a stored procedure and using an on update procedure.
Does anyone have any preffered methods or suggestions on the best way to accomplish this task.
I have added a page refresh in combination with 'Command Notification' to ensure that my data is fresh,( it is updated on the sql server database approx. every 5 mins). However, I also allow filtering on the table contents and every time I refresh the filtering is lost. Is it possible to maintain the filtering through the refresh? <meta http-equiv="refresh" content="30"/>..<asp:SqlDataSource ID="SqlDataSource1" runat="server" ..SelectCommand="SELECT ... EnableCaching="true" CacheDuration="Infinite" CacheExpirationPolicy="Absolute" SqlCacheDependency="CommandNotification" >
I'm still quite a beginner with the Report Designer and now I have faced a problem. My goal is to make a reports refresh each time it is loaded. I know that this can be done by using rs:clearsession = true-method but in order this to work, it should be added to each link. There are a lots of links in the reports we are using and therefore it would be more practical to find another way to refresh the report on page load. Is there any way to do this with some kind of code attached to each report? I'm using Visual Studio 2003 and my Reporting services 2000.
1. Create a new .aspx page and add this inside the form tag: <div> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox> <asp:Button ID="Button1" runat="server" Text="Button" /> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [Comments]" InsertCommand="INSERT INTO Comments(CommentAuthor, CommentText) VALUES (@auth, @text)"> <InsertParameters> <asp:FormParameter FormField="TextBox1" Name="auth" /> <asp:FormParameter FormField="TextBox2" Name="text" /> </InsertParameters> </asp:SqlDataSource> </div>2. Add the event handler for the button in code behind: Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Me.SqlDataSource1.Insert() End Sub3. Run the page, enter some text into the textboxes and hit the button. GREAT! The data was successfully inserted into the database.Now, let's try the exact same thing, but this time lets create a Master Page first. So:1. Create a new master page.2. Create a new .aspx page, check the 'select master page' checkbox and then select the newly created master page.3. Add the exact same as above in between the asp:Content begin and end tags: <div> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox> <asp:Button ID="Button1" runat="server" Text="Button" /> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [Comments]" InsertCommand="INSERT INTO Comments(CommentAuthor, CommentText) VALUES (@auth, @text)"> <InsertParameters> <asp:FormParameter FormField="TextBox1" Name="auth" /> <asp:FormParameter FormField="TextBox2" Name="text" /> </InsertParameters> </asp:SqlDataSource> </div>4. Add the event handler for the button in code behind. Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Me.SqlDataSource1.Insert() End Sub5. Run the page, enter some text into the textboxes and hit the button. WHOOT!? This time it doesn't work and the following error appears:Cannot insert the value NULL into column 'CommentAuthor', table 'C:DOCUMENTS AND SETTINGSSONYMY DOCUMENTSVISUAL STUDIO 2005WEBSITESCOMMENTSAPP_DATACOMMENTS_DB.MDF.dbo.Comments'; column does not allow nulls. INSERT fails.The statement has been terminated. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'CommentAuthor', table 'C:DOCUMENTS AND SETTINGSSONYMY DOCUMENTSVISUAL STUDIO 2005WEBSITESCOMMENTSAPP_DATACOMMENTS_DB.MDF.dbo.Comments'; column does not allow nulls. INSERT fails.The statement has been terminated.Source Error: Line 4: Line 5: Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.ClickLine 6: Me.SqlDataSource1.Insert()Line 7: End SubLine 8: End Class Source File: C:Documents and SettingsSONYMy DocumentsVisual Studio 2005WebSitesComments2.aspx.vb Line: 6 So can anyone explain why this only works in the first example?Many thanks,
I am using a ReportViewer Control inside of a Windows Form and ran into an issue with the page navigation failing to update upon refresh (the report itself does refresh - the page navigation does not). If the initial report has one page and the subsequent refresh produces five pages, the page navigation window only shows one page. If you manually type in page two or three, nothing happens.
I am try to login using the ASP.NET 2.0 Standard Login Control. When I enter the correct userId/Password and hit the Login button, the page just refreshes, no error is displayed. But if I enter wrong userid/password..it give me an error.
Also I check the Membership.ValidateUser() returns true, that means the user is validated, but still I am able to redirect to ReturnURL.?
Is there something wrong with the Authentication, or Creating a cookie. Can somebody shed some light on this,
I have the following machine configuration
Windows XP Pro Service Pack2 IIS 5.1 SQL Server 2000 Visual Studio 2005 DISABLE ANONMYOUS ACCESS IN IIS ENABLE WINDOWS AUTHENTICATION
I am getting the following output :
Membership.ValidateUser(Login1.UserName, Login1.Password) : - True HttpContext.Current.User.Identity.Name : - // is blank User.Identity.IsAuthenticated :- False User.Identity.AuthenticationType :- // is blank
NOTE : The applicationName is same in web.config as well as in the aspnet_Applications table in SQL Server 2000 membership database.
I have created one reports but all the records are displaying on one page.find a solution to display the records page by page. I created the same report without group so the records are displaying in page by page.
Hi All, I am placing a Matrix inside the table control for grouping requirements,but when we export the report to the Excel, the contents inside the table cell are ignored. Is there any way to get the full report exported, as per the Requirement.Please help me with this issue.
Hello I have a project that uses a large number of MS Data access pages created in Access 2003 and runs on MS SQL2005.
When I am on lets say my client, (first page in a series) data access page and I have completed the fields in the (DAP), I am directing my users to the next step of the registration process by means of a hyperlink to another Data access page in the same web but in a linked or sometimes different table.
I need to pass data entered /created on the first page to the next page and populate the next page with some data from the first page / table. (like staying on the client name and ID when i go to the next page)
I also need the first data access page to open and display a blank or new record. Not an existing record. I will also be looking to creata a drop down box as a record selector.
Any pointers in the right direction would be appreciated. I am some what new to data access pages so a walk through would be nice but anything you got is welcome. Thanks Peter€¦
UPDATE #2: When it said "Do you want to install Microsoft SQL Server" I said "yes" and that caused it to work. I exited and re-ran and now the print runs w/o the "install SQL Server" (If the prompt had said "Do you want to install the print dialog" we wouldn't be having this discussion...)
UPDATE: After posting this i discovered that the same thing occurs when attempting to print the report direct from IE6: First a dialog pops up "Do you want to install this software?" Name: Microsoft SQL Server. When I click "Don't Install" I get the dialog "unable to load client print control." Since this happens direct from IE6 I suspect it's browser settings. I'll resume tomorrow and post a followup.
My WinForm C# app integrates Reporting Services by calling them from WebBrowser controls. The problem is attempts to print cause a dialog: "unable to load client print control."
I've read prior posts that say "enable Active-X in your browser" - I don't know how to do that from a WebBrowser control.
Any ideas how to support Reporting Services "Print" from within a WebBrowser control?
I'm developing a site in asp.net and one of the main parts is to manage a timesheet. Now the problem i'm facing is; how do I save this timesheet in a database in a way that it's easy to save and easy to query from. I'm thinking about problems as i.e. 1st of a month is middle of the week, so I can't save it like this:
I have thought about this, and I cannot in my head come up with a way to create this. Maybe I am thinking about it too much, or maybe it is this difficult and I will need a 3rd party tool.
My users have requested a SQL Reporting Services report that looks like a calendar. Each page will be one month on the calendar. And then the data will fall on the calendar according to a date field in the database. It should not be all that difficult, but I cannot think of a way to acheive this.
Has anyone tried to build a report that is basically just a calendar, and each page is a month of the calendar? If so, did you build it using the standard SQL reporting services tools, or did you purchase a 3rd party vendor?
Hello there I'm having a little issue with Updating a SQL Table. *Deep Breath* OK, lets begin from the start... I Have a Table Called Job. I've an ASP Page setup to insert a new record into the Job table via a DetailsView Control with an SQLDataSource bound to it. This table has many columns in it, 4 of which are DateTime columns. I use a calendar Control from the toolbox for the DateTime selection and bound all the Calender control's SelectedDate to: SelectedDate='<%# Bind('EnteredDate') %>' using the EnteredDate field as my example. I only insert DateTime Values into 2 of the 4 DateTime columns in the original INSERT, so the remaining 2 columns are NULL. I have an UPDATE setup on a different page to edit the previously inserted rows in job using another SQLDataSource again using the bind method for calendars: '<%# Bind('RevisedDate') %>' My Problem is (according to this post I found online http://www.thescripts.com/forum/thread529052.html ) the page crashes with "Specified cast is not valid". The reason being I'm trying to bind to the remaining 2 NULL DateTime columns in an attempt to update them with a value my user will not be able to insert in the original INSERT. The solution Code I found on the link above is in VisualBasic and I have had little luck in trying to convert it into C# to even see if it solves my problem: VB Code: Function FixDBNull(ByVal inVal As Object) As DateTime If inVal Is DBNull.Value Then Return DateTime.Now Else Return inVal End IfEnd Function ASP Code: <asp:calendar id="calEditRevisedDate" runat="server"selecteddaystyle-backcolor="red"selecteddate='<%#FixDBNull(eval("RevisedDate")) %>'visibledate='<%# FixDBNull( eval("RevisedDate")) %>'selectorstyle-backcolor="Green"></asp:calendar> Any suggestions or work arounds would be greatly appreciated Thank You
I have 2 dropdownlist and a gridview. The dropdownlists filter the gridview, but now I have added two calendars and two textboxes. After user makes selections from the calendar the text boxes are populated with the dates. How do I add this to the following select parameter so that the filtering/querying works properly? (what I have here does not work in terms for the dates, but dropdownlists filter when I remove the dates section):<asp:SqlDataSource ID="DATA" runat="server" ConnectionString="<%$ ConnectionStrings:DATA_Connection %>" SelectCommand="SELECT * FROM [atable] WHERE(afield=@param1 or @Param1='Select something' or((CONVERT(char(10), adate, 101)>=@param3 AND CONVERT(char(10), bdate, 101)<=@param4)) AND(bfield=@Param2 OR @Param2='Select something' or((CONVERT(char(10), adate, 101)>=@param3 AND CONVERT(char(10), bdate, 101)<=@param4))" UpdateCommand="Update atable set afield=@afield, bfield=@bfield where id=@ID" > <selectParameters> <asp:controlparameter name="param1" controlid="DropDownList1" PropertyName="SelectedValue" type="String" /> <asp:controlparameter name="param2" controlid="DropDownList2" PropertyName="SelectedValue" type="String" /> <asp:ControlParameter Name="param3" ControlID="Textbox1" PropertyName="Text" Type="string" /> <asp:ControlParameter Name="param4" ControlID="Textbox2" PropertyName="Text" Type="string" /> </selectParameters>
