Reporting Services Preview View different from Print Layout

SQL Server Reporting Services

Index ‹ SQL Server
- Archive
  - Visual C#
  - VS 2008
  - ISV
  - Windows Live
  - IE
  - VS Express
  - SharePoint
  - Dotnet
  - Windows Vista
  - Game
  - Smart Device
  - VC++
  - VB
  - Office
  - Architecture
  - Visual Studio
  - VFP
  - Windows Forms
  - SQL Server

- Previous
  - 1
    - Need basic guidance on massive access to sql conversion I have a rather daunting task ahead of me. I have ot take an access mdb and bring it into sql express. Converting the tables is not a biggie, but I have more than 2500 queries that need to be brought over. I have several questions. 1. In many places I use queries with parameters as views. For example I might have a query that takes a couple of parameters and then turn around write another query that uses the first query as a table. Is there a way to do parameterized views in Sql 2. Does anyone know of a decent automated tool to do this The upsizing wizard is useless and I tried teh sql migration assistant, and it doesn't convert queries that have parameters. 3. Has anyone done anything on this kind of scale before Thanks ... Ed Tag: Reporting Services Preview View different from Print Layout
  - 2
    - choosing a collation in SQL 2005 My understanding is binary collations do not sort in order you may expect. I'm not sure it's the best unless you know you need it. But, I'm not expert and am interested in an experts opinion. Tag: Reporting Services Preview View different from Print Layout
  - 3
    - table scan Hi All, When an end user view a report using report manager or a custom build web site, would query of the report scan the tables in original data base In this case it is a OLTP data base. Thanks Tag: Reporting Services Preview View different from Print Layout
  - 4
    - Foreign Key Constraint issues!! Hello! Im in a bit of a jam, and before I start pulling my hair out, I was wondering if someone could help me with this! We've setup and have been running our backend database for our new site for about two or three weeks, now. Everything has been running fine, except we've hit a little bump. When a User creates an account on our website, they have to specify which Organization they are with. Inside the database, this creates a record in the Users table, which then creates a new record in a UserOrganizations table. After these actions have taken place, a record is created in a UserOrganizationsAdded table. All of this is purely to keep track of people on our website. Below is a basic outline of our tables. Users ---------- UserID Username Pasword . . . UserOrganizations --------------------------- UserOrganizationID UserID OrganizationID RoleID . . . UserOrganizationAdded --------------------------------- UserOrganizationAdded UserOrganizationID Added AddedBy . . . Now- When a User registers on our site, it shows up in the UserOrganizationAdded table that they've added themself. In other words their UserID shows up in the AddedBy field of the UserOrganizationAdded table. This is what we want. However, we run into the problem, that if a User is for whatever reason rejected from our site, and their record deleted from the Users table, we get a foreign key error. I understand that we get this error because AddedBy is referencing UserID (the very thing we want to delete), and we are receiving this error because they are the same value. I guess my question is, is there anything we can do to keep the reference constraint between AddedBy and UserID and still be able to delete users Any help would be much appreciated!!!! Thank you! Tag: Reporting Services Preview View different from Print Layout
  - 5
    - Help in Query? i have a table for staff allocation.i need to allocated them for class input table Staffid Class Subject Priority Hours hrspday 2 7 1 2 10 2 1 7 5 2 10 2 2 1 1 3 10 2 1 5 1 3 10 2 3 1 31 3 8 2 o/p must be in first row staff id is 2 goes to class 7 for 10 hrs in week 2 hrs per day so output must be like this staff id class subject 2 1,1 7 1 2 1,4 7 1 2 2,1 7 1 goes on.............. here id 1,1 represent mon first peroid similiarly 1,4 means mon 4th hour so plz me tell query to generate output like this ... Tag: Reporting Services Preview View different from Print Layout
  - 6
    - x64 version of Microsoft .NET Data Provider for mySAP Business Suite Hi everybody, Does anyone know if there is a x64 version of the Microsoft .NET Data Provider for mySAP Business Suite for use with SSIS On the SAP site, I found a librfc32.dll which works under x64, but the x86 SAP Connector can't use it. Thanks Hans Tag: Reporting Services Preview View different from Print Layout
  - 7
    - How do I automate removal of reports? here is our setup: i have a bunch of environments set up in the config mgr : uat, dev, prod, etc each one points to a different deployment folder (the 6 environments are spread over 3 physical boxes, fyi) 'overwrite datasources' is set to false (this is a project properties (pages not the properties window) setting) i deploy to each of the environments as required the first time you deploy, you will need to go and set the connection string information for the given datasources on the report server, using report manager thereafter, the deployment will NOT overwrite the datasources as per the option you set so you can deploy a report to dev, test it, ok deploy the same report to uat, test it, ok deploy to production you will never need to go and change the connection string info again after this one time configuration NB you may wish to have the configs in separate projects to avoid accidentally deploying to production! sorry it is a bit rushed, let me know if not clear Tag: Reporting Services Preview View different from Print Layout
  - 8
    - User credentials delegation from IIS on WinXP to SQL Server on Win2003SRV fails SPN is set and registered. I think once user credentials are authenticated against IIS and primary token established identity is not being passed to connect to SQL Server. Application log event indicates "Authenticaton Type" to be "negotiate" instead of "NTLM" or "Kerberos" and 'Is Impersonated" to be "false" which leaves me to assume that double hop fails as Kerberos authentication is not the authentication type it resolves to. Thank You. Tag: Reporting Services Preview View different from Print Layout
  - 9
    - Running SSIS package (.dtsx) from a ASP.Net web service Where do I find about running an SSIS package (.dtsx) from a ASP.Net web service, particularly issues to do with permissions cheers Rob Tag: Reporting Services Preview View different from Print Layout
  - 10
    - ExecuteNonQuery hangs in Timer event notification If I call ExecuteNonQuery() in a timer event callback in a console application, it hangs. Why is that .B ekiM class Program { static SqlConnection conn = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=NONEOFYOURBISUINESS;Data Source=localhost"); static void Main(string[] args) { NativeMethods.MEMORYSTATUSEX mem = new NativeMethods.MEMORYSTATUSEX(); NativeMethods.GlobalMemoryStatusEx(mem); Console.WriteLine("{0} bytes", mem.ullAvailPhys); System.Timers.Timer aTimer = new System.Timers.Timer(); // Set the Interval to 2 seconds (2000 milliseconds). aTimer.Interval = 1000; aTimer.Enabled = true; // Hook up the Elapsed event for the timer. aTimer.Elapsed += new ElapsedEventHandler(OnTimedEvent); Console.ReadLine(); } private static void OnTimedEvent(object source, ElapsedEventArgs e) { NativeMethods.MEMORYSTATUSEX mem = new NativeMethods.MEMORYSTATUSEX(); NativeMethods.GlobalMemoryStatusEx(mem); SqlCommand cmd = new SqlCommand( "INSERT INTO Observation (StatisticType, StatisticObserved, StatisticValue) VALUES (1, @When, @AvailPhys);\n" + "INSERT INTO Observation (StatisticType, StatisticObserved, StatisticValue) VALUES (2, @When, @AvailPageFile);\n" + "INSERT INTO Observation (StatisticType, StatisticObserved, StatisticValue) VALUES (3, @When, @AvailVirtual);\n" + "INSERT INTO Observation (StatisticType, StatisticObserved, StatisticValue) VALUES (4, @When, @AvailExtendedVirtual);\n"); DateTime dt = DateTime.Now; cmd.Parameters.AddWithValue("AvailPhys", mem.ullAvailPhys); cmd.Parameters.AddWithValue("AvailPageFile", mem.ullAvailPageFile); cmd.Parameters.AddWithValue("AvailVirtual", mem.ullAvailVirtual); cmd.Parameters.AddWithValue("AvailExtendedVirtual", mem.ullAvailExtendedVirtual); cmd.Parameters.AddWithValue("When", dt); cmd.ExecuteNonQuery(); Console.WriteLine("Inserted {0}", dt); } } Tag: Reporting Services Preview View different from Print Layout
  - 11
    - Cannot get access to my Access 2003 database tables I developed a database with Access 2003 and everything was working good until my tech came in and reformated my hard drive and install a new Ghost image that met our company standards. Now I cannot go in and make any changes to any of the tables, queries and forms. All of this started when a new Ghost image was installed on my pc. The message I get when I try to open my database is "You do not have permission to run "tblSwitchboard." I get the same error message when I try to do anything at all on the database. I am at a loss as to what to do. Please help. Tag: Reporting Services Preview View different from Print Layout
  - 12
    - Combine two stored procedure results Hi, Which one give better performance whether the Stored procedure with table datatype to insert the combined results from two databases, Or table valued functions. Thanks. Tag: Reporting Services Preview View different from Print Layout
  - 13
    - soap message exchange between .NET Webservice and stored procedure Thanks for your help! But how can i call a web-service from a clr based proc Do you know where i can get an example pamelia Tag: Reporting Services Preview View different from Print Layout
  - 14
    - Shared Connections and Stored Credentials for Subscriptions? Thanks Jarret, Your right, there are so many places that you can set credentials (Viusual Studio, SQL Server Management Studio/Report Server and Report Manager) and so many options (Integerated Wondows Security, Windows log in etc) it is difficult to test thiem all when you have limited time (i.e. most of the time). I did check the "Use as Windows credentials when connecting to the data source" check box at one stage and that seemd to help but if I re-depolyed the report and looked at the Properties/Data tab in the Report Manager, it was overwritten and set back to Integrated Windows Secuirty (the original setting for the Shared Data Source as configured in Visual Studio). Are you saying that I can't use Integrated Windows Security at all if I want configure subscriptions (I think that is what you are saying) Is the alernative to go to "Credentials" tab for the Shared Data Source and set "Use a specific user name and password" I think that I gave that a try but i was trying lots of different options in a short space of time. In the end. the main problem was the configuration on the Report Server Propertes/Data tab being changes whenever the report was re-deployed from Visual Studio (sorry the SQL Server BI Development Studio ) I am beginning to think that i need to do both of the above (paragraohs 2 and 3) Having d Tag: Reporting Services Preview View different from Print Layout
  - 15
    - T-SQL / varchar truncate solutions Why does SQL Server truncate the data being stuffed into "@vt" without throwing some kind of error or warning The print statement puts "123456" into the output window. Believe it or not .. our development team is actually trying to use this minor issue as justification for going with Oracle on this project, because they deem this as a data integrity issue and PL/SQL does throw an error. They would prefer to have an error thrown, instead of just silently truncating the data. declare @vt varchar(6) select @vt = '12345678' print @vt Is there a way that I can get T-SQL to throw an error or warning when this occurs I thought a UDT with a rule applied to it might do the trick, but that hasn't worked for some reason. Or any other creative solutions that you can think of Thank you, Mark Tag: Reporting Services Preview View different from Print Layout
  - 16
    - Data Flow Task Stuck When I try them sequentially, it works correctly every time. This is an acceptable workaround, but I am still curious to determine the reason for this strange behavio Tag: Reporting Services Preview View different from Print Layout
- Next
  - 1
    - Delete row where a particular field value is not in a list I have a table which has a field called filename, thus the data in the field would look something like this: FileName.doc FileName.txt FileName.foo I need to delete several rows from this table where the filename field DOES NOT contain the following extensions (e.g. row with FileName.foo would be deleted): .txt .pdf .rtf .doc .htm .html .mht .mhtml .dot .wk1 .wk3 .wk4 .xls .xlw .asc .olk .pab .scd .ans .wri .mcw .wpd .wps .ppt .pps .xls .xlt .xlw Tag: Reporting Services Preview View different from Print Layout
  - 2
    - SSRS Performance Hi All, I am facing an issue while working with huge data in tables. I have a stored procedure which when exceuted on SQL Server Browser takes little time to display the output on the screen. The same stored procedure is used by the application with SQL Server Reporting Services to generate the report. When executed, the application stops responding after sometime. After debugging steps by steps, I found that the dataset fetches the records from database using stored procedure takes around 11 mins and application stops responding while generating the reports. Now, does this happens with some performance related issue with SQL Server Reporting Services or Do I need to modify stored procedure Tag: Reporting Services Preview View different from Print Layout
  - 3
    - Does fragmentation changes after backup/restore operation? Hello, If i backup a database and then restore it, would physical structure remain the same specially fragmentation. I'm concerned about output of DBCC SHOWCONTIG. Senario: I want to check if client database needs defragmentation, so he's sending db backup file. But is it possible that when i restore it fragmentation info has got lost Thank you. STG Labs Tag: Reporting Services Preview View different from Print Layout
  - 4
    - sp_spaceused equivalent in CE? I am looking for a way to programatically determine the size of the data contained in a table, much like the sp_spaceused proc in SQL Server. Thanks. Tag: Reporting Services Preview View different from Print Layout
  - 5
    - Wat's the effective way to improve performance in table using indexing? I see. How about transaction_ID (primary key) Is it take transaction_Date as non-cluster index n transaction_ID as unique cluster index as the conclusion Best Regards, Hans . Tag: Reporting Services Preview View different from Print Layout
  - 6
    - How to verify installed license I have inherited serveral SQL 2000 servers and need to know if there is a way to verify the license that was installed, per processor or Server + Cals. Thanks, Skip Berry Tag: Reporting Services Preview View different from Print Layout
  - 7
    - How to rename a column or table on the desktop? I am using the compact edition on a desktop using VS2005 as well as SQL Server Management Studio. None of those tools allow me to rename a column or rename a table. Can someone point me a tool the runs on the desktop (as opposed to running on a CE device) that allows me to do the renaming Thanks Tag: Reporting Services Preview View different from Print Layout
  - 8
    - CAB Files Can anyone Please point me to a place that I can find some documentation on what the sql.ppc.wce5.armv4i.CAB does I basically need to know which files are being placed in the handset by deplyoing the CAB file. Thanks, Farnaz Tag: Reporting Services Preview View different from Print Layout
  - 9
    - Executing an SSIS package containing Analysis Services from ASP.NET Thanks for the reply. I have 2 machines, my web server and db server. After reading through the information in your link I think I need to clarify my security set up to check its definitely the 'double hop' problem. The identity that I'm impersonating is one created for this appication to use, not specific to the user. The identity has been created as a login on my db server and a user on the db I'm connecting to. This allows me to run an SSIS package containing stored procedures only. The AD user (identity) has been given access to the role required to run the Analysis Services Processing Task which is part of my SSIS package. Is this where the double hop is involved Passing the credentials from IIS to the Analysis Services Task Tag: Reporting Services Preview View different from Print Layout
  - 10
    - Upgrade SQL 2005 Standard to SQL 2005 Enterprise use SKUUPGRADE=1 swtich from the command prompt with setup. Eg : start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb Refer http://msdn2.microsoft.com/en-us/library/ms144259.aspx#skuupgrade Madhu Tag: Reporting Services Preview View different from Print Layout
  - 11
    - SQL Reporting Services performance on navigation pages. kind of what I thought.. thanks for the clarification.. I did find another thread that sort of addresses my issue of slowness on the first load. if you're interested take a look. thank you, Ray http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=477143&SiteID=1 Tag: Reporting Services Preview View different from Print Layout
  - 12
    - Determine if a column is indexed (and the index name) Is there a slick way to determine if all the indexes (if any) for a particular field let's say: tbPeople ID (bigint) FirstName (varchar(50)) LastName (varchar(50)) I need to determine if [FirstName] in indexed anywhere, and if so, what are the name(s) of the indexes. thanks ahead of time. Tag: Reporting Services Preview View different from Print Layout
  - 13
    - Personalize Reports for Each User Glad I could help. Tag: Reporting Services Preview View different from Print Layout
  - 14
    - excel data mining add-in for categorical data Thank you very much for your previous answers conserning clustering algorithm. I change a bit my data and now I can get two and three clusters as I wish. But now I have a different question. I wish to keep my Structure and Model for further trials with different algorithm values, like cardinality. I tried the following I selected in excel Data Mining and then the option cluster button. Then in the cluster wizard I chose analysis service data source and I reform the query as I need adding only at the end where "STAFF_YES" = 1. Then I choose the needed columns and target value. Finally I select browse model, enable drill through only and I finish the wizard and get some results, rather good. But i need to try again with different parameters. I tried Business intelligent Studio to check my Analysis service. The structure were here but when I changed any parameter and I tried to reprocess I got the following messages Processing Mining Structure 'try Structure_1' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Processing Dimension 'try Structure_1 ~MC-__RowIndex' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Processing Dimension Attribute '(All)' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Processing Dimension Attribute 'EPI_CELL_SINO_GOOD' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Processing Dimension Attribute 'EPI_CELL_SINO_LOOSE' completed successfully. Start time: 5/8/2007 4:55:08 �̦�; End time: 5/8/2007 4:55:08 �̦�; Duration: 0:00:00 Errors and Warnings from Response Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: An unexpected error occurred (file 'pcprocbinding.cpp', line 6645, function 'PCDBProcBinding: electOrChangeCartridge'). Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'try Structure_1 ~MC-__RowIndex', Name of 'try Structure_1 ~MC-__RowIndex' was being processed. Errors in the OLAP storage engine: An error occurred while the 'EPI_CELL_SINO_LOOSE' attribute of the 'try Structure_1 ~MC-__RowIndex' dimension from the 'DMAddinsDB2' database was being processed. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: An unexpected error occurred (file 'pcprocbinding.cpp', line 6645, function 'PCDBProcBinding: electOrChangeCartridge'). Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'try Structure_1 ~MC-__RowIndex', Name of 'try Structure_1 ~MC-__RowIndex' was being processed. Errors in the OLAP storage engine: An error occurred while the 'EPI_CELL_SINO_GOOD' attribute of the 'try Structure_1 ~MC-__RowIndex' dimension from the 'DMAddinsDB2' database was being processed. And no change to the structure take place. Please help me if you can Thank you in advnce Best regards. Manolis Tag: Reporting Services Preview View different from Print Layout
  - 15
    - HOW TO DELETE OLD BACK UP FILES AND TRANSACTION LOGS IN SQL 2005 The maintenance cleanup task will work but you need to specify the folder the files are in and the appropriate extension. SP1 does have an option for "include 1st level folders" in this case it will search the folder you specify and one level down. Also I seem to remember that for the backup files or the logs I needed the / at the end of the folder specification and one of them I didn't. We no longer use maintenance plans for backups and I don't remember which it was. Good Luck. Tag: Reporting Services Preview View different from Print Layout
  - 16
    - Embedded image does not appear Hello Torsten, You are running on SP2 Original ( http://www.sqlservercentral.com/columnists/sjones/2960.asp) and I have tested on a 32 bit Win 2003 with the same version of SSRS and don't see the problem. I will have to wait until I get home to test the 64 bit versions. Can you share your images with me It could be image specific. My email is larry at smithmier dot com. Thanks, Larry Tag: Reporting Services Preview View different from Print Layout

Lukebe

I'm currently using Sql server 2005 Reporting Services. I'm trying to take data and fill in a form that I'm making a background image. When I go to preview all the textboxes filled with data align with the fields in the background image form. When I go to print they are off by a inch or so horizontally. Can anyone help me on this topic.

Top