Connecting Mdb File To A Calendar

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.SqlClient
Imports System.Data
Imports 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 Function
End Class

View 2 Replies


ADVERTISEMENT

Connecting A Calendar To Info Via A Join

Apr 15, 2008

I have an item table that tracks changes to the item's value:

item_ID, cal_ID, item_value

The cal_ID is sequential in calendar period order.

Every item has at least one record with a cal ID of 0 and the starting value. When the value changes, a new record is written to the table with the item's ID, the cal_ID of the period in which the change occurred, and the new item value

I need to be able to join this to the calendar so I can get the item value for every item for every calendar period. I'm trying to come up with the join syntax that will give me one record for each cal_ID and item_ID with the item_value that was in effect for that cal_ID

If the item table had a begin and end cal_ID on the record, it'd be a straightforward BETWEEN subquery. But all I have is the begin period.
I've been wracking my brain for five hours. Any suggestions?

View 5 Replies View Related

Connecting To MDF File Over Workgroup

Aug 16, 2006

Hi
I've build a client management (Windows) application in VS2005 which works fine on the local development machine but falls over when trying to connect to the SQL Server Express file located on a second machine on the same Workgroup. Several of the apllications will connect to the database file from networked computers.
The error I get when testing the connection or trying to connect via the App is:---------------------------------------------------------------The file "Z:BushBreaks.MDF" is on a network path that is not supported for database files.An attempt to attach and auto-named database for file z:ushbreaks.mdf failed. A database with the same name exists, or specified file cannot be opened or it is on a UNC share.---------------------------------------------------------------
How can I configure this database and/or connection to be able to allow connections to the MDF file? Please note that security is not an issue if that is at all relevant.
Many ThanksJohn

View 1 Replies View Related

Locally Connecting To An SQL File

Feb 6, 2008

I am trying to loaclly connect to an sql file, i have installed SQl server management studio express, and have downloaded the file, so that i can access it locally, i have trawled about the whole of this site, but can't seem to find anything that helps.
The problem i have is i have a couple of guys telling me that i need to download the backup of teh database, which is in a .BAK format, then rename to .sql, and the open using sql 2005. However when i do this sql 2005 opens, but the a copy of notepad open infront of this, and the .sql file opens up in that. I am a total noob when it come to SQL however, with the help of some online tutorials have managed to teach myself SQL code, and a bit of basic PHP, but nowhere does it go into any great detail about the software surrounding SQl, or accessing the database, all the information i could find is on the code.

Any help would be greatly appreciated as my employers are getting a little bit anxious about all of this now, i know that once these creases are ironed out then i don't have a problem, but getting to the point that i am competent at is the trouble.

View 10 Replies View Related

Connecting To MSDE W/read Only File?

Jul 23, 2005

Hi,Does anyone know how I can connect to an MSDE db using VB with aread-only file? The file will be on a CD, and is actually just archiveddata off a SQL server. I would like to package my app on a CD alongwith the data file and allow users to pop in the CD and run the app,assuming they already have MSDE running. Any help?Thanks,Jason

View 1 Replies View Related

Problems Connecting To Sql Express 2005 Server, Where Mdf File Go?

Jul 10, 2006

Hello, I have correctly installed sql express 2005 onto my company server. I can connect to the sql express 2005 fine within sql management studio express. I can also connect to it the within visual studio 2005 server explorer. I have my database (MDF) on our server. I am trying to run my application within my client computer. I have changed the connection string property to connect to the server:

"Data Source=CTSSQLEXPRESS;Initial Catalog=UpdateAttributes;Integrated Security=True"

My program will only work if there is a local copy of MDF database located within my application directory. If I remove the local copy, it errors "No process is on the other end of the pipe" Is it possible to have my application without the local copy of the MDF? I thought the idea is to have the MDF on the server. Then my app would not have the MDF copy!?

View 1 Replies View Related

Connecting Database Engine (SQl Server 2005 File .*mdf) From Win CE 5.0 Platform

Jun 26, 2006

Is this possible to connect do the Database Engine (on sql server 2005 on XP platorm - file *.mdf (not mobile *.sdf)) from win CE 5.0?

I tried to do this :
ConnectionStringSQLServerCE = "Data Source=WORK_STATION\SQLEXPRESS;Initial Catalog=dbMachines;Integrated Security=False;Password=Panel;User ID=Panel";

SqlCeConnectionCE = new SqlConnection(ConnectionStringSQLServerCE);

SqlCeConnectionCE.Open();

but I catch error:
catch (PlatformNotSupportedException ex)
€žPlatformNotSupportedException€?
I noticed that I see server because when I use:
ConnectionStringSQLServerCE = "Data Source=WORK_STATION\SQLEXPRESS";

zwraca błąd typu

catch (SqlException ex)
€œLogin failed for user ''. The user is not associated with a trusted SQL Server connection.€?

I used
using System.Data.SqlClient;

