Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Headers Overlapping When Scrolling Down The Report


I have set the option 'Headers should remain Visible while scrolling', in order to freeze the headers. However, on some reports, when I scroll down the report , the headers overlap each other .

Any ideas why this would happen?


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Matrix Scrolling Headers
Could someone describe to me how to have headers remain visible while scrolling in a matrix? I can do this in a table without a problem but can't seem to find this option for a matrix.
 

View Replies !   View Related
Design Prob:parent/child W Different Headers: Sorting, Non Scrolling Header Etc
 

Report needs to display as follows
 
Parent
col1,col2,col3...
val1,val2,val3
 
expandable section
child1
colA,colB,colC
valA,valB,valC
 
child2
colA...
....
 
repeat
 
Am currently implementing this as nested list controls with textboxes due to the fact that the headers for the parent and child differ. (By header I mean the column labels)
 
1. is there a better way of doing this as I much prefer working with tables/matrix controls?
2. how can I stop the header from scrolling - this is possible with tab/mtx controls. The alternative is to repeat the headers all down the page which wastes space and looks messy
3. How can I apply 'interactive sorting' to the parent columns?
 
Thanks

View Replies !   View Related
Report Headers Vs Page Headers
Hi, this is probably a simple question but I just can't figure it out. I'm using SQL Server Reporting Services 2005 sp1.

I'm trying to design a report that displays a particular embedded image on the first page, and then a different one on every subsequent page. I.e full, fancy company logo on the first page, and a trimmed down version on every other. In Crystal, I would have simply used the Report Header and Page Header sections to achieve this - easy.

However, in SQL Reporting Services, there is only a Page Header section - therefore whatever I place in the Page Header shows on every page. Now, I know how to stop it displaying on the first page, but I don't know how to display the other image instead.

I read in a support forum that it is possible to do this by "placing report items above or below your data regions" but I can't get it to work.

Grateful for any assistance.

Matt

View Replies !   View Related
Report Scrolling Vs. Pages In Report
I have two separate reports, and they work fine. But I noticed that in one report, regardless of length, it will show up in the Report Manager as one page that you just scroll down through. The second report always shows up as more than one page, and you have to click through the pages to see everything. Is this some setting that I am unaware of? I have tried finding a difference between the two reports, but can't see why one would show up as a long continuous report and the other is divided into pages. Any ideas?
 
Thanks in advance!

View Replies !   View Related
Overlapping Of Report Items In Renderers(HTML And Excel)
Hi,

   We have created a report chart, a simple bar graph, and need to put 2 vertical lines (target limits) on this chart, At the end we need to export this charts in excel and html, but it says that the overlapping of reports items is not supported in all renderers.

It seems that HTML and Excel donot support the overlapping of this 2 items.

 

Can anyone please help me in this issue? or is their any other alternative to get the chart and the static lines placed on this charts.

 

Regards,

Sumeet

View Replies !   View Related
While Exporting A SSRS 2005 Report In CSV Format ,can We Include The Report Headers And Footers Also To Be Exported
 

While exporting a SSRS 2005 report in CSV format ,can we include the report headers and footers also to be exported .
Thanks .

View Replies !   View Related
Headers On A Report
I wanted to show header titles for each group of accounts. Ho would I be able to do that. The query that I have right now is:

select * from apcopah
where substring(ap_control_acct, 1, 4) = '1624'
and date_vendor_inv >= '2001-08-01'
or substring(ap_control_acct, 1, 4) = '1631'
and date_vendor_inv >= '2001-08-01'
or substring(ap_control_acct, 1, 4) = '1632'
and date_vendor_inv >= '2001-08-01'

I would like it to look like this:

Utilities

Ap_control_acct date_vendor_inv
1624 2001-10-01
1624 2001-12-01

Audit Fees

Ap_control_acct date_vendor_inv
1631 2002-09-01
1631 2002-10-01


Is this possible?

View Replies !   View Related
Report Headers
I'm new to Reporting Services, but am familiar with other reporting tools.  My question is, is there really no way to reference a field in a page header?  If so, I suppose you could repeat some header information on subsequent pages from the detail section of the report using a text box, but how is that done because when I check the property box "Repeat report item with data region on every page" nothing happens.  What is the best way to repeat header information on every page that needs to contain field values/information?

Thanks for any help you can offer.

 

View Replies !   View Related
Report Headers && Footers
I see the Page Header and Page footer, but what about Report Header and Report Footers??? Doesn't look like ssrs has this ability, am I wrong??

View Replies !   View Related
Report And Page Headers
All I can find is Page Headers. Is there a report header like there is in Access?

View Replies !   View Related
Images (in Dataset) In Report Headers/Footers
 

I have an image stored in a dataset that I would like to place in the page header and footer.  Unfortunately dataset fields can not be placed in headers/footers.
 
Embedded pics in the project and/or report are NOT an option as the report must pull the image from the database.   UNLESS there is a way to embed it FROM the dataset.
 
Normally I use =ReportItems!FieldName, but this doesn't seem to work when dealing with images. 
 
I put the image in the header row the table holding the report information, but there are some pitfalls. Consider the following: put the Image in the top left cell of the header rows (A1) , put my Report Title in Cell (A2) and finally put =Now() in cell (B2).
 

When the report renders Cell (A1) has grown to accomodate the size of the image, Cell (A2) is fine, but cell (A3 - the date-) is pushed down...as expected (boooo!) 
 
I used the following function =Fields!ReportTitle.Value & chr(10) & chr(13) & Fields!ReportDate.Value in (A2) a slick solution, but the padding is different and I need different font sizes and weights. (...almost) 
 
I moved the image in (a1) and the rest of the fields following respecfully (B1, C1, D1...) but with parameters the header is now practically half the page (...ok so that was a bit of an stretch)
 
I tried the RepeatsWith property and couldn't get it to work????  Am I using it correctly?  I have a table in the body of a report (table1).  Above it, I place the image.  In the image properties, I choose RepeatWith and select table1, I expect to see the image repeat on each page, but that is not the case.  I'm probably missing a simple explanation.
 
I even tried to pass the image as a parameter.  URRRNT!  At least with my experience. 
 
Have I exhausted all possibilities without extensive code?
 
All I'm trying to do is line up the Image with the report Title/date/parameter values in the HEADER making the report look pretty.
 
Thanks for the help...
 
SSRS 2005 User
 

View Replies !   View Related
How To Change Report Headers And Footers Dynamically From ASP.NET
 

Hello All,
 
I have designed some reports and kept these reports in the report server.
 
My question is: I want to change report header and footer values dynamically and save the new values in the report template, when the user enters new velues in ASP.NET GUI.
 
Next time if the user opens the same file the report should display the recent values.
 
Please help me in passing the parameters from ASP.NET app to SQL Reports and saving the parameters in the report template.
 
Thanks,
Rao.
 
 

View Replies !   View Related
How To Add Or Use Muliple Page Headers For A Report In SSRS 2005
Hi ,
 

Can we add multiple Page headers for a report in SSRS 2005. If we can add can any one tell me how to add multile page headers for report in SSRS 2005. IF not is thier any solution for this issues.
 
 
Anyone please reply back
 
 
Thanks and Regards
Manju
 

View Replies !   View Related
Invisible Column Headers When Export Report To Excel ?
Hi All,
 
I want to invisible those column headers when export the report to excel,  how can i achieve that?
 
 
Cheers
 
Nick

View Replies !   View Related
Matrix Report Column Headers Are Not Sorting Properly
Hello,

When I build a matrix report, based on a cube, the Month Numbers are the column header and the sorting is incorrect. It sorts it as 1, 10, 11, 12, 2, 3... So the report looks kinda like this:
             1      10     11     12      2      3      4
North
South
East
West

 

However, when I build off the same cube, using a model in Report Builder, the header for those same Month Numbers sort correctly.

I checked that the Order By, for the Dimension, is set to Key.

Does anyone have a suggestion on how to make the colum headers sort correctly in a Matrix Report?

Thank you for the help.

 

View Replies !   View Related
Report Design Question Two Horizontal Column Headers One Below Other
I have a report requirement, i am new to reports.

I want to have two lines of column headers.( with 7 columns in parent columns header)

and 7 columns in child column header.

The first column header will show a parent record.

And after the parent record i want to show the next child related horizontal column headers and will show all child record related to the above parent record.

its a one to many: 1 parent record and below all child records for that parent record.

can i use subreports controls to show all child records of the parent.

Thank you very much for the information.

 

 

View Replies !   View Related
Parameters In Report Headers Not Displaying After Upgrade To SQL 2005
 I just recently upgraded my server to SQL 2005 from 2000. When I open any RDL file, I am prompted to convert the file. Ok, fine. The problem I am having is that in my reports, the headers are filled with parameters based on the various datasets returned when the report is generated. When I preview the report - I get no data where the parameters should be. Just blank space. However, when I run the queries only, the data is there, so the problem seems to be with displaying the data.  Is there some kind of trick about parameters in headers in this version? I have looked and looked, so any help would be great!

Thanks!
Leigh

View Replies !   View Related
Problem With SRS (2003) Using A Matrix Report Headers Missing Info
 

I have a matrix report with three cols of data in the header I have the following text boxes
textbox 1 expression =(fields!dateval.value) + " SC"
textbox 2 expression =(fields!dateval.value) + " OT"
textbox 3 expression =(fields!dateval.value) + " NCR"
 
when the report runs the first set of data the headers are correct
07/01/2007 SC           07/01/2007 OT              07/01/2007 NCR
 
but the next set shows this
 
08/01/2007 SC            OT                                   NCR
 
and the next

09/01/2007 SC            OT                                   NCR
 
all col past the first are droping the date from the header???

View Replies !   View Related
Scrolling Group Header
I am using table to display data.

I want to have group with group header.Group header needs to remain fix while  scrolling down.

 

View Replies !   View Related
Scrolling Column Headings
 Greetings,

I have generated a report that requires the user to scroll down the page since it is fairly long. I want to be able to show the column headings as the report is being scrolled. Much like excel locking the column headings as you would scroll down the spreadsheet so you know what values correspond to what heading. How do I configure this report to do this? Any suggestion is greatly appreciated. Thanks!

View Replies !   View Related
Scrolling VERY Jumpy When Using FixedHeader=True
I have a simple report with one Table in the Body of the report.  I have the table property FixedHeader=True.  This works as expected when I run the report, but when you scroll the table's header shakes up and down and you can see the table's detail rows above the top of the header.  The shaking (obviously) stops once you stop scrolling but it is something that would be very distracting to the end user.  Anyone else gotten this problem?

View Replies !   View Related
How To Keep Header Remain Visible While Scrolling
Hi,

 

I have matrix which has many rows. Is there any way to keep header remain visible while scrolling?

 

I tried to set "Group header should remain visible while scrolling" in my columngroup property but got the error:

[rsFixedHeadersInInnerDataRegion] The matrix €˜matrix1€™ includes a table header or column with FixedHeader set to true.  This is not allowed on data regions inside other data regions.

 

I have matrix inside a table which I set table property FixedHeaderto False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

 

Thanks in advance!

View Replies !   View Related
Columns In FixedHeader Section Grow Taller During Scrolling - Why?
Greetings,
 
