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


ADVERTISEMENT

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

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

Auto Grow Enabled But DB Won't Grow

Jan 15, 2005

I've been through the forum and read a number of threads on people's DBs not growing and the answer usually is they don't have auotmatically grow data file. Unfortunately I have this on, but when I look at the properties of the database it reports the space available is 0.00 MB? Up until about two weeks ago I was showing appx 48% space utilization. When I ran an SP to show growth, it tells me that it was expanded by 20% yesterday, but SQL Server is still telling me the space available is zero.

The log file is also set for auto growth. The DB is 14.5 GB in size and the drives still have around 92 GB of space.

Has anyone experienced this before? Any ideas? Does anyone know of an SPs that can give me detailed info on internal data file size compared to stated size (i.e. wasted space in data file)? Is SQL Server doing something funny in the way it is seeing the database or data files individually? Any help is appreciated.

View 6 Replies View Related

Display Problem Using FixedHeader

Mar 20, 2007

How do I keep a Page Header visible on screen if, in the Body of the report, a Table exists where the rows need to be scrolled?

View 2 Replies View Related

FixedHeader + ToggleItem-Autoscrolling

Apr 12, 2007

Hi @All,



SSRS offers for a table control the nice feature "Fixed Header" (so called in the Properties Box) or "Header should remain visible while scrolling" (so called in the context Properties Window). This works fine.

SSRS has an other (auto-)scrolling-feature for drilldown, e.g. when you have a long list of data in the first column of a table, that are toggle-items for drilldown and you click on such a "+" sign for drilldown, SSRS scrolls the toggled item to the top position of the table chart controll. This works fine.



But... with both features together SSRS scrolls the row selected for drilldown under the fixed header!

For the user, it looks like the data has gone. They have to undo the SSRS drilldown-autoscrolling to see the data again they have choosen to drilldown.

The bug is that SSRS doesn't substract the header-hight from the top position of the table chart for the new (auto)scrolling position.



Has anyone found the same problem and has a workaround? E.g. can the mechanism of drilldown-autoscrolling be turned off? With what property?



Thanks for any help in advance!



Cheers,



Mobi

View 2 Replies View Related

How Can I Take This Example Flat File And Parse Out Each Section To A New Flat File? Each Section Starts With HD (header Row)

Mar 13, 2006

How can I take this example Flat file and parse out each section to a new flat file?  Each section starts with HD (header row)

http://www.webfound.net/flat_file_example.txt

e.g. an example output file based on above (cutting out the first section) would be:

http://www.webfound.net/flatfile_output.txt

Also, I'll need to grab a certain value in each header row (certain position in the 100 byte header row) to use that as part of the filename that's outputed.  I assume it would be better to insert these rows into a temp table then somehow do a search on a specific position in the row...but that's impossible?  The other route is to insert each row into a temp table separated out by fields but that is going to be too combursome because we have several formats to determine separation of fields based on the row type so I'd have to create many temp tables and many components in SSIS when all we want to do is again:

1) output each group (broken by each header row) into it's own txt file