from Compact Framework 2.0 under Visual Studio 2005 Device Application Windows CE 5.0

can anyone help me?

View 1 Replies View Related

Connecting To SQL Express 2005 Via Web.Config File In Visual Studio 2003

Oct 30, 2007

Hi
 I am following a project to build a small E-Commerce site from a book I have purchased and I have having problems connecting to the SQL Database with the code supplied.
The book is Apress Beginning ASP.NET 1.1 E-Commerce
http://www.amazon.co.uk/Beginning-ASP-Net-1-1-E-Commerce-Professional/dp/1590592549/ref=sr_11_1/202-7684451-7995058?ie=UTF8&qid=1193780707&sr=11-1
 The code added to the Web.Config file is :
<configuration>
<appSettings>
<add key="ConnectionString" value="Server=(local)NetSDK;Integrated Security=True;Initial Catalog=JokePoint" />
</appSettings>
 
The connection details are in a class file called Catalog.vb and is as follows
Imports System.Data.SqlClientPublic Class Catalog
Public Shared Function GetDepartments() As SqlDataReader
'Create the connection objectDim connection As New SqlConnection(connectionString)
'Create and initialize the command objectDim command As New SqlCommand("GetDepartments", connection)
command.CommandType = CommandType.StoredProcedure
'Open the connection
connection.Open()
'Return a SqlDataReader to the calling functionReturn command.ExecuteReader(CommandBehavior.CloseConnection)
End Function
Private Shared ReadOnly Property connectionString() As String
GetReturn ConfigurationSettings.AppSettings("ConnectionString")
End GetEnd Property
End Class
 The error is.....
Cannot open database "JokePoint" requested by the login. The login failed. Login failed for user 'MachineNameASPNET'. 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 open database "JokePoint" requested by the login. The login failed. Login failed for user 'MachineNameASPNET'.Source Error:




Line 15: 'Open the connection
Line 16:
Line 17: connection.Open()
Line 18:
Line 19: 'Return a SqlDataReader to the calling function
Source File: C:MyCommerceSiteJokePointBusinessObjectsCatalog.vb    Line: 17 Stack Trace:




