Freeze Panes?
Jan 30, 2006Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.
Thanks
ADVERTISEMENT
Freeze Panes
Apr 23, 2008Good Morning,
I want to freeze my colum headings which are in the table header section, can this be done?
Thanks,
Rhonda
Why Does SQL Freeze When I Run This Trigger???
Jun 13, 2002CREATE TRIGGER accountI ON [dbo].[account]
FOR UPDATE
AS
declare @a decimal
declare @b varchar
declare @c varchar
declare @d decimal
declare @e decimal
declare @f decimal
declare @g decimal
declare @h decimal
declare @i decimal
declare @j decimal
declare @k decimal
declare @l decimal
declare @m decimal
declare @n decimal
declare @o decimal
declare @p decimal
Declare tblCursor Cursor for
select begBalance,accountDescription, accountType from account
where accountType = 'Cash' or accountType = 'Accounts Receivable' or accountType = 'Inventory' or accountType = 'Other Current Asset'
open tblCursor
Fetch Next From tblCursor INTO @a,@b,@c
While (@@Fetch_STATUS = 0)
begin
select @d = @d + @a
end
Fetch Next From tblCursor INTO @a,@b,@c
Declare tblCursor Cursor for
select begBalance,accountDescription, accountType from account
where accountType = 'Fixed Asset' or accountType = 'Accumulated Depreciation'
open tblCursor
Fetch Next From tblCursor INTO @a,@b,@c
While (@@Fetch_STATUS = 0)
begin
select @e = @d + @a
end
Fetch Next From tblCursor INTO @a,@b,@c
Declare tblCursor Cursor for
select begBalance,accountDescription, accountType from account
where accountType = 'Other Asset'
open tblCursor
Fetch Next From tblCursor INTO @a,@b,@c
While (@@Fetch_STATUS = 0)
begin
select @f = @d + @a
end
Fetch Next From tblCursor INTO @a,@b,@c
Declare tblCursor Cursor for
select begBalance,accountDescription, accountType from account
where accountType = 'Accounts Payable' or accountType = 'Other Current Liabilities'
open tblCursor
Fetch Next From tblCursor INTO @a,@b,@c
While (@@Fetch_STATUS = 0)
begin
select @g = @d + @a
end
Fetch Next From tblCursorr INTO @a,@b,@c
Declare tblCursor Cursor for
select begBalance,accountDescription, accountType from account
where accountType = 'Long-Term Liabilities'
open tblCursor
Fetch Next From tblCursor INTO @a,@b,@c
While (@@Fetch_STATUS = 0)
begin
select @h = @d + @a
end
Fetch Next From tblCursor INTO @a,@b,@c
Declare tblCursor Cursor for
select begBalance,accountDescription, accountType from account
where accountType = 'Equity-Retained Earnings' or accountType = 'Equity-Not Closed' or accountType = 'Equity-For Closure' or accountType = 'Income'
open tblCursor
Fetch Next From tblCursor INTO @a,@b,@c
While (@@Fetch_STATUS = 0)
begin
select @i = @d + @a
end
Fetch Next From tblCursor INTO @a,@b,@c
Declare tblCursor Cursor for
select begBalance,accountDescription, accountType from account
where accountType = 'cogs'
open tblCursor
Fetch Next From tblCursor INTO @a,@b,@c
While (@@Fetch_STATUS = 0)
begin
select @j = @d + @a
end
Fetch Next From tblCursor INTO @a,@b,@c
Declare tblCursor Cursor for
select begBalance,accountDescription, accountType from account
where accountType = 'expenses'
open tblCursor
Fetch Next From Stock_Cursor INTO @a,@b,@c
While (@@Fetch_STATUS = 0)
begin
select @k = @d + @a
end
Fetch Next From tblCursor INTO @a,@b,@c
insert dbo.financials (totalCurrentAssets, totalPropEquip, totalOtherAssets, totalCurrentLiabilities, totalLongTermLiabilities, totalEquity, totalIncome, totalCogs, totalExpenses, totalAssets, totalLiabilitiesEquity, totalNetSales, totalNetIncome)values (@d, @e, @f, @g, @h, @i, @j, @k, @l, @m, @n, @o, @p)
System Freeze
Jan 2, 2000I am running NT4.0 with sp6 and SQL server 6.5 with sp3 and my system periodically freeze. The CPU shows 100% and Sql does not respond. In the NT event viewer I get a message SQLCTR60 DB-LIBRARY error - SQL Server connection timed out. How do I go about finding out what is wrong.
Thanks in advance!
Betty
All 32bit Connections Freeze...
Mar 2, 1999I'm very new to SQL servers. We're running SQL 6.5-SP4 and have three applications using different databases on the server (NT4-SP3).
App 1. Written in PowerBuilder using 32bit DB_LIB, NWLink IPX/SPX.
App 2. Written in VFP 5.0a using ODBC32, NWLink IPX/SPX
App 3. Written in VB using ODBC16, NWLink IPX/SPX
Something happens, which freezes all 32bit connections and prevents any other 32bit connects. Which means I can't get Enterprise Manager to connect! This does not affect the ODBC16 clients?!?!
So far the only way, I have found, to clear and fix is to get all 32bit users out of their apps and the server becomes available again. There's got to be something to prevent this, any ideas? Is there a way to trace this to find the culprit?
Thank you for any and all help,
Jim
<jpeppercorn@jhcb.com>
Freeze An Index While Updating
Sep 20, 2007Her is what I'd like to do:
- Create and populate a table
- Index it on a 'reference' field
- Then update the table by using the index but WITHOUT updating the index (I'd like to have it available for the WHERE clause but I don't need to updtae it)
- Eventually, i'd like to re-index the whole table
Is that possible?
Thank you for your help...
SQL Server Freeze And Thaw Functions
Aug 20, 2007Hi,
I saw in some websites that there are functions freeze and thaw in SQL server.I want to freeze the SQL server for some time and then use the thaw to unfreeze.I want to know how it could be done in SQL server 2005
Thanks in Advance
Validating Sequence Container Freeze
Feb 16, 2007I am attempting to open up my ssis integration project but when I try to open up packages it says @ the bottom "Validating Sequence Container" and it just stays there. I cannot click on anything and nothing is responsive. Does anyone know why this is happening?
View 9 Replies View RelatedCan I Freeze The Leftmost 2 Columns When Scrolling Horizontally?
Mar 26, 2007Hello,
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
Reporting Services :: Freeze Header Browser
Apr 22, 2015I want the header to be visible while scrolling. After changing on the static Properties FixedData=True, it is working on BIDS and Internet Explorer 11 . But is does not work in Chrome. Most of my users are using Chrome. Is there any way to fix it for google Chrome.
View 2 Replies View RelatedSql Server 2005 Machine Lockup/freeze Up
Mar 25, 2008
Our HP Proliant ML 330 G5 (3.0 Duo Core Xeon, 4 GBs RAM) server is running Windows 2003 R2 Standard 32 bit ( Win SP2) and SQL Server 2005 Standard (SQL SP2 €“ version 9.00.3054.00(Intel X86)). At random times every 1-14 days, our server will lock up. While the Windows Login screen or the standard Windows screen saver is viewable on the server still, the computer becomes completely non-responsive. The keyboard and mouse do not work and we can no longer connect to the server via a Terminal Service connection. We are able to ping the server while it is locked up though. The only way to get the server back up and running is by doing a hard power down and then power it back up.
Upon getting the server back up and running, everything goes back to working as normal with both Windows and SQL. There is nothing in any of the event logs indicating any type of issue prior to the server locking up. We are really at a loss on where to start troubleshooting this. We have no reason to think it is a hardware issue at this point but are not ruling that out.
Any ideas what we can do to start tracking down the cause of this problem?
Count Up Based On Unique Value -- Brain Freeze
Apr 17, 2008
Ok... I know this is something that I've seen and probably done before....
I have a value that will show up multiple times in a table. I want to order the table by that value and then count up from 1 to however many items that it shows up as.
The example below shows the results I want. Value1 and Value2 are in the table, LineNumber is what I need to generate.
Value1
Value2
LineNumber
1
Hey
1
1
Can
2
1
Someone
3
1
Help
4
1
With
5
1
This
6
2
Very
1
2
Simple
2
2
Issue
3
2
As
4
2
I
5
3
Have
1
3
A
2
3
Brain
3
3
Freeze
4
--Thanks--
I Need Help With Cleaning A Phone Number Column, Brain Freeze
Feb 26, 2002For anyone who can help me resolve this minor data issue. I am trying to clean a phone number column so that all numbers are reflected in the same way. I have phone numbers in my column in this this format:
(123)123-1234
123-123-1234
(123) 123-1234
How can I clean this column so that the numbers are reflected in this way: 1231231234
I'm having brain freez right now. Help me please!!! Thanks in Advance
Reporting Services :: Freeze Headers While Exporting Report To Excel?
Sep 17, 2010How can i freeze the headers while exporting the report to excel? will this works in ssrs 2008 / 2008 r2?
View 2 Replies View RelatedTransact SQL :: Adding Database - Single User Mode Freeze
Oct 5, 2015I would like to add database to single user mode to enable broker. So, i have tried this:
ALTER DATABASE myDb SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE myDb SET ENABLE_BROKER
ALTER DATABASE myDb SET MULTI_USER
But the query works more than half an hour then i have stopped it. i guess it has infinite loop, I get also many of this messages:
Nonqualified transactions are being rolled back. Estimated rollback completion: 0%.
There is no other transaction also there is no other user connections. So, what happens?