Scrolling Column Headings

Nov 30, 2007

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 6 Replies


ADVERTISEMENT

SQL DTS Source Without Column Headings

Mar 3, 2004

If the SOURCE doesn't have column headings in a txt file (the format will be pipe delimited), how can I make it work (Through DTS) to load the source into my designed SQL Table? Thanks in advance!

Jqiu

View 4 Replies View Related

Using Records As Column Headings

Sep 22, 2006

This may be a stupid question, but I have a table of orders that consists of various data. I want to take by date all orders that have been completed but have not had a previous order in 180 days. I have this part done. What gets returned is Date, Count, Status. What I want to get is the various status's returned as headings. So I get Data, Total Order Count, Completed Count, Abandoned Count, etc. I'm returning this data to Excel for display. My original thought was seperate queries, but some of the data will not have a count so the ordering would be off. Any ideas?

View 3 Replies View Related

Force IS To Use Column Headings

Feb 2, 2006

Hi,
I've got an IS package which reads a lot of records from a text file and loads that into the database. The text file has column such as Firstname, Lastname, phone number etc and same as the database table.

The problem:
IS works fine if I have the text file columns in the same order as the database columns but for example if have phone number in the place of firstname (in the text file) IS puts the phone numbers as firstname in the database and moves all the columns dow the order.

Is there anyway I could force IS to use the heading names in the text file and put it in the appropriate database columns?

Thanks guys...

View 4 Replies View Related

Dynamically Changing Column Headings

Feb 5, 2008

We have a query in which we have data in fields called TS1Min, TS1Max, TS1Avg, TS2Min, TS2Max, TS2Avg etc.

We have a different table in which we define that vale of TS1, TS2, as an example TS1 might equal RED, TS2 might equal BLUE.

We have written a query that puts TS1Min, TS1Max, TS1Avg, TS2Min, TS2Max, TS2Avg in a temp table #TEMPA

and we also put the values of RED and BLUE in another temp table #TEMPB

now we want to select * from #TEMPA but rename the headings TS1Min to display RED-TS1Min, TS1Max as RED-TS1Max, TS1Avg as RED-TS1Avg etc...

any ideas on how to do this

View 4 Replies View Related

Looking For A Way To Turn Column Headings Into Rows

Apr 2, 2008

I am relatively new to SQL and have experience with relatively simple queries and data manipulation. I have just finished creating a fully normalized database, which, of course, is presenting me with a few problems retrieving data. I'm not sure if I'm even taking the right approach. Anyway, I am trying to create a web search with a filter. I want my filter to be based upon different columns in a view, rather than rows in one column. I have the following columns:


Emp_Title, Department_Name Company_Name Office_Location, Practice_Area_Name, Practice_Group_Name, School_Name, Emp_Zip_Code

I want to populate a drop list with these column headings. So I thought I would need a way to make a dummy column named Category or something, and then make each of these columns a row in the the Category colum. Can that be done?

Any help would be appreciated.

View 3 Replies View Related

Is There A Feature In RS2005 For Using Different Languages In Column Headings?

Nov 16, 2007

we'd like our users to have the option of choosing the language (eg French) for column headings (maybe report heading too). I'm sure I'd have to provide the translations somehow but I'd like to know what feature, if any in RS2005 comes the closest to doing/supporting this, even if it is something like making column headings themselves dependent on a variable?

View 5 Replies View Related

Isqlw - Suppressing Column Headings In Output Files

Jun 5, 2001

I'm using isqlw to generate delimited text files from scripts. There are several SET options available so that you can restrict the output to just the data in the script, for example SET NOCOUNT ON.

I can't find a similar SET option to suppress the column headings, although there is a tickbox that allows you to do this in Query Analyzer (Query -> Current Connection Options -> Advanced -> Print Headers)

DTS packages appear to support this, yet I can't find the setting from a dts file.

Thanks,

Paul

View 1 Replies View Related

Cannot Copy Field Names In Column Headings From View Results

Jan 8, 2007

When I am using a SQL Query I have an ability to control whether or not I am able to Include the Column Headers when copying or saving results.

The control exists in the Options > Query Results > Results to Grid > Include column headings etc.

My question is how to get this same ability when attempting to copy the results of a VIEW vs. a Query.
The idea is that when I setup a view it€™s a drag/drop type of query building (query building for dummies if you will). Once I have a view and click the Execute icon it will return all the records selected by the View. However, when I click the upper left/top box to select all rows and column and then try to copy/paste the records into Excel all the data copies just fine but the field name/column headers are not there.
How can I get the header fieldname date to copy/paste from View result set that I'm able to copy from a Query result set?
Thank you,
Mike

View 1 Replies View Related

Problem With MSAccess And Executing A DTS Package Via VBA - Returns Column Headings Only

Jan 31, 2007

I wonder if anyone can help with this. I have searched around and not found much on the topic which can resolve my problem.

History on the reason for using VBA and not C# or VB or VB.net etc. Whn I arrived at this company, there were no development tools so had to resort to Access and VBA. Of course, the routines I wrote are now set in production and I haven't had much time to convert them to c# and ASP.NET (which I have learnt over the past couple of years).

Anyway the problem is that I found on the SQLDTS.com site that I could in fact create and execute DTS packages within VB and followed the examples and got this working in VBA. Of course I created the DTS first and then saved it as VB, then used the resulting code with the VBA project etc etc. This worked well and we were happy.

The DTS packages I create and execute are to export data from SQL2000 tables to tabs in Excel spreadsheets.

Now I find that on my machine, when the objPkg.execute command runs, the Excel file is created but only the query column headings are populated into the excel file. No data is returned.

If I run this on a different machine it works (although having said that, the other machine is now starting to display similar behaviour on some routines).

we created a version of the Access 2000 MDB in Access 2003 some time ago and the Access 2000 still behaves correctly. The strange thing is that my machine has only started doing this incorrectly a little while ago (not sure how long now but could be as little as a couple of months). The routines are monthly processes so it's only going to show up as a problem once a month so the fact that it used to work on my machine and has only failed the last couple of times means that something must have changed on my setup. I am runningXP-Pro SP2 - fully patched, Office Pro 2003 and talking to SQL 2000 SP3a

is it possible that some windows updates or office updates are clobbering something which used to work?

If I allow the VBA to create the DTS but not execute it, I can execute the created DTS manually from SQLEM and it outputs data correctly.

No security access to the SQL databases/table has changed, nor have there been any changes to security on the file system where the files are written.

It's weird.

Any help would be gratefully accepted.

Annabel



I'm really lost and not sure whether I should look at driver versions, ODBC versions blah blah

View 1 Replies View Related

SSIS Database Table To Flat File Destination With Column Headings

Sep 8, 2006

Hi,

I have a simple enough task to complete that I can€™t seem to find the answer to.

The task is this €“

Select table x from the database and write it to a flat file complete with that tables column headings.

Now I€™ve managed to set up an ole db datasource and selected the table and I€™ve also linked it to the flat file output.  So now I can generate a flat file from the database.  However no column headings appear in the flat file. 

I can€™t seem to find anywhere (like a checkbox) that will also output the column headings to the flat file. 

Now I can add in Headings manually in the properties of the Flat File Destination object but the columns that appear in the flat file don€™t appear to be in the order that I requested them in the SQL.

So the question is how do I automatically have the column headings appear for flat file output (ideally without me having to manually add them in).

If it can€™t be done and I have to use a vb.net script instead then would anyone have an example script of how to do it?

Thanks in advance for anyone who manages to answer this.

Matt.

View 6 Replies View Related

Reporting Services :: Fixing Ssrs Report Table Column Heading While Scrolling Is Not Working In Report-viewer?

Dec 14, 2012

i just clicked on Advanced mode in Column Group, and then in Row Group Side i set Fixed Data=true for first  top static. I'm using local report not server report and i'm displaying that local report in Reportviewer. Now also its not working....

View 6 Replies View Related

Reporting Services :: Saving Report With Taller Column Headings To Excel Cuts Off Taller Headers

Nov 20, 2015

we are running 2014 enterprise. A couple of column headings (even with smaller font) are a little tall, as much as 6 "lines".   All headings in the respective matrices are aligned vertically as "bottom".  When I save the report to excel, these taller headings get chopped off visually in their excel cell.   The cell contains the entire heading.  It appears that the second "line" of the heading is the one that is most visible in excel. 

