Want Text box font to be inherited from list

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - From Command window output to a text file Hi, I want to output from the database, throught the command prompt window and into a text file. I have found a command called bcp command, i have used it and it works just fine . However, i have a problem. The problem is that by default it outputs into the file using tab delimited form. Each column is seperated by a tab. Is there any way , either from the query analyzer onwards or from the bcp command to output the data without the tabs inbetween Thank you George Tag: Want Text box font to be inherited from list
  - 2
    - Map One generic Input column to multiple Destination column I have a stored proc I am updating in an OLEDB Command from the results of a Transform Script Component. The Stored Proc has over 65 input parameters, most of them have a NULL passed in. I dont want to create output columns in the Transform Script Component for all of them to map them from the "Available Input Columns" to "Available Destination Columns". I want to create 3 or 4 generic Output columns for their data type - say IntegerOutput (datatype Int), DateTimeOut (datatype datetime) and so on. The I want to map these generic columns in the OLEDB Command as Available Input Columns" to multiple "Available Destination Columns" - wherever the datatype matches the input column. But the OLEDB Command Column Mappings let me map One to One only. This will create a huge and unnecessary workload for me to develop and maintain - when I tell you I have 3 such stored procedures, all of whose interfaces are exactly same and for which I can create similar Output columns in the Transform Script Component. So how do I go about doing this the smart way thanks in advance! Tag: Want Text box font to be inherited from list
  - 3
    - How to determine if the logged on user is a member of an active directory security group? We are using Windows authenication within our system, and I was wondering how it would be possible to determine if the user conected to the SQL SERVER instance was a member of a particular active directory security group Thanks. Tag: Want Text box font to be inherited from list
  - 4
    - SQL 2005 RS Configuration Tool - Encryption Key Error I have SQL 2005, and Reporting Service has been uninstalled and reinstalled, go through each step of confiugration until Encryption Key, for some reason, the backup button is grayed out, only "restore" button is clickable, as well as Delete, but we never backup the key before, so this is really strange since we do not have backupkey, so we cannot restore. we tried "Delete", then we got the following error: ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted value for the "LogonCred" configuration setting cannot be decrypted. (rsFailedToDecryptConfigInformation) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation() Browse report manager and reportserver also got the same error, run rskeymgmt -d, does not help either Any suggestion Thanks Don Tag: Want Text box font to be inherited from list
  - 5
    - Error Connecting to Remote Server Using Microsoft SQL Server Management Studio Express Dear All, I am trying to connect to a remote sql server 2005. So I have install the Microsoft SQL Server Management Studio Express. When I try to connect I get the error below. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53). Can some one please help. I have even port no 1533 on my pc. Thanks. Tag: Want Text box font to be inherited from list
  - 6
    - parameterize SSIS package to identify a source file location Hi All, I created a SSIS package to extract data from a flat file source and load them into a table in a data base. After I created the package i checked it in to source control(perforce). But the problem is once a month new flat source file comes and data should be updated. Once the new flat file comes, is there anyway that SSIS package can identify the path of the flat file and execute the package automatically In Flat file source only the data will be changed. Not location or data type or anything. Can i use parameters to do that Thanks Tag: Want Text box font to be inherited from list
  - 7
    - Create Table within an IF statement causes error This doesn't make any sense to me. I am trying to create a stored procedure that creates a temp table using T-SQL. The table will be created differently depending on the arguments passed. Here is an example of what I am trying to do: DECLARE @Switch bit SET @Switch = 0 IF @Switch = 0 BEGIN PRINT @Switch CREATE TABLE #DontWork ( Zero int ) END ELSE BEGIN PRINT @Switch CREATE TABLE #DontWork ( One int ) END SELECT * FROM #DontWork If you run this as is, it fails stating that "There is already an object named '#DontWork' in the database." However if you comment out one of the CREATE TABLE statements (either one of them), it works fine. The PRINT @Switch line will prove that the IF ELSE statement is evaluating properly if you change the value of @Switch. My guess is that the parsing engine is throwing the error before it even tries to run the code. Is there any way to make this work the way it should Or do I have to resort to creating 2 different tables and modifying the rest of my code to compensate for the change Tag: Want Text box font to be inherited from list
  - 8
    - Strange Behaviour Sort and Merge Join I have encountered an annoying problem which causes the Merge Joins to lose records in the dataflow. The problem is caused by 2 unusual behavoirs. 1/ Sort of SSIS is not sorting the same as ORDER BY in SQL example: Code Snippet CREATE TABLE [dbo].[table_2]( [test] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] With data as following: Code Snippet 1000 1-1.00.00.00 2000 When select this data with an order by like: select test from table_2 order by test The result will be: Code Snippet test 1-1.00.00.00 1000 2000 If you sort the data by the SORT block of the SSIS the result will be: Code Snippet test 1000 1-1.00.00.00 2000 This is annoying and dangerous, because it causes the next bug. 2/ Two datasources sorted by ORDER BY clause can give problems in a Merge Join. If you have 2 data sources both correctly sorted by an order by in the query. When you join these 2 datasources with a Merge Join, you can lose some records in the dataflow. This happens with larger datasets than examples above. http://img340.imageshack.us/my.php image=strangebehavior2tw1.png When I join the datasources (see image ) inside SQL I will get a correct result of 15271 records. Is this a bug which I should report or is there a flaw in my logic Tag: Want Text box font to be inherited from list
  - 9
    - Server Agent Jobs: Script job as create to file... Hello, I would like to be able to script my server agent jobs to file via transact as in not relying on the Server Management Studio user interface. Is there a stored procedure that I can use to accomplish this For example, something like: dbo.sp_job_to_file 'job_id','disk_location' Thanks in advanced, CC - Runing SQL Server 2005 - Utilizing SQL Server Management Studio Tag: Want Text box font to be inherited from list
  - 10
    - comparing two fields Greetings. I am trying to write a sql that identifies all the rows in one table that do not match another. The sql needs to compare the values in two columns of each table. In the past, I've used a where not exists and a subquery to identify missing rows. select a . block_code from BLKPTS_ADDXY a where not exists ( select block_code from allblkzips as s where s . block_code = a . block_code ) I need to add a second column from each table (zip) to the query. For some reason, it doesn't seem as straightforward as I thought it should be. Suggestions are appreciated. Thanks. alan Tag: Want Text box font to be inherited from list
  - 11
    - Transaction Question When I run the following in Query Analyzer: SET QUOTED_IDENTIFIER OFF -- allows double quotes (") used as wrapper for dynamic sql. DECLARE @E int BEGIN TRAN T1 PRINT 'Start...' EXEC ( " begin tran T2| raiserror( ' inside proc', 16, 11) PRINT STR(@@ERROR) rollback tran T2 PRINT STR(@@ERROR) return " ) SET @E = @@ERROR IF @E <> 0 BEGIN PRINT 'Error ' + LTRIM ( STR ( @E )) + ' out of here...' ROLLBACK TRAN T1 RETURN END PRINT 'Done.' COMMIT TRAN T1 I get the following output and error: Start... Msg 50000, Level 16, State 11, Line 3 inside proc 50000 Msg 6401, Level 16, State 1, Line 5 Cannot roll back T2. No transaction or savepoint of that name was found. 6401 Msg 266, Level 16, State 2, Line 7 Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 2. Error 266 out of here... Anyone have an idea why I would get the 6401 and 266 error JD Waleska, GA MSBassSingerNO-SPAM@alltel.NO-SPAMnet (just remove the string NO-SPAM) Tag: Want Text box font to be inherited from list
  - 12
    - Cannot connect to 2000 from 2005 via linked server Interesting issue.. I think I have 2 linked servers on my dev 2005 instance (sp1-win 2003). My 2005 instance shares the physical server with a 2000 instance. This linked server works fine. The second linked server is on a separate server running sql 2000 sp3. I cannot connect to this server at all. I can connect the other way -- from the 2000 to the 2005. I have tried all kinds of combinations of security and options but nothing works. The only resolutions I have found referenced installing Management Studio on the 2000 server or creating an ODBC connection from the 2005 instance. Any ideas Here is the error I get: OLE DB provider "SQLNCLI" for linked server "ALLFLDB6" returned message "Login timeout expired". OLE DB provider "SQLNCLI" for linked server "ALLFLDB6" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". Msg 10061, Level 16, State 1, Line 0 TCP Provider: No connection could be made because the target machine actively refused it. Tag: Want Text box font to be inherited from list
  - 13
    - Cube processes OK but no rows appear in the browser I have a small cube that process ok. The message shows that a few hundred rows processed from the fact table and the appropriate number of dimensions processed. When I look at the cube in the browser I get blank cells no matter what dimension or measure. Any wisdom Tag: Want Text box font to be inherited from list
  - 14
    - Is there Limitations to Importing data to SQL Server Express I have software that uses SQL Server Express as it's database. I am only able to import so many records until it stops and fails to allow me to import anymore. I'm very new at this but, is there some type of limitation on Table size that's preventing me from importing anymore data I'd really appreciate it if someone could help me, Thanks... Bill Tag: Want Text box font to be inherited from list
  - 15
    - Multi-database Multi-server I am new to Reporting Services and hope that what I am looking to do is within capabilities :-) I have many identical schema databases residing on a number of data servers. These support individual clients accessing them via a web interface. What I need to be able to do is run reports across all of the databases. So the layout is: Dataserver A Database A1 Database A2 Database A3 Dataserver B Database B1 Database B2 Dataserver C Database C1 Database C2 Database C3 I would like to run a report that pulls table data from A1, A2, A3, B1, B2, C1, C2, C3 Now the actual number of servers is 7 and the number of databases is close to 1000. All servers are running SQL2005. Is this something that Reporting Services is able to handle or do I need to look at some other solution Thanks, Michael Tag: Want Text box font to be inherited from list
  - 16
    - DB does not autogrow Good Morning, I am having a problem where I have a process that seems to fill up the database but the database does not seem to grow like it should. The database is set to autogrow by 10%... the database is around 15-16GB and it is right over 16GB when it fails. This happens once a week lately. nothing on the server has changed. the strange thing is when you look at the database properties through EM it shows as no space available but when you do a shrink file and look at the log and data files there are over almost 2GB free on the data file and 1GB free on the log... it does no make sense... in order for EM to show there is free space I have to add over 5GB to the data file and 1.5 GB to the log file. then processes continue... is there something that I am missing Tag: Want Text box font to be inherited from list
- Next
  - 1
    - new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software re: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software From my desktop the report accessing an Oracle 9i db with no problem. I've deployed other reports accesing sql server with no problem. Now I deploy the report and try to access my Oracle source and get: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater On the server in question, I know they've installed the oracle client. I can access the db from sql plus with no problem. As the user that I access ssrs credentials, i remote login and am able to write to oracle home.. C:\oracle\ora10g\NETWORK\ADMIN i've confirmed my database is in tnsnames and it works from sqlplus. Tag: Want Text box font to be inherited from list
  - 2
    - copying tables DTS vs SSIS - speed!!! Hi, I'm trying to create a package with SSIS to replace the DTS process that we have in place already. DTS package copy four table content from one server to another. I have created a simple SSIS to do the same processes but the process it alot slower than DTS!! I did ran the SSIS package using ctrl+F5 and also from command prompt but still it's quite slow. SSIS uses SMO to access to server and both are running on 2005 Thanks Tag: Want Text box font to be inherited from list
  - 3
    - using historical attributes with SCD transform on a table with a PK I must be missing something somewhere... I have a simple table with three fields: ID, LastName, FirstName. The ID is defined as the PK. In the table is a record of "12345, Smith, John". The incoming flat file has a record of "12345, Smith, Johnny". In the SCD transform, the ID is the business key, and Last Name and First Name are defined as historical attributes. During the load, the SCD transform correctly sends the data down the right path, but the insert fails with a primary key violation - as I would expect since it's trying to create a new current record. How do I get around this problem without removing the PK thx Tag: Want Text box font to be inherited from list
  - 4
    - How to validate the parameter values? Hi, Is there any way to validate the input paratemers for the report For example: I want to restrict the value to be less than 100 in one parameter. How to achieve this Thnx in advance. Tag: Want Text box font to be inherited from list
  - 5
    - How do I go about placing photographs in SQL? I have SQL 2005 Server and Visual Studio 2005 and I am working in vb. I want to create a database which has photographs. Tag: Want Text box font to be inherited from list
  - 6
    - Average of children i know this question has been around for some time, and have read most of the answers, but well still looking at how to do this in standard edition of sql 2005. to what i understand Average of children calculates the average not on the lowest level but on the next one (i.e. it sums the values on daily basis but it calculates an average on weekly or monthly basis). my problem was that i needed to calculate an adjusted price base on the next formula: i.e. price hotel 1 - H1 price hotel 2 - H2 price hotel 3 - H3 capacity hotel 1 - C1 capacity hotel 2 - C2 capacity hotel 3 - C3 ((H1*C1)+(H2*C2)+(H3*C3)) / (C1+C2+C3) now i used averageofchildren to define measure (price of hotel*capacity of hotel) and measure (capacity of hotel) and created calculated member based on the above formula. with the use of averageofchildren i get the wanted result. but if i use avg()/count() i get also average of those 3 hotels on the level of day. now could someone please help me to write a calculated measure or mdx expression that would not use averageofchildren. i have defined sum measure (price of hotel*capacity of hotel) and sum measure (capacity of hotel) . i have defined dimTime. is there a way to do this i hope you all understand my question... thanx in advance Tag: Want Text box font to be inherited from list
  - 7
    - Query Time Limit? I know I can use SET QUERY_GOVERNOR_COST_LIMIT to prevent a query from executing if its estimated execution time exceeds the value of the specified time in seconds, but is there some way to have a query stop executing (and raise an error) if the time exceeds a specified time For example, if the query takes longer than 20 seconds, have it stop executing and raise an error Thanks, -Dave Tag: Want Text box font to be inherited from list
  - 8
    - Personal Web Developer Kit SQL Error Hi folks, I get this error message when I try to run my personal web page starter kit (Ctrl + F5) which has come straight out of the box: Server Error in '/WebSite1' Application. Tag: Want Text box font to be inherited from list
  - 9
    - SQL Server - using a cursor to find and sum login/logout times Hi all, New to using cursors and i was after some help. We have a trace running to find instances of certain sp's, these basically tell us when someone logs in and someone logs out (1 row per event). Importing into a table basically gives me process, user, datetime e.g. 'login', user1, 2007-02-15 10:21:35.590 'login', user2, 2007-02-15 10:21:36.100 'logout', user1, 2007-02-15 10:22:45.100 'login', user3, 2007-02-15 10:23:23.100 'logout', user2, 2007-02-15 10:27:54.436 'logout', user3, 2007-02-15 10:30:03.237 What i need to do is to basically get to the point where we have user, total time in system' e.g. user1, 1min 10secs (close!) user2, 6mins 18secs user3, 6mins 40secs any help much appreciated. Thanks, Jon Tag: Want Text box font to be inherited from list
  - 10
    - Query performance problems with join on UDF-based computed column We have a table with a couple of computed columns. The value of the computed column represents a foreign key reference into another table. We're seeing a major performance problem doing a query joining between the two tables with one of the columns, but not the other. In other words, this kind of query is very fast: select * from TheTable A, FKeyTable B where A.ComputedColumn1 = B.KeyColumn but this one sends the CPU usage of SQL Server to 99% for a very long time: select * from TheTable A, FKeyTable B where A.ComputedColumn2 = B.KeyColumn The main difference we can see that the computed column that causes problems is based on a UDF, and the other one isn't (but again, both are computed). When I look at the execution plan, the slow query shows a Nested Loop (Inner Join) with a "No Join Predicate" warning, with the estimated # of rows being 70 million (which correponds to the product of 1016 rows in TheTable and 69K rows in FKeyTable). The fast query doesn't have that warning, and shows 1016 rows (the # of rows in TheTable). Does anyone know why the usage of a UDF would induce this horribly inefficient join behavior Anything we can do to fix it This is SQL Server 2005 SP2, btw. Tag: Want Text box font to be inherited from list
  - 11
    - Pointers to the best documentation on star joins and the optimiser Hi All, we are just starting to do some testing on sql server EE with dimensional models.....we have had one or two problems we have been able to solve using the new peformance dashboards etc. However, as is inevitable, we are seeing strange behaviour of a query....in a star join it seems to be doing an eager spool and trying to spool the entire fact table to tempdb....hhmmm.... Rather than ask one question at a time.....we have DBAs who went to classes etc at MSFT and the client is some level of MSFT partner. Could anyone point me to the best documentation for understanding the optimiser and how to influence it to get it to do the right thing in optimising plans for star joins Thanks Peter Tag: Want Text box font to be inherited from list
  - 12
    - Multiple Select statements + Stored Procedure Hi all, I have 2 select statements in my Stored Proc. I want to display the results of each query in my DataGridView. However, only the data of the last select query is returned. Why is this Thanks. Tag: Want Text box font to be inherited from list
  - 13
    - hidden views hi , i have created views in database Test, in sqlServer.when i had to export Test to another database Test1, the views become hiddden. i can't see the views and when i try to create them again, i get this msg: There is already an object named 'view1' in the database. so how can i resolve this problem thanks, Tag: Want Text box font to be inherited from list
  - 14
    - Login Failed for <domain name>\<Machine Name> For some reason , the report server is trying to login as <domainname>\<machine name> - its supposed to be <domain>\<user name> or ASPNET or Network Service Authority - I have no clue why it is pickin gup machine name. Any ideas and how to fix Tag: Want Text box font to be inherited from list
  - 15
    - adding client server aliases How can I import a client alias list in SQL Server 2005 Configuration Manager The tool provides a way to export a list, but not to import a list. Adding 100 SQL Server instances via the GUI is time consuming and agonizing. Thanks, Justin Randall Tag: Want Text box font to be inherited from list
  - 16
    - Profiler trace bind variables Hi, Could anyne help me on which options in Profiler could be used to trace the bind variables in DML Given a table, X (col1 number, col2 varchar(10)), where col1 is primary key. Example DML statements: 1) insert into X values (@parameter1, @parameter2) 2) update X set col2 = @parameter2 where col1 = @parameter1 3) delete X where col1 = @parameter1 where @parameter1 and @parameter2 are bind variables. Can Profiler be configured to log the actual values of @parameter1 and @parameter2 in the example statements in trace log Thanks a lot. Tag: Want Text box font to be inherited from list

Leroy Mason487636

I want to set properties such as font family, font size, etc as high as possble in the report.

Is it possible to have textbox fonts inherited from a container like a list, or report

Currently it seems I need to set fonts on every textbox.

Similarly, when I use report designer to put a textbox on a report, the textbox decides the Font is Normal, Arial, 10pt, Normal. Where is this setting stored

Top

Re: Want Text box font to be inherited from list

keisuke

Hello,

Not sure if this will help, but every report in srs is an xml file, right click on the rdl file and click view code (xml)

You can use CSS (cascading style sheet) with xml, an example is:

An xml file w/out css:
http://www.w3schools.com/xml/cd_catalog.xml

The CSS:
http://www.w3schools.com/xml/cd_catalog.txt

An xml file w/ css:
http://www.w3schools.com/xml/cd_catalog_with_css.xml

Taken from: http://www.w3schools.com/xml/xml_display.asp

Top