How do I set the maximum vertical size of a table I would like to set it based on total vertical size in inches or a maximum number of rows returned.
Thanks for any help.
Brad
Maximum height for table
SQL Server Reporting Services
-
- Previous
- 1
- Stored Procedure Performance Degrading Dramatically when accessed through ADO.NET This was also my best guess as to what is going on here but I'm not totally convinced, as although the data is being continually updated, a very small percentage of rows will be affected over a period of just 24 hours. I will set the WITH RECOMPILE option and I'll flag this as being the answer if it's still working efficiently by tomorrow morning. Thanks for your contribution. Phil Tag: Maximum height for table
- 2
- Need help from someone who is an expert w/t-sql OK. I did put together a mock-up, but it is definitely wrong. I can't give a good look at this until tomorrow. About how many rows do your two tables typically contain Also, how frequently does this query get executed and does this query need to be optimized as if it is a critical feature Dave Tag: Maximum height for table
- 3
- using alias in a view Hi How (if i can) can i use a alias in my view if i have 1 alias total and a alias Moms can't i then have a nother alias there say total+moms Or shall i write all again in another alias Alvin Tag: Maximum height for table
- 4
- Calculated Member banding Thanks again for the response. I'm having a little bit of a problem getting my head around what needs to be done. The problem initially is probably not completely understanding what i want to do. Taking your advice on board, i'll look into other methods aside from the calculated measure on the CustomerSite dimension. My fact table for visits has a default 1 column for basing the aggregation on so i cannot calculate in this table the bands. If i have a seperate dimension; presumably this would consist of a key column and a column stating the band i.e. Key Status 1 300+ visits 2 200 to 300 visits . . . etc... The problem i have with getting my head around this method is where is link my dimension to; i cannot include the key in the fact table as i don't know at that stage how many visits are made to a specific customer for a selected date range. Do i not still need to link on the measure value that is returned at the chosen levels. I'm sorry if i'm not explaining this very well; this is a slightly steep learning curve at present. Thanks again, Grant Tag: Maximum height for table
- 5
- Sqlserver In Oracle to handle the general exceptions we will write the program as procedure raise_exc(i number,msg out varchar) as i_exc exception; begin if i>10 then raise i_exc; end if; exception when i_exc then msg:='Value of i <10'); end; / In case of Sqlserver program how to raise these type of exceptions and how to handle it Tag: Maximum height for table
- 6
- Transparent Encryption Is there a way to encrypt the values in a table so that when authorized users do a select * from table they see the unencrypted values Tag: Maximum height for table
- 7
- Matrix grouping I have a report with the Month attribute as the column group and specific measures as the row groupings. Now, here's my delima. The months are not being displayed in order. They look like this: Jan Feb May Jun Jul Aug Sep Oct Nov Dec Mar Total Why is it doing this Here's a view of my matrix in layout view... Month_Name Fatal Crashes =sum(fatal_crashes.value) Injury Crashes =sum(injury_crashes.value) Property Damage =sum(Prop_Damage.value) Total Crashes =sum(Total_crashes.value) Chicago Crashes =sum(Chicago_crashes.value) Crashes Located =sum(located_crashes.value) % Located =sum(percent_located.value) any help would be greatly appreciated!! THANKS! Tag: Maximum height for table
- 8
- How to backup CE database Tables and restore to newer database? I am fairly new to VS 2005 and SQL Server CE. I have developed a Desktop Windows application using VB 2005 and the SQL Compact Edition Database. This application will sell to users via web download. When they download a service patch, or updated version, I wish for them to retain the data in their present database. In other words, fill the new database with the old data. The new table structures will remain intact except for added columns at the end. Question is how to save the old data and update the new database with it. Is there an easy way to do this, or do I need to write a module to save a database copy, and update the new database with content at install time Tag: Maximum height for table
- 9
- Adding CRLF to nvarchar(max) column text A better choice when searching for an imbedded character string is CHARINDEX. You would pass a declared Char (or NChar) variable initialized with the value for which you're searching. REPLACE is more elegant... Be sure to backup your data beforehand. Tag: Maximum height for table
- 10
- EncryptSensitiveWithUserKey - question As an example, if you use an XML configuration to set your connect strings, you can edit the configuration to include the password in the connection string. You have to do that outside of Visual Studio, because it will strip the password out by default. Then you just secure the folder that the configurations are stored in. I use the file system primarily. I find it easier to deploy to, but it's mostly personal preference. Tag: Maximum height for table
- 11
- @@FETCH_STATUS Reset You can use the function to fetch this data.. Sample., Code Snippet Create function dbo . TotalBusinessDays ( @Start datetime , @End Datetime ) returns int as Begin Declare @Result as int ; Set @Result = 0 ; While @Start <= @End Begin Select @Result = @Result + Case When datepart ( weekday , @Start ) in ( 1 , 7 ) Then 0 Else 1 End Set @Start = @Start + 1 End return @Result ; End Go Code Snippet Create Table #events ( [Order] int , [Event1] Varchar ( 100 ) , [Date] datetime ); Insert Into #events Values ( '1' , 'Open' , 'June 1 2007' ); Insert Into #events Values ( '1' , 'Hold' , 'June 10 2007' ); Insert Into #events Values ( '1' , 'Close' , 'June 30 2007' ); Insert Into #events Values ( '2' , 'Open' , 'July 1 2007' ); Insert Into #events Values ( '2' , 'hold' , 'July 10 2007' ); Select [Order] , dbo . TotalBusinessDays ( [Open] , [Hold] ) OpenToHold , dbo . TotalBusinessDays ( [Hold] , [Close] ) HoldToClose From ( Select [Order] , Max ( case when [Event1] = 'Open' Then [Date] end ) as [Open] , Max ( case when [Event1] = 'Hold' Then [Date] end ) as [Hold] , Max ( case when [Event1] = 'Close' Then [Date] end ) as [Close] from #events Group bY [Order] ) as Data Tag: Maximum height for table
- 12
- Object reference not set to instance of the object while trying to sync. Use a login that is not an admin or does not have SQL access and execute the wizard as this user. Anyways, was that the case when you encoutnered the problem Or would it have been due to a network glitch Were you running the wizard and configuring a local server or remote server Tag: Maximum height for table
- 13
- OLE-Db connection in Transformation Script Component Hello, Using the following documentation as a guide: http://msdn2.microsoft.com/zh-cn/library/aa337080.aspx I instantiated a new script component into an existing Data Flow in my SSIS project. In the Script Transformation Editor, under the Connection Managers section, I associated the name dbConnManager to an already existing Connection Manager in the project. My Connection Manager is of the type oOLEDB. I then opened up the script designer and added the following lines of code where it said "Add your code here" Dim myConnManager As IDTSConnectionManager90 = _ Me .Connections.ECFconnection Dim dbConn As OleDb.OleDbConnection = _ CType (myConnManager.AcquireConnection( Nothing ), OleDb.OleDbConnection) When I test run the project I get the following error and the new script component is red: Unable to cast COM object of type 'System.__ComObject' to class type 'System.Data.OleDb.OleDbConnection'. Instances of types that represent COM components cannot be cast to types that do not represent COM components; however they can be cast to interfaces as long as the underlying COM component supports QueryInterface calls for the IID of the interface. I know the database connection works since I am using it in a component that executes before this new script component. I am stuck...Any suggestions Tag: Maximum height for table
- 14
- Installing Client Tools I recently installed an evaluation copy of SQL Server (Enterprise x64 edition). What's the proper way to load the management and analytical tools onto client machines There are 2 separate problems: 1. The 64 bit program only comes with 64 bit tools. (Should I just download the 32 bit evaluation copy Will the tools expire in 180 days on all the client machines ) 2. What are the licensing rules Surely I am allowed to load client tools (but not the server itself) onto client devices. Is that right Thanks! Tag: Maximum height for table
- 15
- Comparing Large Tables Sundar, You may be able to use the Lookup component. Chip's issues arise with the fact that one of the servers is SQL Server 7. Do you have the same situation Tag: Maximum height for table
- 16
- How to delete rows in tables... Ok we can work this out also. But has the above solved your original posts problem Tag: Maximum height for table
- 1
- Next
- 1
- any *simple* external activation examples available? BOL only seems to say that you can do it w/o really showing how, and the ExternalActivator sample at gotdotnet.com contains so much functionality I'm not sure what's required just for the external activation. Are there any docs or samples out there that focus on how to do it w/o obscuring the matter with a bunch of other functionality (I prefer docs to project samples, b/c the samples tend to have hacks like hardcoded paths and connection strings so that they rarely work correctly right out of the box.) TIA Tag: Maximum height for table
- 2
- My SSIS problems MatthewRoche wrote: Still, it would not hurt to have an "Advanced Options" (or whatever - pick your name) page in the wizard that asked data size and volume questions, and set some of these properties more intelligently based on this input. This is a good idea. Either yourself or TheViewMaster should post a Connect feedback item requesting this feature to be added. Tag: Maximum height for table
- 3
- Filtering Problems I am stumped on what is probably a simple glitch. I have an SSRS 2005 server report based on a stored procedure dataset, which accepts a single parameter. The parameter value originates from a session variable when the user opens the aspx page containing the reportviewer control (Visual Web Developer 2005). I've configured this parameter as a hidden parameter in the RDL design. In this configuration it functions as intended in both the development environment and when deployed. Next, I tried to add user prompts to implement report server filtering (in addition to the database filtering in the source SPROC). I added the parameters, set up the data sources for the prompt values, set up the filter expressions, did everything that I can find to implement this process. When I preview the report in the development environment, it works as intended. When I deploy it and attempt to run it from my http://localhost environment, though, it fails. There's no error message or anything...I don't even get the "Report Running" icon with no rows returned...what I get is prompts which function correctly (showing the right values and letting me select one), but when I click "Run Report" I just get an immediate screen refresh with the prompts reset to the default "<Select a value>" setting. And no report. I've obviously missed some setting somewhere, for it to work in dev but not when deployed. Any suggestions will be GREATLY appreciated. Tag: Maximum height for table
- 4
- Data from Derived Table I am looking to run two different queries. the first one returns about 6000 numbers. i.e 123454, 15432, 2343545 etc My second query i want to use the results from the first query as a where clause i.e where Number in ( '123454' , '15432' , '2343545' ) Clearly i dont want to type out 6000 numbers in a query. How do i use the data generated in the first query as the where criterea in the second query. Tag: Maximum height for table
- 5
- Cannot load Data Flow tasks When I copy over an SSIS package I have been developing from my laptop to my desktop with Windows File Sharing (shared folders) across a home network, the moved package fails to load properly. I can see the Control Flow tasks but not the Data Flow tasks - they simply disappear! I have update the Connection Managers to point to the new machine, and tested them (OK). Its the same as this issue posted here And Here Creating an empty package and clicking to create a new data flow cause this error: TITLE: Microsoft Visual Studio ------------------------------ Failed to create the task. ------------------------------ ADDITIONAL INFORMATION: The designer could not be initialized. Microsoft.DataTransformationServices.Design) Seems the only way is to uninstall and reinstall Client Components. How do I uninstall and reinstall Client Components when I try to do that, SQL Server Setup tells me "None of the selected features can be installed or upgraded. Setup cannot procees since there is no effective change being made to the machine...." I had selected "Workstation components, Books online and Development tools". This is already installed - so how I can reinstall it if I get this message above which does not let me proceed. Tag: Maximum height for table
- 6
- SQL 2005, OPENQUERY and security context switching Hi, I need to allow only a specific group of users to use a linked server. Rather than granting each user access in the linked server I create and give access to a local SQL login "link_user" and then grant the group impersonate to "link_user". The folllowing statements then work fine: EXECUTE AS LOGIN = 'link_user' SELECT * FROM OPENQUERY ( linked_server , 'SELECT * FROM ... ) But when I use the exact same statements in a stored procedure I get the folllowing error: Msg 7416, Level 16, State 1, Procedure linktest2, Line 5 Access to the remote server is denied because no login-mapping exists. I need to be able to work with the result set which is why I use OPENQUERY rather than EXECUTE... AS... AT which works fine also in stored procedures! Is there another workaround then to create all users in the linked server security Rgds Bertrand Tag: Maximum height for table
- 7
- Linking Oracle view to SQL Server express Hi, I was able to link SQL Server Express to Oracle views using Linked Manager. However, when I run the query, the performance is very slow. Is there a way to improve performance in querying Previously I was using Access to link to Oracle view. But the performance is not good. Takes about 8 hours for approx 6000 records. Thanks a lot, Stara Tag: Maximum height for table
- 8
- Query problem involving DateTime column shahrul wrote: thanks for correcting my mistake. btw, any idea why the resultset still return rows when there is no such date in the DB This is impossible. If your terminology in the query is relative, do_date could possibly be postdated meaning there are records that exist. However, if there are no records in 2008, the only possible explanation for it returning records is the stored date is in a strange format. (stored as varchar()) Adam Tag: Maximum height for table
- 9
- Pivot fields into a single column For the first select, it says there's no from clause in the select statement following the cross join. In the second one, it says unable to parse text. I plugged in my field names (which are f1 through f4) and my table name where the t# is Perhaps i'm confused about the and the [Year]. Tag: Maximum height for table
- 10
- Access project connecting to SQL 2005 Can you post a sample script that shows what you did What do you mean by not being able to see the views Can you post the error message that you received Also, where do the views show up with an invalid schema Have you checked the schema name using the catalogs using a query such as the following: select schema_name ( schema_id ) from sys.objects where name = 'view_name' Thanks Laurentiu Tag: Maximum height for table
- 11
- Filters - Report Builder I have created a report showing both first name and last names with the following filters. Both of them are prompted parametres Last Name Contains ------------------ First Name Contains ------------------ When users enters both then we get the results back. I want the first name to be optional such that if user enters something for the first name then take it into the search criteria else show all the first names which matches the last name criteria. Example: Last Name = "SMITH", First Name = (user has not entered and NULL check box is checked). I don't get any results since this filter translates to find all the records which has the last name SMITH and First Name IS NULL), Instead I want this to be select all the records which has the last name SMITH and First Name <> EMPTY. Is there a way I can do this using the fiter magic Thanks. Tag: Maximum height for table
- 12
- Connection Managers Area not coming up When I brought up the BI DEV studio first tiem the Connection Managers area showed up, but after I closed it by mistake from next time on wards it is not coming up. Can some one from this form help me how to get the Connection Managers area(pane) back Thanks in advance. Regards Mamidi Tag: Maximum height for table
- 13
- How to make this query... Hi Folks, Unfortunately, the answer Gigi gave won't work. The problem is that select Symbolid from db_stockprices where Date<>@yourdatavalue will return the symbols from all rows whose dates don't match your date. I.e., if a stock has a price row on a date other than your date, then it will be returned. The only symbols that won't be returned will be those that only had a price for the date entered. You can build up a query that will do what you want. There may be other, better ways to do this, but here's one way to think through the problem. Start by selecting all symbols that do have a trade on the date you want: SELECT SymbolID FROM db_stockprices WHERE Date = @date If @date is 1/3/2007, this will return the symbols 1 and 3. It may seem counterintutive to do this, but now you can find all symbols that are not in this list: SELECT SymbolID FROM db_stockprices WHERE SymbolID NOT IN ( SELECT SymbolID FROM db_stockprices WHERE Date = @date ) Again, with @date = 1/3/2007, this will return symbols 2 and 4. Now you can build the delete: DELETE FROM db_symbols WHERE SymbolID IN ( SELECT SymbolID FROM db_stockprices WHERE SymbolID NOT IN ( SELECT SymbolID FROM db_stockprices WHERE Date = @date ) ) Hope this helps! -Isaac Tag: Maximum height for table
- 14
- What is the best book to start from scratch? I like these books, for a gentle start to learning SQ Server: Microsoft(r) SQL Server(tm) 2005: A Beginner''s Guide (Beginner's Guide (Osborne Mcgraw Hill)) by Dusan Petkovic Beginning SQL Server 2005 for Developers: From Novice to Professional by Robin Dewson Beginning SQL Server 2005 Administration by Dan Wood, Chris Leiter, and Paul Turley Tag: Maximum height for table
- 15
- Mirroring on separete domains We have 2 servers each having a domain (i.e. 2 domains) running Windows Server 2003 Standard Edition Service Pack 1 We would like to have one of the servers replicate/mirror the data on to the other but we are getting this error The error produced from the mirroring part is: TITLE: Database Properties ------------------------------ An error occurred while starting mirroring. ------------------------------ ADDITIONAL INFORMATION: Alter failed for Database 'CTSM'. (Microsoft.SqlServer.Smo) ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The server network address "TCP://UM_db_live.UMlive.local:5022" cannot be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error : 1418) Thank you. Tag: Maximum height for table
- 16
- Trigger with access to remote server The scenario you described is actually synchronously, in addition if the Update trigger fails, the whole transaction will be rolled back (which you probably don¡¯t want). i would suggest using a table where you write the reference to the updated data on the table in S1. check this table in small intervals via a SQL Job and update the s2 server then. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: Maximum height for table
- 1
- Previous
Re: Maximum height for table
GregSQL
Click View -> Properties window. The dimensions for a table/matrix can be changed in this window.
Click View -> Properties window. The dimensions for a table/matrix can be changed in this window.
Re: Maximum height for table
Priyank Pandey
Hi Greg,
Do you know how does this height create any difference, what i mean is usually this doesnt restrict the table from expanding or so.
Re: Maximum height for table
GregSQL
So you're saying that you want to cut off the rest of your data if it goes past the height you specify
So you're saying that you want to cut off the rest of your data if it goes past the height you specify
Re: Maximum height for table
bwags80
Hi Greg -
I don't think I stated my question clearly. What I'm trying to do is limit the number of rows returned in my table. So for example, if the dataset connected to my table contained 30 rows, is it possible to cap the number that are returned to 20 If not, is it possible to set the "canGrow" property to a maximum height
Thanks.
Brad
Re: Maximum height for table
GregSQL
I would do this in your SQL query.
SELECT TOP 20 * FROM .....
Re: Maximum height for table
bwags80
Yes, but unfortunately I am in a situation where I cannot control the results of the stored procedure. I am only able to use pre-existing SPs and build the report.
Brad
Re: Maximum height for table
Priyank Pandey
Please try visibility condition of that section, use =iif(rownumber(nothing)>=20,true,false).
Priyank
Re: Maximum height for table
bwags80
That's a good thought but unfortunately does not do exactly what I need. Using my example from earlier, that code returns 20 rows of data, and then 10 blank lines. My table is still expanded to the full 30 rows however.
Any other ideas
Thanks.
Brad
Re: Maximum height for table
Priyank Pandey
Are you using it in the visibility of the section and not for the indivisual textbox. What i mean to say is select the complete detail section of the table and then in the visibility condition of the section write this condition, It shold supress the complete sectiona dn shold not give you blank rows.
Re: Maximum height for table
bwags80
I had selected the textbox and the full table, but not the detail portion of the table. 
Putting the code in the detail portion worked like a charm, thank you!