[SqlException: Cannot open database "JokePoint" requested by the login. The login failed.
Login failed for user 'MachineNameASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
JokePoint.Catalog.GetDepartments() in C:MyCommerceSiteJokePointBusinessObjectsCatalog.vb:17
JokePoint.DepartmentsList.Page_Load(Object sender, EventArgs e) in C:MyCommerceSiteJokePointUserControlsDepartmentsList.ascx.vb:44
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()

The connection tests ok in Visual Studio 2003. All permissions are set using SQL Management Studio Express 2005.
The book is using SQL 2000, I have been trying different connection syntax's in the Web.Config file all day and now I have a big headache. I know its something simple, can anyone please advise ?
Thanks in advance.
 
Mark

View 3 Replies View Related

HELP: How To Avoid Ridiculous System Resource Issues When Connecting To A Huge Excel File

Sep 20, 2007

Hi all,

I have a 400MB Excel file that I consume from another automated process (don't ask). I copy this file down locally to my server, and I am attempting to create an SSIS package that points to this file via a connection manager. My computer starts gobbling up massive amounts of memory (devenv.exe gets up to about 800MB or so, then drops back down to 100MB) even when I attempt to rename the connection in the connection managers tab.

I have set all BypassPrepare to TRUE and ValidateExternalMetadata properties to FALSE, and still it can take up to 3 to 6 minutes for BI Dev Studio to respond. My specs:

Intel Centrino Duo 2.00 GHz
2GB RAM
XP Pro SP2

There MUST be a way for me to work effectively on a file of this size. Please help! Thanks much for any assistance.

Sincerely,

Brian Pulliam

View 4 Replies View Related

Store A Calendar

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

Outlook Calendar

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

Report To Look Like A Calendar

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

ASP.NET C# Calendar DataAccess Issue

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

Calendar Filtering In Gridview

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

Using A Calendar Control In An SQL Report

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

360-Day Calendar Year Function...

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

Generating New Month In Calendar

Jan 21, 2014

i have inherited a sql database to work on and cannot seen to fix this error. its an availability calendar and at the end of each month a new month is generated, it by default makes all dates unavailable but i need them available. is this done in the database as a default??if a member has logged in recently then the avails populate fine but if they have not logged in for a while then they all show unavailable? i

View 3 Replies View Related

How To Go From A Database To A Calendar Format?

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

Job To Be Run Ever First For The Previous Calendar Month

Jan 18, 2007

Hi!I have a query that has to return bunch of data based on the calendarmonth. I have to make sure that it will return data to me for 28 daysif it is February and for 31 if it is August(for example). I need tobe able to execute it every first of every month for the past 30, 31 or28 days based on the calendar month. Is there a function or a storedprocedure that I can use to do that?Thank you,T.

View 5 Replies View Related

Populate Calendar Table

Aug 3, 2007

Hello all,
I would like to populate a calendar table similar to the one used in the foodmart2005 sample database. In this table the day of the week, month, and year are recorded as well as additional data which I do not require.
If possible I would like to populate the table with 10 years of data starting with 2007.

Secondly would 10 years of data make the table to large?

Thank you for any thoughts you may have.

View 1 Replies View Related

Calendar Report Layout Help

Jun 28, 2007

Hello



I need to create something like the following table:



MON TUE WED THU FRI SAT SUN

01/01/07 02/01/07 03/01/07 04/01/07 05/01/07 06/01/07 07/01/07

Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field

08/01/07 09/01/07 10/01/07 11/01/07 12/01/07 13/01/07 14/01/07

Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field



The user would enter the start date, in this case the 1st Jan 07 and then this would populate a table. This seems like it should be so simple but I can't work it out, can anyone help please?



Cheers

View 1 Replies View Related

Calendar Control In A Report?

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

Create A Graghicapl Calendar Using VFP 9.0

Mar 8, 2007

I'm working on a project where a user wants to show there scheduled events on a calendar.

The way they want to show it is, displaying a bar across the days that the event takes place.

They want this on a web page and in Word. I'm using VFP 9.0 and I know it has web tools, but I've never used them. Could someone please point me in the right direction of how to do all of this?

Thank!

View 1 Replies View Related

Filtering Calendar Control?

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

Calendar Control In Safari

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

Calendar Changes To Different Time Format

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

Connection Problem With Database And Calendar

Nov 18, 2006

hi folks:imports system.data  Private schedule As New DataView()    Protected Sub Page_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreRender        schedule = CType(srcSchedule.Select(DataSourceSelectArguments.Empty), DataView)        schedule.Sort = "entryDate"    End Sub///////////////////////whenever i run the above code an error message comes up with the following message:Object reference not set to an instance of an object.and it highlights the bold message mention in the code. I wanted this code to highlight the dates in the calendar that have events on them.Can you please help. thank you very much in advance.

View 1 Replies View Related

Calendar Control And Database Connection

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

SQL Server And Exchange Calendar Items

Jun 14, 2004

We are looking to take rows from an existing SQL server table and use them to create calendar entries in Exchange server.

Is there a way SQL server can be set up so that this can be done as a trigger when new rows are entered into the table?

Thanks
Tim Smith

View 3 Replies View Related

SQL 2012 :: Sync Table With Calendar?

Nov 11, 2014

sync values from table to calender. I got SQL Server 2012 and Outlook 2013.

I want to know is there any way all appointments booked in table should sync with exchange server automatically.

View 5 Replies View Related

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 View Related

Querying For Calendar, Grouped By Hour?

Jul 20, 2005

I've been scratching my head on this for quite awhile and it has me stumped.I hope to define a query which I can use to fill a "day planner" type ofcalendar. Although I've see a lot of these, only one has had what I thinkis a really nice feature - it collected into groups all events thatoverlapped into contiguous blocks of time. The net result of this is thatit becomes possible to output a calendar (html table) that is much lesscluttered. So I want to use this same idea for my own little project.The trick is that events may (or may not) start and end such that theyoverlap (completely or only at one end). I only am concerned with events ona given day.My "events" table contains eventtitle, date,starthour and endhour. Hoursare numbered from "0" to "23". I also have a lookup table of the "hours ofthe day" with which I did a JOIN to include the "missing" hours (where therewere no events - making a query that returned events for each hour and nullsfor each hour that had no event scheduled for it. But this makes too many"blank" rows, which is part of the clutter to which I referred.I've been able to construct queries that work in some cases, but not all.I've reread my copy of Celko's SQL For Smarties and came close, but nocigar. Where he discusses hotels and room-nights is part of the solution Ineeded, but my need goes beyond that quite a bit.Basically, I need to calculate one or more "spans" that contain contiguousgroups of start/end times. By knowing the number of hours spanned, I canthen use that for a <TD rowspan='n'> to collect my data like I want.I seem to keep hitting all around the solution. Maybe there isn't one (thatis purely a SQL solution). Or maybe I'm just looking at the problem thewrong way.So I thought I'd see if anyone here might point me in the right (or at least"new") direction. I've been looking at this for so long, I'm probablyoverlooking some simple and obvious trick to do this. Or maybe I'll getlucky and someone has seen or done exactly this already and can provide asolution?Incidentally, I've avoided utilizing a stored procedure or making a numberof temp tables to collect intermediate results, as I might need to port thisto a "dumb" database that does not provide such facilities. Maybe that'simpractical?thanks in advance,--

View 3 Replies View Related

Report In Calendar/schedule Layout

Jun 13, 2006

Is it possible to produce a report which is displayed as a calendar, similar to outlook?

im using rs2000 with no option of an upgrade to 2005



any help would be appreciated!

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved