Hide parameter if other paramter is null

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - What permission required to DROP TABLE ? DROP is not a grantable permission. People who can drop a table are: The dbo The owner of the schema The owner of the table (usually the schema owner but it can be changed to someone else) members of the db_ddladmin fixed database role members of the db_owner fixed database role members of the sysadmin fixed server role grantees of the CONTROL permission on the table or permissions that imply control on the table grantees of the ALTER permission on the schema or permissions that imply alter on the schema. hth, -Steven Gott S/DET SQL Server Tag: Hide parameter if other paramter is null
  - 2
    - Clarification on product specification http://www.microsoft.com/sql/editions/compact/sscecomparison.mspx The above link says the pros and cons of two SQL Server 2005 editions. Document says Compact Edition is not good for ‘When you need a multi-user database server ’. What is the meaning of multi-user database Does this means the database strictly will not support two database connections at a time -Thank you, Gish Tag: Hide parameter if other paramter is null
  - 3
    - SP to search on any number of characters Hi I think you need to read " Full Text Search " hope this will help you http://www.15seconds.com/issue/010423.htm http://www.fogcreek.com/FogBugz/KB/dbsetup/FullTextSearch.html http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/ http://www.google.co.in/search q=full+text+search+sql+server&hl=en&start=10&sa=N Gurpreet S. Gill Tag: Hide parameter if other paramter is null
  - 4
    - Is there a way to parameterize lock type? This seems to work at a statement level. create table test ( testId int ) go create procedure test$select ( @isolationLevel varchar(30) ) as begin if @isolationLevel = 'READUNCOMMITTED' set transaction isolation level read uncommitted else if @isolationLevel = 'READCOMMITTED' set transaction isolation level read committed else if @isolationLevel = 'REPEATABLEREAD' set transaction isolation level repeatable read else if @isolationLevel = 'SERIALIZABLE' set transaction isolation level serializable begin transaction select * from test waitfor delay '00:01:00' commit transaction end go test$select 'REPEATABLEREAD' Checking this in the sys.dm_exec_sessions shows that the isolation does get set, but will this hurt the plan that is created by the stored procedure Tag: Hide parameter if other paramter is null
  - 5
    - Conflicts in Merge Replication Li Zhang wrote: In SQL Server 2000, it is not possible to specify an order. An order can be speficied in SQL Server 2005. Then, could you tell me how do you specify the order in sql server 2005 Cheers Tag: Hide parameter if other paramter is null
  - 6
    - cluster install 2nd node unavailable Check the SQL error log, cluster log and event viewer log for more information. Tag: Hide parameter if other paramter is null
  - 7
    - Job interview question What title is this position that you are interviewing for Tag: Hide parameter if other paramter is null
  - 8
    - Setting multi-value parameters using ReportExecutionService Wow, that worked. Thanks! Tag: Hide parameter if other paramter is null
  - 9
    - Calculated Fields in the report Hi Lisa, Still I cant figure it out SELECT part. Because I have to apply two conditions at the same time. Forget about the table names I mentioned above. Following names are the real names. 1. For Total no of loans disbursed in each month , I need to write smthing like this. SELECT Rate.Tier AS CreditTier, COUNT(Loan.AccountId) AS TotalNoOfLoans, DATEPART(month, Loan.CommencedOn) AS Month FROM Loan INNER JOIN Rate ON Loan.Id = Rate.Id WHERE CommencedOn BETWEEN '01/01/07' AND '12'/01/07' GROUP BY DATEPART(month, Loan.CommencedOn), CreditTier 2. For Total no of deliquent loans disbursed in each month, I may need to write smthing like this. SELECT Rate.Tier AS CreditTier, COUNT(Loan.AccountId) AS TotalNoOfDeliquentLoans, DATEPART(month, Loan.CommencedOn) AS Month FROM Loan INNER JOIN Rate ON Loan.Id = Rate.Id WHERE CommencedOn BETWEEN '01/01/07' AND '12'/01/07' AND State = 'Deliquent' GROUP BY DATEPART(month, Loan.CommencedOn), CreditTier Now I want to calculate values for each record. For example, COLUMN Jan and ROW CreaditTier AA, 0.00 % (This is not necessarily zero) = ((TotalNoOfDeliquentLoans in Jan with CreditTier AA )/ (TotalNoOfLoans in Jan with creaditTier AA ))*100 But I cant figure it out how to combine these. Coz If i write like this, I'm making two different data sets. Hope now you have a better idea of what i'm trying to do.. Also I think I have to use matrix instead of a table for this Tag: Hide parameter if other paramter is null
  - 10
    - Performance is degraded drastically after migrating to SQL Express 2005 from MSDE 2000 SQL Express supports an entirely new paradigm triggered by the "User Instance=True" keyword in the ConnectionString. This is the default behavior in Visual Studio--especially if you include the MDF in your project (which I don't recommend). If enabled, this option copies the master, model and tempdb to your user area on disk along with a(nother) copy of your MDF before launching an entirely new (private) instance of SQL Server. Yup, this can take some time. It's another reason I don't (universally) endorse it. See www.hitchhikerguides.net for more information... Tag: Hide parameter if other paramter is null
  - 11
    - extract information from tables Yes the answer is there but I changed the table structure and though I appreciate the effort of DaleJ but I can't seem to display it like this in a DataGridView Row. Why don't you check the new table structure and please reply on this. Thanks for your help Gemma Tag: Hide parameter if other paramter is null
  - 12
    - AWE working? Are you sure this is by design My performance is awful after I have upgraded. SQL Server 2000 used to locked the memory as it starts, so the production server (4 cpus and 32 G memory) was doing a lot better than my development server with (1cpu and 2G memory). However, after upgrade, the performance level of the production server is awful. For example, a query need 9 seconds on test server used to run only 2 seconds on live server. Now it needs 8 seconds ... Tag: Hide parameter if other paramter is null
  - 13
    - Problem with ID 17981 Hello, I’m trying to do an update through a system but this message display a problem that I didn’t get to identify exactly the problem to looking for a solution. "Table error: Object ID 17981, index ID 1, page (0:871674153). Test (offset + len < PAGESIZE) failed. Slot 10, offset 0x1a8 is i Error while undoing logged operation in database " Could anyone help me please Thanks, Mauricio Tag: Hide parameter if other paramter is null
  - 14
    - After restoring MASTER database, can't start SQLServer Service: Configuration block version 0 is not a valid version number I tried rebuilding using this command: start /wait d:\setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=YourPassword However, you are saying those were not the proper commands and switches to use during the reinstallation (Also I didn't want to specify an SA account and password, I wanted to use windows authentication but didn't see an option for that). Tag: Hide parameter if other paramter is null
  - 15
    - error: Could not find SP upd.sp_MSrepl_xxx_xxxxxx_1 The owner for each article is set to 'dbo'. When it first happened there wasn't a login (or schema) called 'upd' in existence on the either of the publication or subscriber servers. I'm just trialling this with a very small test db (2 tables) so no one else would be playing around with it. I've also recreated the database and publication from scratch several times with the same result. I'm thinking it may be a bug or an incorrectly applied service pack (the servers are not under our control, I don't even know who maintains them) . It's bound to be probably related to the fact that I'm trying to replicate between SQL2000 and SQL2005 servers. I know that merge replication with a SQL2000 publisher and a SQL2005 subscriber is not supported but transactional replication is supported (though I'm not 100% sure that encompases transactional replication with updateable subscribers ... ) Tag: Hide parameter if other paramter is null
  - 16
    - Plz do evaluate this SP Arivindt: First, I give you a lot of credit because you asked to have your code reviewed. This is always worthwhile and I want to encourage you to continue this habbit -- it will serve you well. The first question that I have involves this line: Code Snippet Where a.DynamicQuestionID = @DynamicQuestionID --'B440AC87-FC53-4735-A6D8-EB4DBFD9D447' There are some definite performance problems associated with uniqueidentifiers; Is it necessary to use a uniqueidentifier here Can the table be modified to use a smaller datatype ( I will assume that this would require too much work ) For future work, avoid UNIQUEIDENTIFIER datatypes as they have a negative impact on performance. This section of code also bothers me a little: Code Snippet Insert into @SubscriptionList (PortalID,Question , DynamicQuestionID) Select PortalID,Question,DynamicQuestionID From DynamicRegistration_Question Where ShortFieldName = @p_SubscriptionText Select Top 1 @DynamicQuestionID = DynamicQuestionID , @Question = Question From @SubscriptionList The first thing that I noticed was that this was followed by what appears to be a couple of DEBUG statements. Therefore, I presume that this either is giving you some trouble or has given you trouble in the past. It bothers me to see the "TOP 1" clause without an "ORDER BY" clause. Also, Since the @SubscriptionList table is not used after this section, I believe that the code can be simplified and perhaps the @SubscriptionList table variable can be completely eliminated. Something like this might work here: Code Snippet select @DynamicQuestionId = DynamicQuestionId, @Question = Question from ( select top 1 DynamicQuestionId, Question from DynamicRegistration_Question Where ShortFieldName = @p_SubscriptionText -- I feel like an order by should be added here. ) x Note the location to add an ORDER BY clause. I would recommend that you figure out what the ordering should be and add an ORDER BY clause. I also think that step #3 can be simplified. Tag: Hide parameter if other paramter is null
- Next
  - 1
    - Stored procedure vs. query This is somewhat of an age-old debate. Some prefer inline sql and some prefer procedures. I prefer procedures because it keeps all your code in a place that is easy to manage, rather than in a web file, and provides security benefits, such as preventing a lot of sql injection attacks, and assignable permissions. As far as performance, you will likely see the same performance from either...once a statement is executed against the database, whether it is from a proc or ad-hoc sql, the statement will stay in cache until the db engine decides it is ok to take it out because it hasn't been used in awhile. In face, in 2005, the db engine takes it a step further for statement level recompiles, rather than entire procedure compiles. Tag: Hide parameter if other paramter is null
  - 2
    - data access to large tables in sql 2005 hi all, i have a large table in sql server 2005 (it has about 6 columns and 10 million records). i need to work in a linear way on all the records (i know it sounds dumb but i need to work on all records). now, obviously when trying to work on this table sql server get stuck for timeout or something like that... i've noticed that a simple function like "select top 100 * from ExportTable" still works. is there any way to have sql send me the data when it access it so that i'll still be able to proccess it on the same time, i basically work using dataset so that fixing the timeout wont be helpfull since windows probably wont allow me to load this amount of data into memory. can any1 help Z Tag: Hide parameter if other paramter is null
  - 3
    - SQL Server on Windows CE 5 Thanks for the link. "3. You must download and install the SQL Compact SDK to get the device cab files." I am developing application on a device for someone and they own the device. Is it okay for me to install SQL Server on the device and let them use it OR do I (or they) need to accept another license agreement I am asking this because it is an SDK , and the license could be intended solely for developing and testing applications. Thanks, Jaydutt Tag: Hide parameter if other paramter is null
  - 4
    - Upgrading SQL Server 2000 Enterprise Edition to SQL Server 2005 Standard Edition You cannot 'downgrade' Enterprise Edition to Standard Edition. You must Uninstall Enterprise and then Install Standard. Refer to this article for instructions about moving or attaching the system databases. http://msdn2.microsoft.com/en-us/library/ms345408.aspx Then re-Attach your existing databases. Tag: Hide parameter if other paramter is null
  - 5
    - Should SQL 2005's BPool reservation size vary with "-g" startup parameter? Hi, Ajmer Thanks for taking the time to help! I have double-checked and can verify that there is no space between the "-g" and the memory size parameter. -David Tag: Hide parameter if other paramter is null
  - 6
    - Trouble with Workflow DTS (SQL 2000) It is a DTS (Sql 2000) and have not defined any variable, i have just set the Workflow "On success" and it is between EP#1 y EP#2 EP#1 runs in another server. For example, it happens that the another server is offline and the package couldn't be executed, but anyway EP#2 continues... Tag: Hide parameter if other paramter is null
  - 7
    - Calculated Measures using AMO HI, Thanks a lot, that gave some insight, and helped me investigate further. This leads to the obvious question, What MDX should I write in the command, so that it would create a calculated measure, with some formula. meaning what would be the general syntax of the MDX that we would have to write. I created a calculated measure from the BI studio and then used AMO to get the cube object, I then browsed the cube object: Cube > MDXScripts > Commands Command Text was: string CmdTxt = CREATE MEMBER CURRENTCUBE.[MEASURES].CalTestMeasure AS [Measures].[M1] * 5, FORE_COLOR = 6776628 /*R=52, G=103, B=103*/, VISIBLE = 1; Now I suppose this code must do the same programmatically AMO.MdxScript MdxScript = NewCube.MdxScripts.Add("test", "test"); AMO.Command comd = new Microsoft.AnalysisServices.Command( CmdTxt ); MdxScript.Commands.Add(comd); I will try this with some more modifications, but this is surely going to create a problem in the future. Now imagine I want to modify the calculated measures, their calculations programmatically ..etc, What happenes is that all the calculated measures are in one huge string of MDX!!!!!!!, How do i work on it string manipulation that makes it very very error prone. so we have no other way to do this other than using MDX scripts Tag: Hide parameter if other paramter is null
  - 8
    - Show SQL search query in pages How to show a SQL search query in pages for example 10 records in each page, like search engines. I'm using .NET Framework 2, SQL Server 2000 and Adobe Dreamweaver CS3. Thanx Tag: Hide parameter if other paramter is null
  - 9
    - Entering data into tables Thanks a lot, as you can tell, I'm brand new to this SQL. Just trying to learn the ropes. Thanks again. Tag: Hide parameter if other paramter is null
  - 10
    - INDEXING A VIEW in MSSQL2K5x64.de Standard w.SP1 ... ERROR 1939 can anyone please help me with this please thanks Tag: Hide parameter if other paramter is null
  - 11
    - SQL Reporting Services performance on navigation pages. Teo, Thanks for this response, it sends me in a direction I had not yet been. I now see that the SessionTimeout setting is set to 600 (10 minutes). is it OK to simply change that setting in the table I would have assumed there might be a better utility or something that would handle that. I saw another post that discussed some of this and it implied that the setting could be changed via an API or even the rs.exe utility. I also thought it referenced the SessionTimeout in th RSReportserver.config file, but I don't see it there. perhaps it can be added to override the default I'm not sure that this is even what I really want to do. My issue is not that a given report takes too long, but that it takes way too long to build the navigation pages the first time and I don't see any reference to that in the ExecutionLog Table. I'm not clear on what all is occuring during this build phase that should take that long. I'm on a pretty fast/solid network so it really shouldn't. don't know if you or anyone can shed any light on that for me. bottomline is that my users want to be able to get to the reports on demand and I don't want them to have to wait for the navigation pages. ray Tag: Hide parameter if other paramter is null
  - 12
    - Select statement to output a date Thanks Andrea, I have just tried the line of code above SELECT GETDATE(), CONVERT( varchar(40), GETDATE(), 100); The output is as: 08/10/2007 01:54:15 Oct 8 2007 1:54AM I am just wondering if it is possible to format output date as: October, 8 2007 Tag: Hide parameter if other paramter is null
  - 13
    - Dumb question about compatibility level Try running the following on your SQL Server instance: SELECT @@VERSION All being well then something like the following should be returned: Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) If the version returned is ' Microsoft SQL Server 2000 etc... ', and if you performed a side-by-side upgrade when you installed the 2005 instance, then you are probably inadvertedly using the old 2000 instance instead of the new 2005 instance - this would account for the problems you are experiencing. Chris Tag: Hide parameter if other paramter is null
  - 14
    - Updating the variable's value Yes, they are of the package level scope.. Tag: Hide parameter if other paramter is null
  - 15
    - BCP (BULK INSERT) with only <lf> as line delimiter (not <cr><lf>)... Hi, This might be a noob question, but is there any way to specify just <lf> as a line delimiter, and not <cr><lf> ( /n ) as line delimiter in T-SQL call for BULK INSERT (or BCP utility). How please TIA. Tag: Hide parameter if other paramter is null
  - 16
    - Replication using SQL server 2000 (SP4) .. urgent... Hi, We have few branches with individual dbs are sitting in the branches itself. Periodically all the data need to be updated to a single HQ database. At the moment, all the tables's primary key are unique and each branch will have branch ID's in the transaction tables. e.g. Branch1 data need to be updated to HQ db. However, HQ db records which are related to Branch 1 data only need to be updated back to Branch 1. other branch records should not goto Branch1. Similaryly other branch records need to be updated/replicated back to HQ database. And only records related to the particular branch need to be updated from HQ (if any changes made).. At the moment, i can do simple replication from one db to another db only... Can anyone guide/give suggestions on how to go about doing this If possible, please give steps involved... TX Tag: Hide parameter if other paramter is null

The JD

What I have is a report using Reporting Services 2005 that will take in a parameter through the URL called RepID, so the parameter is hidden inside the report because it's passed through the URL. This will run the report for the specified Rep. However, I'd like to have another paramater (Or also using RepID) just as Admin which would be a boolean and when Admin='N', the RepID parameter should not be displayed on the screen and just be accepted through the URL paramater RepID. However if Admin='Y' is the URL paramater passed, I want the RepID parameter to be displayed in the report so that the Admin can enter whatever RepID they want to run the report. Is there anyway to do this without creating a separate Admin version of the report

Top