We have a "To do" list that also has a "month" column.
We'd like to have the todos in March to start with 1, and once we started entering in items for April, the first todo entered would start @ 1, then second todo would be 2, etc.
Calculated field maybe??????
Any suggestions are welcome...
So, I got it to work with the help of a "Periods" look-up table that I created.
My main table, which showed the 12 monthly periods, had one column which was a long date-time field. I took that and got the monthname().
With this new look-up child table, I defined an int column ("PKID") from...
Just to further explain:
Let's say I look at three months time frame:
January @ $10,000
February @ $15,000
March @ $12,000
The category fields (on the horizontal) are the months, and the data fields (what builds the vertical axis) are the costs.
Right now, when I look at the start of my chart...
Thanks RiverGuy!
That just did the same thing as the margin property.
It just added a left margin more or less.
The left to right flow is by month, and the vertical is dollar values.
I have a line chart series that is for accounting.
A sample query would pull back 12 rows (1 row for each month, Jan - December), and the columns would show the dollar amounts for separate buckets of money allocations.
What I'm trying to do is have the series chart line start @ 0 (we're trying...
Sorry...I was just trying different records...same results w/ same ID.
Do I need to do a print or something to get the SSMS "Execute Stored Procedure" to show up in the TextData column of the profiler?
If I include the [Use DB] statement, I see that, but....that's all that gets written. It...
So, in SQL Profileer, I to see this:
EventClass -- RPC:Completed
TextData -- exec usp_UpdateMilestoneDescription @UID=3796
ApplicationName -- .Net SqlClient Data Provider
NTUserName -- no value shown...it's blank
LoginName -- MyUser
CPU -- 0
Reads -- 702
Writes -- 1
Duration -- 32...
jmeckley,
I've got the @ symbol in other DB calls, and it's working fine...no errors. The activeItem["UID"] is correct b/c I was writing it to the page to make sure it was the checked item's Primary Key.
I'm trying to call a linked server, SS2000 that has NText field and instert that data into an nvarchar(120) field on SS2008.
If I execute the SPROC from SS Management Studio, it works fine.
If I try to call the SPROC from my web application, I don't get any errors, but the data doesn't get...
All,
I found this to get the column headers sortable:
http://www.kryogenix.org/code/browser/sorttable/
I had to edit the ipp_0001.asp page as follows to get the table headers:
Function GenTableHead ()
...lines omitted for brevety
strHTML = "<thead><tr>"
For i = 0 to 5
strHTML = strHTML &...
I'm trying to get this printers page to have a grouping band by location:
server/printers/ipp_0001.asp
...page found in the Windows/Web directory for Server 2008.
So, when the page is run, there's a grouping band by location...and you can see by location where printers are associated. It's...
Hi!
We're trying to migrate from an ASP.NET 2.0 web application to SharePoint. Luckily, our database is pretty simple for now.
Questions we have are:
1. How do we pull in the data so users can view the same information just in the SharePoint UI? We're assuming Reporting Services will help...
My issue is I'm trying to have a datagrid (ASP.NET 1.1) to allow editing, along with sorting ASC/DESC via column headers.
When I click "Edit", my SQL query ASC goes to DESC, and vice versa. This happens on Cancel, Paging, Delete, etc...I'm trying to limit the "swap" in the order by criterion...
hey all!
Thanks for the threads...here's what I used:
SELECT cat.Name AS ReportName, cat.Description AS ReportDescription, cat.CreationDate, cat.ModifiedDate, ex.UserName, ex.Format, ex.TimeStart,
ex.Parameters
FROM ExecutionLog AS ex RIGHT OUTER JOIN...
We are trying to see if it's possible to see which users are running what reports.
When users hit a report, they have to enter their WIN credentials.
We do have the default switch is 3:
<!-- 1 = error, 2 = warning, 3 = info, 4 = verbose -->
<add name="DefaultTraceSwitch"...
I have a site which will have subdirectories.
I'm creating a template having .js and .css file includes?
How can I create a template that works in both the root and subdirectories w/o having to have two versions like the following where I have my .css file in a folder called css. First example...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.