How do I get these to be saved so user will see entire heading when opening excel doc? In the first matrix there is a text box directly above the matrix and only one row of column headings.  In the second there is a higher column group heading containing month name above the problem headings. 

View 4 Replies View Related

Matrix Scrolling Headers

Oct 24, 2007

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

Scrolling Group Header

Jul 25, 2007

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

Headers Overlapping When Scrolling Down The Report

May 16, 2007

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

How To Keep Header Remain Visible While Scrolling

May 7, 2007

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

Can I Freeze The Leftmost 2 Columns When Scrolling Horizontally?

Mar 26, 2007

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

Columns In FixedHeader Section Grow Taller During Scrolling - Why?

Nov 16, 2007

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

Design Prob:parent/child W Different Headers: Sorting, Non Scrolling Header Etc

Sep 24, 2007



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

BCP - Output With Headings

Jun 13, 2007

Does anyone know how to output the contents of a table via BCP utility to a file WITH the column headings?

Thanks in advance,
--Alla

View 5 Replies View Related

Get Field Headings?

Mar 17, 2004

I use the following to get the column names from a table but it is giving the error "Incorrect syntax near the keyword 'Where'"

Here is the Stored Proc:

CREATE PROCEDURE usp_GetTemplatePrompts

@cCode varchar(5)

AS

declare @cTableName varchar(100), @iError int, @cError varchar(255)

SELECT @cTableName = s.TableName
FROM tbShapes AS s INNER JOIN tbProductCodes AS pc
ON s.Shape = pc.fkShape
WHERE pc.Code = @cCode

SELECT @iError = @@Error
if(@iError = 0)
BEGIN
EXEC('SELECT * FROM ' + @cTableName + ' WHERE Template = 0')
SELECT @iError = @@Error
END

if(@iError <> 0)
BEGIN
set @cError = 'Error while attempting to get input fields for product ' + @cCode + '.'
RAISERROR(@cError, 16, 1)
END
GO


The table structure is as follows:


tbProductAccounts
Account (PK) | Description

tbProductCodes
Code (PK) | fkAccount | fkShape | Description

tbShapes
Shape (PK) | TableName | ShapeName

tbDoubleT
Template (PK) | fkCode | SectionName | Width | Height | Flange

tbRectangular
Template (PK) | fkCode | SectionName | Width | Height

tbCircular
Template (PK) | fkCode | SectionName | Radius

tbTSection
Template (PK) | fkCode | SectionName | X1 | Y1 | X2 | Y2



Any ideas?

Mike B

View 1 Replies View Related

Csv Export Without Headings

Jan 15, 2007

Hi,

is it possible to export a report to a csv file without the headings?

at best i have been able to hide the headings in the report, but when exported to csv file it includes a row at the top of commas, then the data follows. I need the file to be just the data.

thank.

View 10 Replies View Related

Vertical Text In Report Headings

Oct 30, 2007

Hi,

Is it possible to display Report headings text vertically bottom-up?
It goes from top to bottom by default now, which seems unusual.

Thanks,
Alex

View 1 Replies View Related

Best Practice For Headings Above Dynamic Row Headers In A Matrix?

Dec 28, 2007

what is considered the best practice for placing headings above dynamic row headers if you want them to float with the row headers when scrolling horizontally?

View 8 Replies View Related

Matrix Headings On 2005, Pain In The Neck

Jan 9, 2007

Hello,

I know this is a known issue since SSRS 2000, but it seems that it hasn't been solved: How can I have column headings on a Matrix Report ? (not in the data region, just in the columns that identifies the rows).

All the workarounds and tricks that I have found are quite nasty and have drawbacks when you export to Excel, for instance:

- Using a table inside upper left blank area in the matrix report: Problem, when you export to excel you loose the Header.

- Using an rectangle and placing textboxes (tweaking with pixels... :-(): When you export to excel you get excel columns merged, quite bad if somebody wants to make some macros or calculations).

- Using a list report... well I need a matrix report :-).

Is there other way to implement this ? This is a known issue since 2000 came up, no really a solution available ? I have seen on SP-2 and there is no solution for this issue... please heeelp.

Greetings

Braulio

View 1 Replies View Related

Dynamic Group Headings With Table Groups (Toggle)

Apr 21, 2008

Hi,

I have a SSRS 2005 report with a table and several groupings. These groupings are made visible with toggle items.
I am trying to determine how to make the associated group headings (entered within table header) visible or not visible depending on the visibility state of the groupings.

Example: (initial state with group1 only visible)
Group1 Heading Count Sum
+Group1 999 999

(click + sign to make visible group 2)
Group1 Heading Group2 Heading Count Sum
-Group1 999 999
+Group2 888 888

etc.. for remaining groups

I've tried toggling the table header column the same way I did the group, but the group scope isn't available so I don't know what to use. (Manually putting it in causes report error.)
I don't know what visibility expression to use because I can't figure out what report item I can look at to determine the group's visibility "status" in order to make an expression.

Any ideas?

Note: I did see a similar post from sadsac, but the "answer" didn't address this.

Thanks

View 1 Replies View Related

Report Scrolling Vs. Pages In Report

Feb 8, 2008

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

Integration Services :: Add New Column Based On Existing Column Using Derived Column Task?

Jul 28, 2015

I have a excel file which has a column called "Code" and their values are A,B,C,D,E,F,G,H.  I want to create a new column called "status" based on the values of "Code".

Code:

A
B
C
D
E
F
G
H

If A,C,E,G then "status" = "Active" else if  B,D,F,H then "Status" = "Inactive". I like to do it using "Derived Column".

View 4 Replies View Related

Transact SQL :: Calculate DateTime Column By Merging Values From Date Column And Only Time Part Of DateTime Column?

Aug 3, 2015

How can I calculate a DateTime column by merging values from a Date column and only the time part of a DateTime column?

View 5 Replies View Related

How To Refer A Column When The Referencing Column Is An Identity Column

Oct 16, 2006

Hi all,

The requirement is to have a table say 'child_table', with an Identity column to refer another column from a table say 'Parent_table'..

i cannot implement this constraint, it throws the error when i execute the below Alter query,

ALTER TABLE child_table ADD CONSTRAINT fk_1_ct FOREIGN KEY (child_id)
REFERENCES parent_table (parent_id) ON DELETE CASCADE

the error thrown is :
Failed to execute alter table query: 'ALTER TABLE child_table ADD CONSTRAINT
fk_1_ct FOREIGN KEY (child_id) REFERENCES parent_table (parent_id) ON DELETE
CASCADE '. Message: java.sql.SQLException: Cascading foreign key 'fk_1_ct' cannot be
created where the referencing column 'child_table.child_id' is an identity column.

any workarounds for this ?

View 3 Replies View Related

TSQL - Using ALTER TABLE - ALTER COLUMN To Modify Column Type / Set Identity Column

Sep 7, 2007

Hi guys,
If I have a temporary table called #CTE
With the columns
[Account]
[Name]
[RowID Table Level]
[RowID Data Level]
and I need to change the column type for the columns:
[RowID Table Level]
[RowID Data Level]
to integer, and set the column [RowID Table Level] as Identity (index) starting from 1, incrementing 1 each time.
What will be the right syntax using SQL SERVER 2000?

I am trying to solve the question in the link below:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2093921&SiteID=1

Thanks in advance,
Aldo.

I have tried the code below, but getting syntax error...



ALTER TABLE #CTE
ALTER COLUMN
[RowID Table Level] INT IDENTITY(1,1),
[RowID Data Level] INT;


I have also tried:

ALTER TABLE #CTE
MODIFY
[RowID Table Level] INT IDENTITY(1,1),
[RowID Data Level] INT;







View 18 Replies View Related

Alter Table Add Column - How Do You Add A Column After Say The Second Column

Jul 11, 2007



When you use "Alter Table add Column", it adds the column to the end of the list of fields.



How do you insert the new column to position number 2 for instance given that you may have more than 2 columns?



Create table T1 ( a varchar(20), b varchar(20), c varchar(20))



Alter table add column x varchar(20)

so that the resulting table is

T1 a varchar(20), x varchar(20), b varchar(20), c varchar(20)



Can this be done programmatically?













View 33 Replies View Related







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