2) use a field in  the  header row as part of the name of the output txt file (e.g. look at the first row, whcih is a header row in flat_file_example. txt.  I want to grab the text 'AR10' and use that as part of the filename that I create

Any suggestions on how to approach this whole process in SSIS...the simplest approach that will work ?

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

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

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

Keep Section Of Report The Same Size

Sep 21, 2007



I need to keep a section of a report the same size. I have now a table with a detail and group section. The table header must print on every page and the table footer must print on every page. The detail section can only be 16 rows. When I have more than 16 rows the report page breaks perfectly and puts the remaining rows on the next page along with repeating the header and footer. The problem is when there are fewer than 16 rows the table does not take up the full page and looks horrible. All my displayed data is in the data set. I have looked at padding the dataset with bogus rows that would show up at the end and just not display but would rather take care of this on the report end. Any ideas?
Thanks, Chad

View 1 Replies View Related

Textbox In Parameter Section

Jul 11, 2007

Hi there.



I was wondering if anyone has figured out a way to add text up in the parameter section of a report. I wanted to add something like: "Please use this option when you want a full result set" or something of the sort.

Thanks, Mike

View 1 Replies View Related

How Does SQL 7 Grow Databases?

Mar 24, 2000

Hi,

I know that SQL 7 grows databases dynamically, but I'm wondering how it determines how much to grow it by? I have a couple of databases on our servers that are 3.4 GB but with 1.6 GB space available. So I'm wondering when it determines it needs to grow a database and what it does to determine how much to grow it by.

Thanks,
Mike Gagne

View 2 Replies View Related

LDF File Does Not Grow..

Jun 27, 2007

Bear with me - My SQL Server 2005 Maintenance is as good as a Newbie..

I was running a Very Large Transaction over the weekend (Say 10Mill Inserts)..
And after waiting for 3/4 Hrs for the transaction to complete -- Checked the LDF File, I has grown to a 100 GB.

After that i discovered that i had the Recovery Model as FULL .. So Killed the Job and Changed the recovery mode from Full -> Simple.

Now i see that the LDF file is not growing in size even though there are many transactions that were complete successfully (Still Very slow though)...

What am i missing here - Iam clueless as to why my LDF is not growing in size?

Any Ideas??

View 4 Replies View Related

Passing ANY Value To The &<InsertParameters&> Section Of A SQLDataSource

Jun 6, 2007

Ok-I'm new at this, but just found out that to get data off a form and insert into SQL I can scrape it off the form and insert it in the <insertParameter> section by using  <asp:ControlParameter Name="text2" Type="String" ControlID="TextBox2" PropertyName="Text">  (Thanks CSharpSean) Now I ALSO need to set the user name in the same insert statement. I put in a UserName control that is populated when a signed in user shows up on the page. But in my code I've tried:                             <asp:ControlParameter Name="UserName" Type="String" ControlID="LoginName1"  DefaultValue="Daniel" PropertyName="Text"/> and I get teh errorDataBinding: 'System.Web.UI.WebControls.LoginName' does not contain a
property with the name 'Text'. So I take PropertyName="Text" out, and get the error:PropertyName must be set to a valid property name of the control named
'LoginName1' in ControlParameter 'UserName'. what is the proper property value?  SO.....BIG question...Is there a clean way to pass UserName to the insert parameters? Or ANY value for that matter? Id like to know how to write somehting likeString s_test = "test string";then in the updateparameter part of the sqldatasource pass  SOMEHITNG like (in bold)     <asp:Parameter Name="UserName" Type="String" Value=s_test /> Thanks in advance...again! Dan  

View 5 Replies View Related

Display Details Section For Each Group

Jul 2, 2007

Hi,

I want to display details ection for each group in a single table using one dataset.

For ex:



Group 1 Row --> Name Age

Details 1 Row--> XXX 30

Details 2 Row--> YYY 20

Group 2 Row --> City Country

Details 1 Row--> CCC ZZZZ

Details 2 Row--> BBB AAAA

View 3 Replies View Related

Code Section And Including Imports...

May 14, 2007

I am trying to add an Imports statement to the beggining of the custome code section of my report but I recieve this error. There is an error on line 0 of custom code: [BC30465] 'Imports' statements must precede any declarations.



My syntax looks like this:

Imports SB = System.Text.StringBuilder
Imports System.Enum



public function Test ...



end function



Does anyone know if this is even possible and why or why not?



In relation to that, can anyone answear as to why there is a 32K limit on the code section in reporting services?

View 4 Replies View Related

Problem With CDATA Section In FOR XML EXPLICIT

Nov 1, 2006

Hi,
I am trying to create a XML out of sql 2005 database using FOR XML. I
need to create XML for tables which may contain data having
non-printable ascii characters (1-32 ascii character). I found FOR XML
AUTO failes to genrate this XML, but i can genrate XML using CDATA
section in FOR XML EXPLICIT. As following querie works fine for me.


SELECT
1 AS tag
NULL AS parent,
template_id AS [Emailqueue!1!user_id],
misc1 AS [Emailqueue!1!!cdata]
FROM Emailqueue WITH (NOLOCK)
WHERE queue_id = -2147483169
FOR XML EXPLICIT


in above query misc1 column may contain some non printable ascii
characters.


But i need to store this XML data in some sql XML variable as i need to
pass it to store procedure which expects an xml input. While doing
following i gets an error saying "illegal xml character"


DECLARE @XMLMessage XML


SET @XMLMessage = (SELECT
1 AS tag
NULL AS parent,
template_id AS [Emailqueue!1!user_id],
misc1 AS [Emailqueue!1!!cdata]
FROM Emailqueue WITH (NOLOCK)
WHERE queue_id = -2147483169
FOR XML EXPLICIT)


I am doing all this exercise for SQL service broker. For which i even
need to process same message using OPENXML on differen database server.
Again which will need well formated XML.


Let me know if something dose'nt make sense


any help is appreciated


Thanks

View 1 Replies View Related

Alert For Auto Grow In DB

Feb 9, 2000

Hi ,
I have a SQL 7 database in which I have set the autogrow on. I need some way to be notified when the database does an autogrow. The reason for this is that if it does an autogrow once then if I am notified then I can manually expand the DB size without having SQL Server do multiple autogrows. I was looking at setting an alert but cannot find any message in sysmessages that seem to be information types for auto grow. Has anyone done this kind of thing.
Thanks
Venkat

View 2 Replies View Related

Database Grow/Shrink

Jan 13, 1999

OK. Here's a good one.

I wrote a query that caused a HUGE amount of stuff to be written to the transaction log. Since I set the database up before I had enough coffee yesterday, I didn't turn on a "Restrict Filegrowth" on the log. So the transaction ran until it filled up the available space on the drive (my local workstation, so it grew to about 6 GB) and then it rolled back. (BTW: Microsoft finally figured out that rolling back a transaction shouldn't be a blocking operation. ISQLW tells you that the transaction failed as soon as it fails, and then releases the connection to you, so you can go on with your life while SQL Server cleans up. Good one!)