I have a wide report.  The leftmost two columns have the FixedHeader property set true so they remain visible when I do horizontal scrolling.  My problem is that the height of the 1st two rows in the fixed header section increases as soon as I scroll the report to the right.  The height of the 1st two rows in the fixed header section roughly doubles while the height of the scrollable section remains the same.  The upshot is that the fixed part of the report is misaligned with the scrollable part (because the rows in the two sections don't have the same height).  Only the 1st two rows in the fixed header grow taller - the other rows in the fixed header retain their original height.
 
Has anyone seen this problem or have an idea what is happening?

 
Thanks,
BCB
 
This is the style that is generated for one of the fixed header columns:
 
.a6
{overflow:hidden;
HEIGHT:100%;
WIDTH:100%;
font-style:Normal;
font-family:Verdana;
font-size:8pt;
font-weight:Normal;
text-decoration:None;
direction:LTR;
unicode-bidi:Normal;
text-align:left;
writing-mode:lr-tb;
vertical-align:Top;
color:Black;
word-wrap:break-word
}

View Replies !   View Related
Date Overlapping
i have a table containing following dataeffdate termdate uid----------- ----------- -----------1 2 13 4 25 8 37 9 411 12 512 13 63 6 75 9 8i need to replace all the overlapping records with one recordsuch that resultant table shud look likeeffdate termdate uid1 2 111 13 23 9 3Thanks

View Replies !   View Related
Overlapping Sets
I have the following table structure

CREATE TABLE [dbo].[QDisc](
[Id] [int] NOT NULL,
[MinVal] [int] NOT NULL,
[MaxVal] [int] NOT NULL,
[PerVal] [int] NOT NULL,
CONSTRAINT [PK_QDisc] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

I need to be able to select unique overlapping sets of data based on the minval and maxval.

Simple Example
minval maxval
5 15
16 25
10 20

query would produce
minval maxval
5 10
11 15
16 20
21 25

More Complex example
minval maxval
5 15
16 25
10 20
7 7
1 100

query would produce
minval maxval
1 5
6 6
7 7
8 10
11 15
16 20
21 25
26 100

Extra points if anyone can do this without SP and cursor but I'd be satisfied if someone supplied it that way.

View Replies !   View Related
T-SQL Overlapping Time
I have a table with following fields

CURRENT_DAY  FROM_DATE                                    TO_DATE

1                             1899-12-20   09:00:00.000               1899-12-20   10:00:00.000

1                             1899-12-20   09:50:00.000               1899-12-20   11:00:00.000   

1                             1899-12-20   12:00:00.000               1899-12-20   02:00:00.000

I need the count of records that overlap with each other. [OR]

1 if there is overlap, 0 if there is no overlap.

I am new to sql, thanks for any help.  

Yog

View Replies !   View Related
Overlapping Integer Ranges ??
:confused: Dont know if this will be tough for the rest of you but for someone who is fairly new to SQL...I cannot figure it out...

I have a table:

Rownumber starttime endtime
1 l 30 l 240
2 l 40 l 120
3 l 50 l 260
4 l 1300 l 1400


Rows 1, 2, and 3 over lap with one another and I am trying to obtain the starttime and endtime values which can cover them all.

I would like to find the overlapping (starttime - endtime) ranges and accept the lowest starttime value and the highest endtime value.

Row 1: 30--------------------240
Row 2: 40--------------120
Row 3: 50----------------------260
Row 4: ...1300---------1440


I would like to include starttime-endtime ranges that do not overlap with any other integer range.

which in this case would be:

Rownumber starttime endtime
1 l 30 l 260
2 l 1330 l 1400

I was thinking of using a cursor and comparing each row to all of the other rows in the table and then setting a boolean in that row if it overlaps with another row in the table...is there a better way of doing this?

Thank you for the help!

View Replies !   View Related
Date Ranges Overlapping
I've gone cold here. Dunno if I've had too little coffee - as I'm currently drinking some seriously wicked green tea - or whether my brain has locked down from yesterdays "bad eggs for lunch" experience.

Anyway... I have database with a customer, for each customer is a related history table with assigned consultant.

The assigned consultant table has information on consultant id, name, the start date of his assignment and the end date.

I need to find all customers that currently have (or have had) two or more consultants actively assigned. In other words, I need to see if the start/end times overlap.

At my current state, I'm just done.. i can't maintain the perspective... how do I do this?

View Replies !   View Related
Backup Jobs Overlapping
I have 3 seperate jobs to backup my database. 1 for a full backup, 1 for differentials, and the 3rd for the transaction log. Each is on its own schedule. The problem I have is that sometimes the transaction log job will try to start while one of the other two are in process. When this happens, an error is generated and I get paged (which is very anoying at midnight) Is there any way to block the transaction job until the other two are complete? It should still run, just not at the same time.

View Replies !   View Related
Finding Overlapping Dates
Hi all, I'm having some real problems with this little problem.

Basically I have a booking system. I enter a booking which runs between these two dates:

27/03/2007 10:00:00
to
27/03/2007 18:00:00

Now, I need to search for people in the db who aren't already booked within this time frame so if someone has a booking of say:
27/03/2007 05:00:00
to
27/03/2007 13:00:00

they will not be eligable as the dates overlap.

I was thinking of having a function which I pass the 2 new booking dates to and then make sure the candidates existing bookings don't overlap...so basically a function checking that 2 date ranges don't overlap.

Can anyone shed any light on this!?! It's driving me round the bend.

View Replies !   View Related
Pull Overlapping Fields
Hello,
How can I create a query that pulls all records for a given ID (road) where the distances (based on start & end fields) overlap?

Eg. RoadNm Start End
Road 1 0 500
Road 1 300 800
Road 2 0 500
Road 2 500 800

I need to write SQL that flags Road 1 as a road with overlapping sections (whereas Road 2 is fine).

Thanks!
Amber

View Replies !   View Related
Overlapping Images And Rectangles
 

Hey
I am trying to create a report where I want overlapping images and rectangles... but when I upload it to report manager it seems to push them all seperate??? How do I stop doinh this... it does print okay! Just looks wrong on screen?
 
Thanks
 

View Replies !   View Related
Overlapping Point Labels
I am showing some data in a table, and to show the data visually it is shown in  a bar chart. Normally this works quite well:

http://img521.imageshack.us/img521/1936/workinglabelsdw8.png
However, if the data points are too close, the labels will overlap

http://img265.imageshack.us/img265/4989/brokenlabelsnx9.png
What do I do to space out the labels in the bottom image so they are readable?

View Replies !   View Related
Preventing Overlapping Data Entry
Hello Everyone,
 I have a web form that allows the user to select a time to reserve.  I am trying to make it so that when a user selects a date to schedule something (which i have working) a drop down list will fill with times that have not been reserved. 
The data is stored in two tables: tblCalendar and tblTime.  tblTime contains pkTimeID and times (which are all possible times to select from in half hour intervals). tblCalendar contains a few fields but timeID and date (which is in the format M/d/yyyy) are what I need to test against.  timeID is the foreign key of pkTimeID. 
Basically when the user selects the date, a function gets called that will run a SELECT statement to get the times available.  All of this works, I am able to fill the ddl with all times available no matter what the date is or what has already been reserved.  I want to check if a time has been already selected based on the date selected by the user and only allow times not selected to be listed.
 After acheiving this I would like to prevent the immediate time before and immediate time after from being displayed because each reserved time will last for one hour but the data is stored in half hour increments.
Any help/suggestions/links will be greatly appreciated.  If I need to provide anything else please let me know.
Thanks in advance,
Brian

View Replies !   View Related
Calculating Hours With Overlapping Times
All,I have a table with start and end dates/times in it, and would like tobe able to calculate the number of hours represented, accounting foroverlapping records.Note that I am looking for an answer on HOW to do this--I don'tnecessarily need it to be written for me (although it would not gounappreciated!).CREATE TABLE [dbo].[session_temp] ([session_pk] [int] IDENTITY (1, 1) NOT NULL ,[date_start] [smalldatetime] NULL ,[date_end] [smalldatetime] NULL) ON [PRIMARY]GO--These values make a very simplistic example,--as they only represent one--session,so using min and max would work in this case,--but would not work if there--were multiple sessions involved.--hopefully you get the idea of what I am going for:INSERT INTO session_tempVALUES('4/4/04 9 pm','4/4/04 10pm')INSERT INTO session_tempVALUES('4/4/04 9 pm','4/4/04 10:30pm')INSERT INTO session_tempVALUES('4/4/04 9 pm','4/4/04 10:45pm')INSERT INTO session_tempVALUES('4/4/04 9 pm','4/4/04 11pm')INSERT INTO session_tempVALUES('4/4/04 9 pm','4/5/04 2am')--the query I am looking to write would return "5"--the one below obviously does not do what I am looking forSELECTSUM(CAST(DATEDIFF(ss,date_start,date_end) AS NUMERIC(8,2))/3600)FROMsession_tempThanks very much for any insight.Phil---Check out my poker-only weblog at:http://www.livejournal.com/users/chicago_phil/Download my session-tracking spreadsheet at:http://www.geocities.com/fibby70/

View Replies !   View Related
Comparing Two Date Periods For Overlapping
hi guys,

i have a booking table which has the following columns...

booking
-------------------------------------------
dCheckin (format 11/9/2006 12:00:00 AM)
dCheckout (format 11/11/2006 12:00:00 AM)

when a new booking is entered, we want to make sure that the period entered does not conflict with an existing record.

not sure how to go about building the query required. any help would be greatly appreciated.

mike

View Replies !   View Related
Finding Completely Overlapping Segments
ok folks, I need help.

Here's the table and some sample data:


declare @t table
(
segment int,
subsegment int,
primary key (segment,subsegment)
)
insert @t
select 1,33 union all
select 1,22 union all
select 2,33 union all
select 2,22 union all
select 3,33 union all
select 3,22 union all
select 3,44


What I want is to find all segments that are in some sense complete duplicates of other segments. a segment is made up of subsegments. a subsegment is not a segment - it's a completely different entity. this table is not hierarchical.

So in the sample data above, segments 1 and 2 are dupes because they share exactly the same subsegments: 22 and 33. Segment 3 is not a dupe because it has a third subsegment the other two don't have: 44.

when a duped segment is found, I need to know which other segment it duplicates. so an acceptable result set for the above sample data would be:


segment partner
------- -------
1 2


this would also be fine:


segment partner
------- -------
1 2
2 1


ps: i already posted this on dbforums - just broadening the audience a little.

elsasoft.org

View Replies !   View Related
Overlapping Partitions And Join Filters
I am using Sql 2005 and merge replication with push subscriptions. I have several dynamic join filters on some of my tables.

The join filters all use a central table that maps say a server location name (something that is returned from HOTNAME() in my case) to an for a store branch ID. This is a retail system database.

When I add a new new subscription I update this table with the new server location name and it's corresponding branch ID. My filtered tables all have a foreign key in them that is the branch ID. I can then effectively join from the server location name to a Branch ID.

What I have noticed is that if I update one row in the map table, sql server will re-generate all partitioned rows for all subscribers, even for rows that haven't been updated.

The net result is that when I add a subscription, my existing subscriptions all get about 52,000 row updates.

Am I seeing this because I said my partitions will overlap when I created the table articles?

Thanks for any help

Graham

View Replies !   View Related
Text Overlapping In Firefox Preview
Hi,

The firefox preview comes totally messed up.One line overlapping over the other

In my report i have a table in which a row has 5 text boxes.
the 3rd and 5th text box has can grow property set to true.
i have tried placing the text boxes into rectangles but no help there.
the text in that row still over laps .
does anyone have any other fix for this?
 
Somiya

View Replies !   View Related
Question On Copying Over Overlapping Data From One Database To Another...
... and preserving the relationships.(Note, this is more of a SQL question than a SQL-related ASP.NET question...)Say I have two databases, D1 and D2, with the same three tables:CompaniesDepartmentsEmployeesWith the standard one-to-many relationships down the line, with eachtable having a PK, IDENTITY field like CompanyID, DepartmentID, andEmployeeID.I have a smattering of data in each of D1 and D2 for these tables withoverlaps in the ID field values. What I want to be able to do is copyover D1's data to D2, preserving the relationships in D1 even thoughthere are ID overlaps in D2. So the tool I'd use would have to besmart enough to check for ID dups in D2 and appropriate change the IDvalues in D1's tables, maintaining the relationships.Is there some built-in SQL tool to do this or do I have to do this myself?Thanks!

View Replies !   View Related
Overlapping Start Date Sql Server 2000
I'm new to sql. Can someone help me to write a script to select overlapping start dates for each client records.
For example:
Clientid 1 have 3 episode as below(I only want to see the first two records with overlapping start date records)

clientid StratDate EndDate
1 2004-01-01 2004-05-01
1 2004-04-01 2004-05-01
1 2005-04-01 2006-01-01


Table create

CREATE TABLE [dbo].[TABLE_TEST] (
[Client_ID] [varchar] (15) COLLATE Latin1_General_CI_AS NULL ,
[STARTDate] [datetime] NULL ,
[ENDDate] [datetime] NULL ,
)
GO

INSERT

INSERT INTO [TABLE_TEST]([Trust_Wide_ID], [STARTDate], [ENDDate])
VALUES('1','2004-01-01','2004-05-01')

INSERT INTO [TABLE_TEST]([Trust_Wide_ID], [STARTDate], [ENDDate])
VALUES('1','2004-04-01','2004-05-01')

INSERT INTO [TABLE_TEST]([Trust_Wide_ID], [STARTDate], [ENDDate])
VALUES('1','2005-04-01','2006-04-01')

INSERT INTO [TABLE_TEST]([Trust_Wide_ID], [STARTDate], [ENDDate])
VALUES('2','2004-06-01','2004-07-01')

INSERT INTO [TABLE_TEST]([Trust_Wide_ID], [STARTDate], [ENDDate])
VALUES('3','2004-09-01','2004-010-01')
Go

Thanks for help

Husman

View Replies !   View Related
Identifying The Non-overlapping Portion Of Two Date Spans
I need to identify time spans where members identified as having a condition have NOT had any of 5 specified services in the past 12 months.  I have a table (DiabStrata) that identifies time frames for which my data shows a member as having the condition, and I have 5 separate tables with the dates of the relevant services.

I can easily identify when a member hasn't had the service at all, or is lacking it at the start or end of the time frame for which they have the condition, but I'm hitting a wall on how to deal with gaps between the minimum and maximum identification dates.





Code Block

create table dbo.DiabStrata(memberid char(11),Strat tinyint, StratStart datetime, StratEnd datetime)




create table dbo.hba1c(memberid char(11),dos datetime)




insert DiabStrata(
select '1',1,'20060101','20070302'
union
select '1',1,'20070803','20080804'
union
select '2',1,'20020101','20080503')


insert hba1c(

select '1','20060301'

union

select '1','20070301'

union

select '2','20050101')






--Missed Service
Begin
select * into #eval from DiabStrata where strat=1

delete #eval
from #eval left join hba1c on #eval.memberid=hba1c.memberid where hba1c.memberid is null
--repeat for other indicators

update e
set stratstart=min(dos)
from #eval e join hba1c on e.memberid=hba1c.memberid
having min(dos)>stratstart

update e
set stratend=max(dos)+365
from #eval e join hba1c on e.memberid=hba1c.memberid
having max(dos)+365<stratend

delete from #eval where stratstart>stratend
--repeat for other indicators
Desired output is into DiabStrata with a strat of 2 for the time frame for which they have strat 1 but do not have all 5 services within the prior 365 days.
MID Strat StartStrat  EndStrat
1     2     1/1/06 - 2/28/06
1     2     3/2/08 - 8/4/08
2     2     1/1/02 - 12/31/04
2     2     1/2/06 - 5/3/08

View Replies !   View Related
Can I &&"freeze&&" The Leftmost 2 Columns When Scrolling Horizontally?
Hello,

I have a very wide report that uses a table control.  I would like to "freeze" the two leftmost columns so that they remain visible when the user is scrolling horizontally (sideways).  Is this possibe?

Thanks,

BCB

View Replies !   View Related
BCP Out And Headers
I'm no dummy when it comes to this stuff but for the life of me I can't figure out how (if it is possible) to get column headers to go when exporting data. Here is the syntax I'm using:

BCP "select ATSCLAIMNUMBER, ALTERNATECLAIMNUMBER, LNAME , FNAME, MNAME, convert(varchar(10),LOSSDATE,101), convert(varchar(10),ERNOTIFIEDDATE,101), convert(varchar(10),CLOSINGDATE,101), STATUSCODE, INDPAID,MEDPAID,REHABPAID,EXPPAID,LEGALPAID,TOTALP AID,INDFUTURERES,MEDFUTURERES,REHABFUTURERES,EXPFU TURERES,LEGALFUTURERES,TOTALFUTURERES,EXCESSRECOVE RY1,EXCESSRECOVERY2,EXCESSRECOVERY3,EXCESSRECOVERY 4,EXCESSRECOVERY5,EXCESSRECOVERY,OTHERRECOVERY1,OT HERRECOVERY2,OTHERRECOVERY3,OTHERRECOVERY4,OTHERRE COVERY5,OTHERRECOVERY FROM ##MMAACTUARY" queryout C:mma03182004.TXT /c /t, /r /U demo /P demo /S ATSDEVATS2K

It spits out the file fine. This is all built with dynamic SQL and needs to email the file which is does perfectly. My only problem is that there are no headers which I can't have. Any suggestions?

View Replies !   View Related
Getting Column Headers
Is there any way to retrieve the column header name along with your query data?

View Replies !   View Related
DTS Headers And Trailers
Does anyone know how to incorporate header and trailer info in the text output from a DTS task. The SQL I'm using in the task works well when outputting to a text file on the server. However, when trying to incorporate header and trailer info the process fails. I tried doing it using SQL but the DTS transformation process is looking for fields to transform when I'm trying to output a 3 line header and 2 line trailer with the output rows in between. Has anyone done this before? Your help would be greatly asppreciated.

Here is an example of the SQL that fails:

*** Trying to get header info here ***
select 'Header'
select 'filename.txt'
select convert(char(11),getdate(),101)

*** Main SQL runs here ***
select
a.field1,
a.field2,
...

from tblA a JOIN tblB b ON b.someid = a.someid
JOIN tblC c ON c.someid = a.someid

where a.someval >= '2003'

*** Trying to get trailer info here ***
select 'Trailer'
select ''
select count(id) FROM tblA

View Replies !   View Related
Headers And Footers
Hi all,

I am sure this is an easy question but I cant work it out.

I need to output the results of a table to file. I have set up a job to do this, as it needs to be updated every night.

I just do a select * from table

Howerver I dont want the coloum names at the top or the -------'s or the (1) rows bla bla

Bit.

Any ideas?

Dave


Dave Dunckley says there is a law for the rich and a law for the poor and a law for
Dirty Davey.

View Replies !   View Related
Headers And Groups
 

How do I put information only at the top of a page and have it change whenever a group occurs. 

 

I want to do something like this.  Have this on the top of every page:

 

Country:   current country

State:  current state

City:   current city

 

There is a group on country, state and city.  Whenever city changes the next page will display a new city.  Whenever state changes the next page will display the new state in the header. 

 

I have already put Country, State, and City into their own group headers.  However, if either of them change in the middle of the page then the group header repeats.  I have group header repeat on so I can see it on each page.  If I choose the Page break at start then it breaks but I don't want it to break.  I want it to run on the same page if it passes a group and then have the next page display relevant information for the group.

 

Putting it in the table header works as far as keeping them all on the top of the page but it doesn't change when a grouping ends. 

 

Please assist me in anyway you can. 

 

Thanks,

 

Sarah

 

View Replies !   View Related
Fix Column Headers
This is a serious bug in SQL 2005 SP2.

I am working in Reporting Services SSRS 2005. I have a report which takes in parameter and generates a result based on those parameter.i have fixed first two column headers (ABC and BCD) so that the user can scroll left and right keeping those columns fixed.

Now my issue is: for some reason if i scroll left-right on a generated report. The Values in the displayed value in the fixed field drop one row down or up, which is not the correct result shown to the user. Please guide me as what am i doing wrong here. I already have made can grow property to false for all my cells

Thanks

View Replies !   View Related
Sortable Headers
 

Hi,
 
I am having a matrix element in my report with two row groups and one column group.
In column group i have the month names from jan to dec. I want the headers to be sorted on these month names.
 






 
 
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sept
Oct
Nov
Dec

RG1
RG2
X
X
X
X
X
X
X
X
X
X
X
X

 
RG2
X
X
X
X
X
X
X
X
X
X
X
X

RG1
RG2
X
X
X
X
X
X
X
X
X
X
X
X

 
RG2
X
X
X
X
X
X
X
X
X
X
X
X

RG1
RG2
X
X
X
X
X
X
X
X
X
X
X
X

 
RG2
X
X
X
X
X
X
X
X
X
X
X
X

RG1
RG2
X
X
X
X
X
X
X
X
X
X
X
X

 
RG2
X
X
X
X
X
X
X
X
X
X
X
X

RG1
RG2
X
X
X
X
X
X
X
X
X
X
X
X
 
 
Here X is the measure. I want if the user click on Jan the measure values should be sorted in the Jan column and similarly for all the months.
 
How can i achieve this?
 
Regds,
Rohit

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved