Calendar Control In Wrong Format
Mar 3, 2008
Hi,
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:
http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fLON-SQL-S03%2fOpsSupportLee%2fFailed+Form+Reasons
then everything is fine. However a direct call (skipping Report Manager) such as:
http://cbada00272/reportserver?%2fLON-SQL-S03%2fOpsSupportLee%2fFailed+Form+Reasons
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.
Regards,
Lee
View 11 Replies
ADVERTISEMENT
May 15, 2008
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!
View 2 Replies
View Related
Oct 19, 2007
I have a need to create a report that contains a calander, i.e. last month in rows and columns . Any idea on how to accomplish this need?
View 9 Replies
View Related
Feb 15, 2007
Hello,
Please, help with following issues.
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?
Any suggestion/comment highly appreciated
View 2 Replies
View Related
Apr 3, 2008
SSRS 2005-
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?
Thanks!
View 1 Replies
View Related
Dec 11, 2005
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
View 1 Replies
View Related
Mar 26, 2008
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?
Thanks
View 11 Replies
View Related
Jul 13, 2007
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
View 5 Replies
View Related
May 4, 2007
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.
View 2 Replies
View Related
Jan 11, 2007
Hi All
Is it possible to add datetime picker (Calendar Control)
in 2000 reporting services
Cheers
View 3 Replies
View Related
Oct 21, 2015
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.
View 4 Replies
View Related
Jul 23, 2005
HelloMy department has a SQL server database that is used to all facets ofproduction within our department. This includes key production jobsteps, project names, numbers and descriptions.The calendar is currently done manually as an Excel document. The userrecieves hard copies of the required information, then keys it into theappropriate place on the Excel document.We would like to pull information out of that database, and put it in amonthly calendar format. For example, take a project name and the dateassociated with that project, and put it on a calendar in theappropriate date "square".If you have information or experience with software that can be used toaccomplish this task, I would appreciate hearing your advice.Thanks in advance.
View 1 Replies
View Related
Sep 20, 2006
I have a DateTime parameter called End Date set up with a default value eg =DateAdd("s",-1,Today). When I preview, the default value appears as 19/09/2006 23:59:59, which is fine.
However, when the report is deployed, it is displayed as 19/09/2006 11:59:59 PM. This would also be fine, except when the user changes the date using the calendar, it converts the time back to 24 hour time - eg 19/09/2006 23:59:59. Then when the report is run, it converts the time format back to AM/PM again.
Also, I have a Start Date Parameter, with a default value of 12:00AM today. I would like this to be displayed as 19/09/2006 12:00AM in the Start Date parameter text box, however reporting services will not display the 12:00AM part. Using FormatDateTime in the Default value will return a string and cause an error. I don't want to change the parameter to a string and lose the date picker.
Any ideas,
Thanks
PS Getting the Date/Time settings changed on the reporting server would be extremely difficult!
View 1 Replies
View Related
Aug 24, 2007
Hello!
I have a table in an SQL database, in which I have a field in datetime format.
In my aspx page I would like to get the date the user chooses from an asp: calendar I have and submit it to the DB.
I already have all the code ready, the datasource, the gridview, all other fields to submit, and I just added a template field with the asp:calendar so that the user could choose a date.
I´m getting this error when I run the page: "Conversion from type 'Date' to type 'Boolean' is not valid."
It seems to be a problem about the date that is given by the Calendar object (?) and the one I should submit to my DB.
Here´s the part of the code where I have my standard Calendar binded to the correspondant field: <asp:Calendar ID="Calendar1" runat="server" SelectedDate='<%# Bind("data") %>' Visible='<%# Eval("data") %>'> </asp:Calendar>
I´m gessing I should probably change the format of the date somehow before submit it to the DB, but how?
Thank you all,
RR
View 4 Replies
View Related
Jun 9, 2015
How can I format the calendar in format: Jun/2015 or August/2015 in ssrs.
View 6 Replies
View Related
Apr 8, 2008
Hi Guys, I am trying to convert a date to yyyymmdd format
This is the input date: 1/10/2008 2:59:58 PM
This is what I am getting: Jan 10 2
Field definition: MaxDate (nvarchar (8) , not null)
Code:
INSERT INTO tblCurStatus (ResultsPKey, Status, MaxDate)
SELECT ResultsPKey, Status,
MaxDate = (REPLACE(REPLACE(CONVERT(varchar(8), tblStatusHistory.Date, 112), '-',''), ' ', ''))
FROM tblStDate INNER JOIN tblStHistory
ON (tblMaxStDate.CurStatDate = tblStHistory.Date)
AND (tblMaxStDate.ResultsPKey = tblStHistory.ResultsPKey)
I cannot understand why I’m not getting the format I want. What do I need to do to get yyyymmdd?
Thanx much,
Trudye
View 4 Replies
View Related
Jul 3, 2007
HiI'm not sure if this is a .net or a SQL issue. My development machine is using SQL 2005 while the live server is SQL2000. I have a smallmoney field in the database for holding a house rent. The following is used to display the contents on the page<asp:Label ID="lblrent" runat="server" Text='<%# Bind("rent", "(0:0.00)") %>'></asp:Label>In development, the number is displayed correctly, with the decimal place, .e.g. 200.50 but on the live server the number is displayed as 20050,00. What I have noticed in the database is that the number is held differentlySQL 2005 - 200.5000SQL 2000 - 20050Is there a difference between SQL 2000 and 2005? How do I get around this problem?
View 6 Replies
View Related
May 17, 2006
Hi
I have the problem that the below defined paramter gets entered in the database as a interger. the Field in the DB is a nvarchar(5) and the controll that suplies the value is a TextBox
this is the parameter definition:<asp:ControlParameter ControlID="tbComment" Name="Comment" PropertyName="Text" Type="String" />
Why do I get this error, why does ASP to whant to make an integerfrom this text field? When putting a interger value in the textbox all works well and the data gets posted to the database.
I use a SqlDataSource with automatic generated script.
look forwart to a solution
walter
View 1 Replies
View Related
May 4, 2006
The IT group that I work with has the habit of gathering data,formatting (i.e. in reports) and then storing the same formated data inthe same database.I think the practice is wrong. I think the activity is fundamentallywrong because we are storing the exact same data in a database in twodifferent locations. Somehow I have the impression that database designis about "oneness".I believe that collecting the data and then storing summerized data forreporting into a data warehouse would be the right solution.I am getting flack for my viewpoint.Am I all washed up?
View 1 Replies
View Related
Dec 7, 2007
In my report I have two date parameters, both are of type DateTime.
The problem is that when the report is called for the first time the report parameter value is not shown in the expected format (de-DE, 01.01.2007) but in en-US 01/01/2007
Only when I change a Date using the calendar popup and click on the "show report" button, the right format will be taken over.
Language properties of the report are"=User!Language"
IE language is de-DE.
Report Server is a MS Windows Server 2003 R2 Standart Edition SP2
with MS SQL SERVER 2005 SP2
P.S.
on a server with MS SQL SERVER 2005 SP1, this report works fine.
may be this bug is a new feature of SP2?
View 13 Replies
View Related
Sep 21, 2006
Hi there,
I have designed a package that works perfectly well, exporting data to an excel file from an ole db source. The problem is that in the excel destination file, columns of data that originally were numbers, are formatted as text. It would be just annoying if it weren't because I use those figures in a pivot table that operates with them.
Any idea on how to tell Excel that those columns are numbers?
Thx in advance
View 9 Replies
View Related
Jan 30, 2007
In my asp.net application I have a local report with an image control in thedetail row of the table and the Value attribute set as="File://" & Fields!FQPhotoFileName.ValueThe first row in the table always shows the wrong image and it's always thesame wrong image. The problem is there even when I change the sort order orthe criteria for the underlying dataset. For example, I ran a small testthat populated the dataset with 2 rows and 2 images. When I sort by anycolumn (e.g. ID) in ascending ascending order the ID=1 row (the 1st row)shows the wrong image and the ID=2 row shows the correct image. When I rerunthe report sorting in descending order the ID=2 row (which is now the 1strow) shows the wrong image and the ID=1 shows the correct image.Any suggestions?
View 1 Replies
View Related
Feb 19, 2006
Im trying to insert a record in my sql server 2005 express database.The following function tries that and without an error returns true.However, no data is inserted into the database...Im not sure whether my insert statement is correct: I saw other example with syntax: insert into table values(@value1,@value2)....so not sure about thatAlso, I havent defined the parameter type (eg varchar) but I reckoned that could not make the difference....Here's my code: Function CreateNewUser(ByVal UserName As String, ByVal Password As String, _ ByVal Email As String, ByVal Gender As Integer, _ ByVal FirstName As String, ByVal LastName As String, _ ByVal CellPhone As String, ByVal Street As String, _ ByVal StreetNumber As String, ByVal StreetAddon As String, _ ByVal Zipcode As String, ByVal City As String, _ ByVal Organization As String _ ) As Boolean 'returns true with success, false with failure Dim MyConnection As SqlConnection = GetConnection() Dim bResult As Boolean Dim MyCommand As New SqlCommand("INSERT INTO tblUsers(UserName,Password,Email,Gender,FirstName,LastName,CellPhone,Street,StreetNumber,StreetAddon,Zipcode,City,Organization) VALUES(@UserName,@Password,@Email,@Gender,@FirstName,@LastName,@CellPhone,@Street,@StreetNumber,@StreetAddon,@Zipcode,@City,@Organization)", MyConnection) MyCommand.Parameters.Add(New SqlParameter("@UserName", SqlDbType.NChar, UserName)) MyCommand.Parameters.Add(New SqlParameter("@Password", Password)) MyCommand.Parameters.Add(New SqlParameter("@Email", Email)) MyCommand.Parameters.Add(New SqlParameter("@Gender", Gender)) MyCommand.Parameters.Add(New SqlParameter("@FirstName", FirstName)) MyCommand.Parameters.Add(New SqlParameter("@LastName", LastName)) MyCommand.Parameters.Add(New SqlParameter("@CellPhone", CellPhone)) MyCommand.Parameters.Add(New SqlParameter("@Street", Street)) MyCommand.Parameters.Add(New SqlParameter("@StreetNumber", StreetNumber)) MyCommand.Parameters.Add(New SqlParameter("@StreetAddon", StreetAddon)) MyCommand.Parameters.Add(New SqlParameter("@Zipcode", Zipcode)) MyCommand.Parameters.Add(New SqlParameter("@City", City)) MyCommand.Parameters.Add(New SqlParameter("@Organization", Organization)) Try MyConnection.Open() MyCommand.ExecuteNonQuery() bResult = True Catch ex As Exception bResult = False Finally MyConnection.Close() End Try Return bResult End FunctionThanks!
View 1 Replies
View Related
Jan 27, 2008
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.
With Thanks
M.Mahendra
View 5 Replies
View Related
Oct 25, 2007
does any one have and example of how to embedd a flash swf file onto a report.??? Is it possable? any examples would be helpful.
View 1 Replies
View Related
Mar 20, 2007
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?
RELATED THREADS
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=332145&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=264478&SiteID=1
View 1 Replies
View Related
Nov 8, 2004
Hi,
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:
Month Week Mon Tue Wed Thu Fri Sat Sun
1 5 .. .. .. .. .. .. ..
2 1 .. .. .. .. .. .. ..
Anyway, I got stuck to find the best method, maybe someone has made something like this?
Thanks in advance!
Pieje
View 2 Replies
View Related
Nov 27, 2007
When I try to view someone else's Calendar in Outlook I get this message:
The messaging interface has returned an unknown error. If the problem persists, restart Outlook.
Of course restarting Outlook resolves nothing. Please help.
View 1 Replies
View Related
Sep 17, 2007
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?
Let me know what route I should look to follow.
Thank you!
T.J.
View 5 Replies
View Related
Oct 10, 2007
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
View 4 Replies
View Related
Feb 3, 2008
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>
View 3 Replies
View Related
Feb 21, 2008
Hi Everyone.
I’m trying to read data from a databasefile called database.mdf which has a connection string called “ConnectionString1�. The aim is to highlit specific days in my calender. For example if there is an event in my database that day on the calander will be highlited. The database has a columb called “Date� in a table called “Dates�. Please can you help? My knowlade in asp.net and VB is very limited. This is as far as I have gone. (I don’t realy understand the VB part as I have copyed it from somone) I just need the vb code to connect to the database.
Imports System.Data.SqlClientImports System.DataImports System.Data.OleDb
Partial Class _Default Inherits System.Web.UI.Page Protected Sub Calendar1_DayRender(ByVal sender As Object, ByVal e As DayRenderEventArgs) If IsExistMeeting(e.Day.Date.ToString("MM/dd/yyyy")) Then e.Cell.BackColor = System.Drawing.Color.Red e.Cell.ForeColor = System.Drawing.Color.Yellow End If
End Sub
Function IsExistMeeting(ByVal datestring As String) As Boolean Dim constr As String = System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString1").ConnectionString.ToString() '"your connection string" Dim connection As SqlConnection = New SqlConnection(constr) Dim sqlsel As String = "select count(*) from Dates where CONVERT(char, date, 101)='" + datestring + "'" Dim sda As SqlDataAdapter = New SqlDataAdapter(sqlsel, connection) Dim ds As DataSet = New DataSet() sda.Fill(ds, "Dates") If ds.Tables("Dates").Rows.Count = 0 Then Return False End If Return True End FunctionEnd Class
View 2 Replies
View Related
Jun 23, 2008
I'm looking for a function that will return an INTEGER that computes the number of days between two dates based on a 360-calendar year instead of using just the datediff function which is actual days.
If anybody knows where I could find something like this, I would be greatly appreciated.
Does this site have a library of user-defined sql functions? Or, does somebody have a site that you know of where there are a bunch?
Thanks,
South Side Rob
View 14 Replies
View Related