OK. So that done, I figured I'd just truncate the transaction log and do the nifty new "DBCC SHRINKFILE()" thing. So I truncate the log and do DBCC SHRINKFILE. Nothing happens. Enterprise Mangler (OOPS Manager. I really mean Manager) shows that only 43 MB of the 6 GB file is in use. DBCC SHRINKFILE reports that the minimum size is 128 pages, the current size is 697,256 pages, and 697,256 pages are used.

Great. So I can't shrink the file.

Step 2: I dump (OOPS, sorry, BACKUP) the database, delete the database, make sure all the files are gone, and then restore the database. It re-creates the 6 GB file, which, by the way takes a very long time. What's funny about that is the query timer in ISQLW reports that the query took 30 minutes, but the return from the restore command shows that it took about 300 and some seconds (about 5 minutes) because the restore command doesn't count the amount of time it took to build the files (I'm guessing). After I figure out that it rebuilt the 6 GB file, I screamed, and started downloading PostGreSQL for my Linux box, and got on to other projects.

This morning I came in and started reading Books Online to figure out what's going on. It says something about "Virtual Log Files" and how a log can't be shrunk past that point. Great. MS basically defines a virtual log file as "the point past which you can't shrink a log". So I have a 5 GB virutal log file, and I can't truncate it, shrink it, or make it go away.

So I have a stroke of genius and decide to build a new log file in the database, and then use the DBCC SHRINKFILE command with the EMPTYFILE option, and then use ALTER DATABASE to remove the file.

Then I get this really cool error that says:
Server: Msg 5020, Level 16, State 1, Line 1
The primary data or log file cannot be removed from a database.

OK. Last time I checked, a log file doesn't belong to a primary filegroup, so there's something else going on here. Basically, it looks like the first file that gets created is the "Primary" file and can never be removed.

So, new policy, every "first" file in a database is going to be a 2 MB file, with a 2 MB growth limit, so we can remove it later. That's a load of....fertilizer.

It looks like the AutoShrink for logs is just a myth. Auto-Grow seems to work almost too well, though. I'm picturing one of those Access newbies using the Export function in Access to put data into SQL Server on one of our pre-production boxes, and having a 180 GB log that can't be shrunk. That'll be a good time.

The moral of the story: Always set growth restrictions, especially on log files.

The questions:
1. Anybody got any bright ideas on how I can get my disk space back WITHOUT using BCP (or DTS, or similar methods)?

2. Anybody know how a different file can be set as a "PRIMARY" file?

3. Anybody know why MS decided to fill the Transact-SQL help in ISQLW with "You can't get there from here" messages that reference Books Online?

Thankfully, this isn't anywhere in our production system, and if the quality continues this way, it won't ever be in our production system.

chris.

View 1 Replies View Related

Cant Manually Grow Database

Jan 24, 2003

Hardware:
IBM Netfinity 8500
2 processors Xeon 700
1,5 Gb memory
Windows 2000 Server SP2 Build 2195
SQL Server 2000 Standard Edition 8.00.534 SP2
There is only on Database (DB) of 16 Gb in drive G.
Drive G has 32 Gb space free.
Yesterday we appended tables to the database and in SQL logs appears the next error:

2003-01-23 12:26:42.57 spid101 fcb::ZeroFile(): GetOverLappedResult() failed with error 2.
2003-01-23 12:26:42.61 spid101 Error: 1105, Severity: 17, State: 2
2003-01-23 12:26:42.61 spid101 Could not allocate space for object 'ttdssc030104' in database 'MYDATABASE' because the 'PRIMARY' filegroup is full..
2003-01-23 12:26:48.03 spid101 fcb::ZeroFile(): GetOverLappedResult() failed with error 2.

DB configured to grow automatically by 100 Mb and transaction log Automatically grow in 10% .
Unrestricted file grow selected on both.

I try to expand the DB manually by Enterprise Manager to 20 Gb but not work and in SQL log appears the error

"2003-01-23 12:26:48.03 spid101 fcb::ZeroFile(): GetOverLappedResult() failed with error 2."

In Enterprise Manager-Databases-Properties-General-Size of DB maintain 16Gb.
Windows explorer say MYDATABASE.MDB is 20480 MB.

I delete the tables inserted and the problem persist.

Thanks in advance,

View 6 Replies View Related

Automatically Grow File

Jan 8, 2004

Hello everyone,
I have 45 GB db with
-Automatically grow file by 10 %
- full recovery
-log shipping every 5 minutes.
-full backup every 24 hrs

database grown from 33GB to 45 GB for 1 year period
4-5 times a year massive insert
done to database(no specific dates)

if I change autogrow to by 300MB or 4%

1.how would it affect insert process ?
2.how it affect daily performance ?

Thank you
Alex

View 3 Replies View Related

Automaticallly Grow File

Oct 1, 2004

What is the best option to set for File Growth?

Is it in megabytes or by percent?

View 3 Replies View Related

How Data/log Files Grow

Dec 4, 2007

Hi All
i am bit confused about how data and log files grow in databases. suppose i turn off the auto grow and restrict the maxsize upto some limit but size of data/log file is less then maxsize at some stage because what i understand is size of data/log file keep changing depends upon the activities going on the database. in future if data/log file need to grow can it grow upto the maxsize without turing on the auto grow.

regards

View 4 Replies View Related

Auto-increment PK - Use MS Or Grow Your Own ?

Jul 23, 2005

SQL 2000I thought I would throw this out there for some feedback from others.I'd like to know if you feel using MS auto-increment field is a goodsolution these days or should one grow their own ?Thanks,Me.

View 11 Replies View Related

Auto-grow Gotcha

Jul 20, 2005

I made a database to hold recordings of calls made to our customers.When I made it I set the size of the primary datafile to 18GB. It'sbeen running flawlessly for over 10 months. A few days ago the userswere suddenly no longer able to save the recordings to the database.They got an error message to the effect that the timeout had expired.The failure occurred on the .Execute statement of the Command thatcalls the stored procedure.I noticed that the data had reached the size allocated for the file.The file was set to auto-grow (5%). However, since I couldn't findanything else wrong, and since the test version of the database (whichonly has 15GB of data in an 18GB-dimensioned file) did not exhibit thesame behavior, I decided to try increasing the size of the file withan ALTER DATABASE statement. I increased it to 21GB. Lo and behold,the problem disappeared.Here's what I think might be going on: The default timeout for theADO Command object is 30 seconds... this is probably not long enoughfor SQL Server to add 900 MB to the datafile, therefore the Commandtimeout expired. So from now on instead of relying on auto-grow, I'mgoing to just make sure the datafile always has plenty of headroom.FWIW.

View 1 Replies View Related

Sql 2005 Log File Grow Too Much

Oct 9, 2007



Hello,

I'm running a long and heavy query. during the running the log file of the DB is growing more than 20 GB and i'm running out of disk space consequently. Is there a way to restrict the log file size without demaging my query?

Thanks.

View 9 Replies View Related

SQL 2012 :: Configure AlwaysOn Between Two Different Network Section?

Jul 29, 2015

How to configure AlwaysOn between two different network section?

View 2 Replies View Related

Turn Off Documentation Feedback Section Of BO For Printing?

Jun 7, 2007

I wonder is there any way I can turn off the "Documentation Feedback" sectionof the Books Online at the bottom of the pages... I'm printing some BooksOnline pages for own reference.Thanks in advance...--Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forum...eneral/200706/1

View 2 Replies View Related

Want To Display Report Without Header/parameter Section

May 22, 2008

Hi all,

I'm trying to embed a report into a CRM IFrame. So I have the report created in Business Intelligence Visual Studio 2005, but I need to display it with none of the header details SRS displays by default.

Using the following URL I included rc:toolbar=false and rcarameters=false but they don't seem to make any difference. I basically need to display the report content as if it were part of that page and not an SRS hosted page.

https://server/Reports/Pages/Report.aspx?ItemPath=%2fAllpress_MSCRM%2fCustomReportsForCRM%2fa&rs:Command=Render&rc:toolbar=false&&rcarameters=false&rs:ClearSession=true&type=1&typename=account&orgname=Allpress&userlcid=1033&orglcid=1033

Anyone have some pointers for me?


Kia

View 1 Replies View Related







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