Different Font size when browsing and printing a report ?

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - Cancelling a process in SQL Server using ASP. Well using VBScript you would only be able to use a kill command to stop a running process. Once the process is started, it cannot be stopped. (Beside some secret commands :-) ) Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: Different Font size when browsing and printing a report ?
  - 2
    - Inline table-valued function with multi-value parameter Is your database engine SQL Server 2000 or SQL Server 2005 Tag: Different Font size when browsing and printing a report ?
  - 3
    - Memory Problem, please help It looks like you are running 32-bit SQL Server 2005. If so, you need to make sure that your boot.ini file has the /3GB switch in the boot.ini file (at the root of your C: drive). Then you need to enable AWE in SQL Server 2005. I would also suggest that you give the SQL Server Service Account the "Lock Pages in Memory" right. This will allow SQL Server to use more than 2GB of memory and will allow SQL to control paging itself. Tag: Different Font size when browsing and printing a report ?
  - 4
    - How linear regression choose his regressor ? When you build the model using the wizard, all continuous input columns are flagged as regressors. You can check this by looking at the Modeling Flags property of each input column in the designer. (edit) Jamie points out to me that the modeling flags only indicate potential regressors. The actual regressors are determined by the internals of the algorithm. We have no public documentation available on that process, but we can aim to provide more detail in future docs or whitepapers. Tag: Different Font size when browsing and printing a report ?
  - 5
    - FTI on whole Database NO, and I can't imagine why one would consider that as a possibility. I wouldn't consider searching datetime columns, or money columns, or numeric columns for a text string. So even if it were possible, it would amount to a terrible waste of time/effort searching unnecessary columns. As well as significant resources just to create and maintain indexes on columns that may never need to be searched. Tag: Different Font size when browsing and printing a report ?
  - 6
    - Using Database Mail to notify job failures help? I need to create an operator and the operator then appears in the notify list. If if then assign the operator an E-mail address the failed job reports "Failed to notify 'OPERATOR' via email." Do I need to somehow associate the operator with my database mail profile Tag: Different Font size when browsing and printing a report ?
  - 7
    - what permission do I need to grant ? So there are a couple ways to do this and a couple "it depends" situations but basically there are two logins/users involved here: 1.) The server you are LINKING TO (SrvB is what I'll call it)... This server needs to have a login and a user assigned to proper permissions. 2.) The server you are LINKING FROM (SrvA is what I'll call it)... This server also needs to have a login to be used. Now the way I normally do this when needing to be restrictive is.... I normally already have a user on SrvA that I want to grant the permissiosn to, so on SrvB I will create a login for that user ( SQL Auth), I will then map that login to be a user in the necessary database on SrvB and give that user read access to the table required. Now back on SrvA, I will go to the Linked Server security dialog and I pick the local login from SrvA I want to talk to SrvB, for the remote user I provide the credentials I created on SrvB. Now that one user has the required access on SrvB. I also normally would check the radio button for "Not be made..." when discussing what to do with logins not defined above. Tag: Different Font size when browsing and printing a report ?
  - 8
    - Importing Data Into XML Column - UPDATED One thing I did find...if I just run the portion of the query that selects the columns for my XML column, the query runs, but doesn't give the expected results. It concatenates everything into one long string... <CustomColumns><row><CN_CUST_KEY>1000422</CN_CUST_KEY><ITM_SUF_NO>9</ITM_SUF_NO><Model>11073954200</Model><SaleYear>2003</SaleYear><SaleDate>2003-08-23 00:00:00</SaleDate><prd_itm_no>73954</prd_itm_no></row><row><CN_CUST_KEY>1000812</CN_CUST_KEY><ITM_SUF_NO>13</ITM_SUF_NO><Model>11063932101</Model><Serial>MM2610444</Serial><SaleYear>2002</SaleYear><SaleDate>2002-08-26 00:00:00</SaleDate><prd_itm_no>63932</prd_itm_no></row><row><CN_CUST_KEY>1001610</CN_CUST_KEY><ITM_SUF_NO>14</ITM_SUF_NO><Model>11062952100</Model><SaleYear>2002</SaleYear><SaleDate>2002-02-03 00:00:00</SaleDate><prd_itm_no>62952</prd_itm_no></row><row><CN_CUST_KEY>1004682</CN_CUST_KEY><ITM_SUF_NO>15</ITM_SUF_NO><Model>11072932100</Model><Serial>ML140325</Serial><SaleYear>2001</SaleYear><SaleDate>2001-04-21 00:00:00</SaleDate><prd_itm_no>72932</prd_itm_no></row><row><CN_CUST_KEY>1004867</CN_CUST_KEY><ITM_SUF_NO>12</ITM_SUF_NO><Model>11073952200</Model><SaleYear>2003</SaleYear><SaleDate>2003-04-08 00:00:00</SaleDate><prd_itm_no>73952</prd_itm_no></row><row><CN_CUST_KEY>1005117</CN_CUST_KEY><ITM_SUF_NO>7</ITM_SUF_NO><Model>11072972100</Model><SaleYear>2002</SaleYear><SaleDate>2002-02-18 00:00:00</SaleDate><prd_itm_no>72972</prd_itm_no></row><row><CN_CUST_KEY>1005320</CN_CUST_KEY><ITM_SUF_NO>27</ITM_SUF_NO><Model>11072972100</Model><SaleYear>2001</SaleYear><SaleDate>2001-08-28 -07-01 00:00:00</SaleDate><prd_itm_no>73942</prd_itm_no></row><row><CN_CUST_KEY>5806620</CN_CUST_KEY><ITM_SUF_NO>2</ITM_SUF_NO><Model>11062952100</Model><Serial>ML4334523</Serial><SaleYear>2002</SaleYear><SaleDate>2002-02-17 It also is inserting the <row> tag as opposed to actually creating an entirely new row. And lastly, the <CustomColumns> tag should encapsulate/wrap each record. When I run the select, every single row is contained within <CustomColumns>... Tag: Different Font size when browsing and printing a report ?
  - 9
    - Passing Parameter to another Report using Jump to URL option in Reporting Services 2005 When passing parameters to reports, these firstly have to exist within the target report. Hence you nee to edit the "Sales Order Detail" and add the SalesOrderNumber parameter. Then with the report you will be able to refere to it as: Parameters!SalesOrderNumber.Value Tag: Different Font size when browsing and printing a report ?
  - 10
    - SQL 2005 Cannot Drop User The user has granted someone access to an object, therefore he cannot be removed / dropped. See the query for the granted objects: SELECT * FROM sysprotects WHERE grantor = USER_ID ( 'Yourusername' ) HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: Different Font size when browsing and printing a report ?
  - 11
    - Updating only changed fields When an update occurs, the entire row (disregarding lock escalation here) is locked and not just the updated column(s). Spending time sorting through each value might actually cost you more, especially if you have to requery the table for the current values. I think the key here is to minimize data transfer from the client to the server. If you know for sure you only have to update a few columns, then just pass those updated values back and not the entire row. Tag: Different Font size when browsing and printing a report ?
  - 12
    - Should i upgrade to SP2 ? Yes its always better to use the latest service packs as it will fix most of the bugs from the previous one..... http://www.microsoft.com/downloads/details.aspx FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en features of sp2 http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/WhatsNewSQL2005SP2.htm as far as i know most of the maintenance plan problems are fixed in SP2 Tag: Different Font size when browsing and printing a report ?
  - 13
    - Which SQL Server 2000 Edition should I install in at UAT environment You have two options create the UAT database in the same server as production or install the same edition as production in a different server but with CALs so you pay for just the testers license to use the product. Hope this helps. Tag: Different Font size when browsing and printing a report ?
  - 14
    - Error processing Cube - The syntax for ',' is incorrect. If you have a new issue, please create a new thread rather than just replying to an old one. You are more likely to get an answer. It sounds like there might possibly be an extra comma in your MDX script. It looks like it is at character 10 on the first line (that's what the 1,10 means) Tag: Different Font size when browsing and printing a report ?
  - 15
    - Rerunning failed subscriptions We're using RS2005 SP1. One of our users has subscribed to a report to run the 15th of each month. This past July 15 was on a Sunday and our servers were down for backing up & maintenance. Since the servers were down, the job never ran and the user did not receive the report they were expecting Is there anyway to have jobs that failed to run because a server was down automatically run when the server comes back online Or perhaps have maintenance windows during which reports can not be scheduled to be run TIA -bruce Tag: Different Font size when browsing and printing a report ?
  - 16
    - SQL Server Data Migration and Synchronization You cant replicate from 2000 to 2005 only the other way around so you would have to replicate to 2000 first then do an upgrade when they are transferred over. Replication is no small task, just replicating 1 database and making sure it works all the time is a huge effort. To maintain 200 of those would require a large team of people. However to prevent downtime your scenario may work. I would however only replicate 1 or 2 at a time as there will be a significant load increase on the server. Are you taking about moving them to different sites or different machines at the same site If its different machines you could either move the db files to an NAS array and then just point the new machine to the drive when you are ready to switch over that would only give you a few seconds of downtime per database. As for shipping them to a different site I dont see any way both databases could be 100% in sync all the time. Transactional replication is probibly your best bet for that. If you are looking to upgrade to 2005 you could also consider doing the upgrade on the machine you are using now then using log shipping to move stuff to the new machine. That could give you about 5 minutes of latency between old and new with zero downtime. I'm sure someone else will also have another few suggestions for you. Martin Tag: Different Font size when browsing and printing a report ?
- Next
  - 1
    - Analysis Services - Step by Step: Errors related to feature availability and configuration Yes, you are running into this situation because you working against Standard edition of SQL Server Analysis Services. You can install free trial edition from http://www.microsoft.com/sql/downloads/trial-software.mspx . It has full set of features for you to comlete any tutorial. As for the steps described in the book, or how to work around them. You should point your questions to the authors of the book. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. Tag: Different Font size when browsing and printing a report ?
  - 2
    - SSIS Job Failed Obvious not enough information here. One suggestion, enable SQL logging. :) Tag: Different Font size when browsing and printing a report ?
  - 3
    - Creating a Mobile Application with SQL Server Compact Edition This sample is a download only scenario. Are you still running this code in form_Load : Code Snippet private void Form1_Load(object sender, EventArgs e) { DeleteDB(); Sync(); // TODO: Delete this line of code. this.flightDataTableAdapter.Fill(this.sqlmobileDataSet.FlightData); // TODO: Delete this line of code. this.membershipDataTableAdapter.Fill(this.sqlmobileDataSet.MembershipData); } This sample allows two way sync: http://technet.microsoft.com/en-us/library/ms346580.aspx and so does this Hands On Lab: http://msdn2.microsoft.com/en-us/library/aa454892.aspx Tag: Different Font size when browsing and printing a report ?
  - 4
    - Use of a SSIS variable of type ��Object�� inside Script Component and Task Component Inside your script component, you can create an array (or list) and store the value of each of your 'n' variables into the array. You then assign the array to the Object type SSIS variable. To read from the SSIS variable after exiting dataflow, you can use the 'Foreach loop" container which a standard control flow item. Even if you try to use the script task to read from the ssis variable, getting the element from an array is definitely easier than parsing for the data. If I haev misunderstood your problem, please clarify. Thanks Cho Tag: Different Font size when browsing and printing a report ?
  - 5
    - How to debug CLR SP using Visual Studio 2005? Ok I got it. I have to manually load .PDB as well: CREATE ASSEMBLY ExecuteExternalReturnTable FROM '<...>\ExecuteExternalReturnTable\bin\Debug\ExecuteExternalReturnTable.dll' WITH PERMISSION_SET = UNSAFE ; ALTER ASSEMBLY ExecuteExternalReturnTable ADD FILE FROM \'<...>\ExecuteExternalReturnTable\bin\Debug\ExecuteExternalReturnTable.pdb' Then I can attach to SQL Server and my breakpoints will work. Tag: Different Font size when browsing and printing a report ?
  - 6
    - reporting and monitoring Jason - there are no dumb questions. Everyone in this forum is new to SQL Server, so it's OK not to know something. I've done a series of articles on this topic that might help, and I've included links at the bottom of each that will reference other sites. Start with this topic and then use the links on the left of the page to move around, or click the "Next Section" link at the bottom of each. This site also has some other practical articles that might help you out if you're new to SQL Server. http://www.informit.com/guides/content.asp g=sqlserver&seqNum=195&rl=1 (If this answers your question, make sure you mark it as answered so that others can find it) Tag: Different Font size when browsing and printing a report ?
  - 7
    - SQL 2005 Query Analyzer Query Analyzer does not come with SQL 2005. QA has been replaced with SQL Server Management Studio -a combination of the previous QA and Enterprise Manager. I don't think that the client tools install by default when you install a server. You may have to run the install again, this time selecting the Client Tools instead of the server. Then you 'should' have SQL Sever Management Studio on your Programs menu (as well as a few other client tools.) Tag: Different Font size when browsing and printing a report ?
  - 8
    - "Can't find PInvoke DLL 'dbnetlib.dll'." If you indeed have SQL Client installed properly, I would guess some dependencies required for it to function are missing from the OS image. Contact device OEM for help. Tag: Different Font size when browsing and printing a report ?
  - 9
    - Number of reads in Profiler is not the same when running the same SP on different PCs The question is whether you are running it against the same dataset on the two PCs and if so how you moved/synchronised that data between the PCs. Also it is worth looking at the query plans to determine if it is using different strategies. Can you provide more information Tag: Different Font size when browsing and printing a report ?
  - 10
    - Problem when exporting data into Excel file from SSIS I too am experiencing this problem. Have you discovered a solution Tag: Different Font size when browsing and printing a report ?
  - 11
    - adding a new data flow item calendar transformer You need to right-click in the toolbox, click on 'choose items...' and then click the 'ssis data flow items' tab and select your new component. Tag: Different Font size when browsing and printing a report ?
  - 12
    - Find and delete reversed key pairs. delete from airports where origCity>destCity and exists (select * from airports a2 where a2.origCity=airports.destCity and a2.destCity=airports.origCity) Tag: Different Font size when browsing and printing a report ?
  - 13
    - Can I create a database schema from a DataSet and/or .xsd file? You can do that by loading schema into DataSet and looping through DataSet's tables, columns, relations, etc., generating respective SQL command and executing them. E.g. you loop through tables in DataSet and execute "Create Table" command for each. I would not say it��s easier than using designers but by all means you can do it. Tag: Different Font size when browsing and printing a report ?
  - 14
    - Can't reinstall sql server 2005 express Hi, This is what I would try: First, make sure that you are logged in with an administrator-level login. Second, reboot the computer and try the install again. Third, ensure that you do not have any copies of any version of SQL installed (and showing in add/remove programs). Forth, try installing again. Finally, check to ensure that you have the correct connection protocols (TCP/IP, Named Pipes, etc.) enabled and that your firewall (either a physical one or Windows Firewall is configured to allow traffic in on port 1433) With regards to error 26 -- were you getting that from SSMS (management studio) or from an application that is trying to connect to it Was this on your local machine or a remote one Some information about error 26 in ASP.Net is located here: http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx Some information about error 26 in the management studio is located here: http://www.datamasker.com/SSE2005_NetworkCfg.htm - Jeremy Tag: Different Font size when browsing and printing a report ?
  - 15
    - How to protect my parameters Actually, if you mark it as internal, and then try to pass it in an URL, you get the error: The report parameter 'ClientKey' is read-only and cannot be modified. (rsReadOnlyReportParameter) peace BobP Tag: Different Font size when browsing and printing a report ?
  - 16
    - Check to see if file exist on server I could be wrong, but I dont think you can use http in FileExists. It has to be a file system path. FileExists(" \\salesserver\share\file.pdf ") BobP Tag: Different Font size when browsing and printing a report ?

Aiwa

Hi all,

Is it possible to setup different font size when a user is browsing or printing a report

I have a lot of data to print on a report and i need tu use a font size of 7pt which is fine for printing but when the user is looking at the report on the browser a font size of 7pt is a bit too small and the bold doesn't work.

Tia

Top

Re: Different Font size when browsing and printing a report ?

Andrew Sears - T4G

You can use a parameter (Web, Print) which would specify the font size 7, 12, and set the font property on the textbox to use the =Parameters!FontSize.Value + 'pt' expression.

I don't think the report can tell whether it's being printed or not internally.

cheers,

Andrwe

Top

Re: Different Font size when browsing and printing a report ?

Aiwa

Thanks Andrew,

I was hoping to find a way to do this without prompting the user beforehand.

Regards,

Eric

Top