Jump to URL

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - Granting UPDATE for only certain columns in a table Very nice. I have no answer as to why this is, but I will check around and let you know. Tag: Jump to URL
  - 2
    - SSIS - migrating mainframe data to SQL 2005 only mainframe group level exposed Phil, Thanks for marking this answered; however, it has not been successful for me yet. I probably have a performance issue of some kind - I am only doing one column to start and it is running forever. I need to do some work on this to find out what is happening. Also FYI sometimes on the mainframe for a zero an overpunch that gives those letters and symbols that you have listed in SQL does not take place and there is actually a 0 in the sign field in my case I have this so I added a 0 to SQL conversion code. I can see my mainframe data on the mainframe so I know this is a fact. Also I know that for those fields (columns) the value is really zero so I know this is the correct conversion value. Thanks for alll your help, Mary Tag: Jump to URL
  - 3
    - Report Header in SQL Reporting Services kcon wrote: You aren't doing anything wrong per se. There are limitations one being that globals cannot be referenced from the body. However, I don't think you need to use the page number on the visibility of the rectangle in my solution. At least if I understand your issue. If there is one report header for the entire report then there really is not reason for the conditional visibility. I don't understand. Within SQL reporting services you can select to have a Page Header or not. So in my page header I put a Rectangle tool, and set 5 text boxes inside the Rectangle. I then set the Rectangle property to only appear on the first page by using the Expresion I posted in my post above. This works great, my 5 text boxes only appear on the first page. But every page after the first page, there is a large blank white space (2" tall on a landscape style report) that is left empty, because the rectangle property takes up space even though it is invisible. I tried setting two rectangles in the header portion of the report, one with the first page header (report header + page header, which is about 2 1/2") and then another with just the page header information (about 1/2"). Again, the text hides correctly on my pages, but I am left with about 2" of white space at the top of the report on pages 2 - end due to the Report Header information rectangle. I am starting to think there is no way around this, and the users will need to redesign their report specifications. Thank you for your help. Tag: Jump to URL
  - 4
    - No. of User Accounts in SQL SERVER 2000 and SQL SERVER 2005 ..plz See this: http://msdn2.microsoft.com/en-us/library/ms187376.aspx This says in 2005 "you can create more than 32,767 users". I was slightly off with my number in 2000. I thought I read somewhere else about the 64k limit in 2005, but I might be mistaken. I still it is a nighmare to manage 32k logins. Tag: Jump to URL
  - 5
    - Install SQL Server 2005 and SP 2 in one step? Safi, First take full backup of all your databases in sql 2005 before installig SP2 .........then just run the SP2 (critical update) setup file and fill all the required details (pretty simple) once it is done just click ok to reboot the server.....after the server is up check the sql server version by typing select @@version or select serverproperty('productlevel') or execute the below command xp_msver in ssms you'll get the desired o/p refer http://support.microsoft.com/kb/321185 ..........if the installation fails and you cannot access sql server you have your full backup which you can restore Thanxx Deepak Tag: Jump to URL
  - 6
    - SSRS page break Level 1 is only there for a grand total.. Changing codes at this level does not help. I have tried different sequences on the groups, different sorts, sorting the group, sorting the report, include repeating headers, excluding headers...... I have not found the combination i'm looking for. yet. I was really hoping that there was a "magic" check box to handle "first time through" . I do appreciate your input. Tag: Jump to URL
  - 7
    - MultiValue Parameter Help the JOIN she is referring to is not a sql command but a vb function. Tag: Jump to URL
  - 8
    - Time Parameter expression needed Are those two different parameters expressions, or should they be in the same expression Tag: Jump to URL
  - 9
    - formula in a query I tryed but i have an error in the records. I am using the fucntion row_number, but this is supossed to be in order, but the problem I think is the formula that I am running I have ceros vavlues in my records. for example a/b + c/d sometimes "b" and "d" are cero and sometimes "a" and "c" are cero and the result cheers edwin seq blasth num site poly pit push bench diameter from to torque rpm ....etc........... 2 2004200739 200739 MOR2 2004055447 05 COR 5150 12.25 20 1.082675 2.16535 5539.292 0 1475.122 0.02263775 0 10 2004200739 200739 MOR2 2004055447 05 COR 5150 12.25 20 9.678457 10.76113 3381.126 0 2138.927 0.1233593 0 13 2004200739 200739 MOR2 2004055447 05 COR 5150 12.25 20 12.92648 13.97635 4354.548 0 2138.927 0.09219141 0 14 2004200739 200739 MOR2 2004055447 05 COR 5150 12.25 20 13.97635 15.05902 3630.664 0 2212.683 0.1026901 0 15 2004200739 200739 MOR2 2004055447 05 COR 5150 12.25 20 15.05902 16.1417 3765.549 0 2286.439 0.09055099 0 Tag: Jump to URL
  - 10
    - adding 500 more columns to existing table Dear Friends, what is best and quicker way to add 500 columns to existing table having 145 columns already. Is there any way to avoid manual work of adding columns one by one in design mode or using script. I have a TXT file (comma delimited) that contains all those columns names as a first row,but I am not sure if i can use DTS package to create table design having such sourcre TXT file. Any advice Thanks, Tag: Jump to URL
  - 11
    - how can i get connected to SQL management express using windows authentication Once you have made sure that the SQL Express Instance service is running, please follow the following article to make sure Remote Connections are enabled: http://support.microsoft.com/kb/914277 Even after doing this, if you still receive an error, please post the entire error message here. HTH Tag: Jump to URL
  - 12
    - Service Pack 2 Failure Have not found a solution to this yet. Tag: Jump to URL
  - 13
    - messages stuck in sys.transmission_queue I am puzzled myself. My recommendation would be to focus on one individual conversation that exposes the problem. Lookup the conversation_handle in sys.transmission_queue for any of the messages stuck (pick one). Starthing from this, investigate as follows: - find the corresponding conversation (that owns the message) in sys.conversation_handles - using the conversation_id, find the peer conversation handle (initiator and target both share the same conversation_id value) - what states are the two conversation endpoints found in the previous step For messages to travel, both should be in CONVERSING state. - check if there are discrepancies between the send_sequence and receive_sequence between the two conversation endpoints. In each direction (initiator to target and target to initiator) there should be a contigous sequence of message numbers: i.e. if initiator's send_sequence is 10 and target's receive_sequence is 5, the messages numbered 5,6..10 should all be in the transmission_queue. See if you can spot any gap (e.g. send_sequence 10, peer's receive_sequence is 9, but message 10 is missing from transmission_queue) or overlap (e.g. send_sequence 10, receive_sequence also 10 but message 10 was not yet deleted from transmission_queue) - monitor again the Profiler broker events, but filter the events only for the conversation you're focusing on. The meaning of each column displayed in the Profiler for broker events is documented here: http://msdn2.microsoft.com/en-us/library/ms186347.aspx and you can filter based on a given conversation_id (the one you're focusing on). HTH, ~ Remus Tag: Jump to URL
  - 14
    - Calculated Average w/o a dimension specified This sort of filtering might be something that is best suited to a .Net stored proc. I think you might need to iterate over the set a couple of times to figure out what you are looking at and which members are at the lowest level on the axis. The best set of stored proc samples I know if is at a project which I contribute to at www.codeplex.com/asstoredprocedures Tag: Jump to URL
  - 15
    - Mirroring problem between pcs in different location (Witness Issue) Thx for the reply but how come I am able to use the exact method in LAN (works with witness server). I already checked that the certificate used by the A is installed on C's master [database] and all the certificates' thumbprint version are match. Here's my sqls for creating certificates as trusted connection : ----------------------------------------------------------------------------------------------------------------------------------- 1) Server A (Principal) -------- 1. ENABLE OUTBOUND CONNECTIONS ON THE PRIMARY -------- BACKUP DATABASE abc To DISK = 'C:\abc.bak' WITH FORMAT GO BACKUP LOG abc TO DISK = 'C:\abc_Log.bak' WITH FORMAT DROP ENDPOINT Mirroring GO DROP CERTIFICATE A_PRIMARY_CERT GO DROP MASTER KEY GO CREATE MASTER KEY ENCRYPTION BY PASSWORD = '123456' GO CREATE CERTIFICATE A_PRIMARY_CERT WITH SUBJECT = 'A_PRIMARY_CERT for database mirroring', START_DATE = '01/11/2006', EXPIRY_DATE = '01/01/2099' GO CREATE ENDPOINT Mirroring STATE = STARTED AS TCP (LISTENER_PORT= 5022, LISTENER_IP = ALL) FOR DATABASE_MIRRORING ( AUTHENTICATION = CERTIFICATE A_PRIMARY_CERT, ENCRYPTION = REQUIRED ALGORITHM AES, ROLE = PARTNER) GO BACKUP CERTIFICATE A_PRIMARY_CERT TO FILE = 'C:\certificates\A_PRIMARY_CERT.cer' GO -- Copy A_PRIMARY_CERT to server B & C (Location path: 'C:\certificates) 2. Server B (Mirror) /* -------- 2. ENABLE OUTBOUND CONNECTIONS ON THE MIRROR -------- */ RESTORE DATABASE abc FROM DISK = 'C:\abc.bak' WITH NORECOVERY GO RESTORE LOG abc FROM DISK = 'C:\abc_Log.bak' WITH NORECOVERY DROP ENDPOINT Mirroring GO DROP CERTIFICATE B_SECONDARY_CERT GO DROP MASTER KEY GO CREATE MASTER KEY ENCRYPTION BY PASSWORD = '123456' GO CREATE CERTIFICATE B_SECONDARY_CERT WITH SUBJECT = A_SECONDARY_CERT for database mirroring', START_DATE = '01/11/2006', EXPIRY_DATE = '01/01/2099' GO CREATE ENDPOINT Mirroring STATE = STARTED AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL) FOR DATABASE_MIRRORING (AUTHENTICATION = CERTIFICATE B_SECONDARY_CERT, ENCRYPTION = REQUIRED ALGORITHM AES, ROLE = ALL) GO BACKUP CERTIFICATE B_SECONDARY_CERT TO FILE = 'C:\certificates\B_SECONDARY_CERT.cer' GO -- Copy B_SECONDARY_CERT to server A & C (Location path: 'C:\certificates) 3. Server C (Witness) /* -------- 3. ENABLE OUTBOUND CONNECTIONS ON THE WITNESS -------- */ DROP ENDPOINT Mirroring GO DROP CERTIFICATE C_WITNESS_CERT GO DROP MASTER KEY GO CREATE MASTER KEY ENCRYPTION BY PASSWORD = '123456' GO CREATE CERTIFICATE C_WITNESS_CERT WITH SUBJECT = 'C_WITNESS_CERT for database mirroring', START_DATE = '01/01/2006', EXPIRY_DATE = '01/01/2099' GO CREATE ENDPOINT Mirroring STATE = STARTED AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL) FOR DATABASE_MIRRORING ( AUTHENTICATION = CERTIFICATE C_WITNESS_CERT, ENCRYPTION = REQUIRED ALGORITHM AES, ROLE = WITNESS) GO BACKUP CERTIFICATE C_WITNESS_CERT TO FILE = 'C:\certificates\C_WITNESS_CERT.cer' GO -- Copy C_WITNESS_CERT to server A & B (Location path: 'C:\certificates) 4) Server A (Principal) -------- 4. ENABLE INBOUND CONNECTIONS ON THE PRIMARY -------- /* enable inbound from the mirror */ DROP CERTIFICATE B_SECONDARY_CERT GO DROP USER MIRROR_SECONDARY_USER GO DROP LOGIN MIRROR_SECONDARY_LOGIN GO CREATE LOGIN MIRROR_SECONDARY_LOGIN WITH PASSWORD = '123456' GO CREATE USER MIRROR_SECONDARY_USER FOR LOGIN MIRROR_SECONDARY_LOGIN GO CREATE CERTIFICATE B_SECONDARY_CERT AUTHORIZATION MIRROR_SECONDARY_USER FROM FILE = 'C:\certificates\B_SECONDARY_CERT.cer' GO GRANT CONNECT ON ENDPOINT::Mirroring TO MIRROR_SECONDARY_LOGIN GO /* enable inbound from the witness */ DROP CERTIFICATE C_WITNESS_CERT GO DROP USER MIRROR_WITNESS_USER GO DROP LOGIN MIRROR_WITNESS_LOGIN GO CREATE LOGIN MIRROR_WITNESS_LOGIN WITH PASSWORD = '123456' CREATE USER MIRROR_WITNESS_USER FOR LOGIN MIRROR_WITNESS_LOGIN GO CREATE CERTIFICATE C_WITNESS_CERT AUTHORIZATION MIRROR_WITNESS_USER FROM FILE = 'C:\certificates\C_WITNESS_CERT.cer' GO GRANT CONNECT ON ENDPOINT::Mirroring TO MIRROR_WITNESS_LOGIN GO 5) Server B (Mirror) /* -------- 5. ENABLE INBOUND CONNECTIONS ON THE MIRROR -------- */ /* enable inbound from the primary */ DROP CERTIFICATE A_PRIMARY_CERT GO DROP USER MIRROR_PRIMARY_USER GO DROP LOGIN MIRROR_PRIMARY_LOGIN GO CREATE LOGIN MIRROR_PRIMARY_LOGIN WITH PASSWORD = '123456' GO CREATE USER MIRROR_PRIMARY_USER FOR LOGIN MIRROR_PRIMARY_LOGIN GO CREATE CERTIFICATE A_PRIMARY_CERT AUTHORIZATION MIRROR_PRIMARY_USER FROM FILE = 'C:\certificates\A_PRIMARY_CERT.cer' GO GRANT CONNECT ON ENDPOINT::Mirroring TO MIRROR_PRIMARY_LOGIN GO /* enable inbound from the witness */ DROP CERTIFICATE C_WITNESS_CERT GO DROP USER MIRROR_WITNESS_USER GO DROP LOGIN MIRROR_WITNESS_LOGIN GO CREATE LOGIN MIRROR_WITNESS_LOGIN WITH PASSWORD = '123456' -- real password used GO CREATE USER MIRROR_WITNESS_USER FOR LOGIN MIRROR_WITNESS_LOGIN GO CREATE CERTIFICATE C_WITNESS_CERT AUTHORIZATION MIRROR_WITNESS_USER FROM FILE = 'C:\certificates\C_WITNESS_CERT.cer' GO GRANT CONNECT ON ENDPOINT::Mirroring TO MIRROR_WITNESS_LOGIN GO 6) Mirror (Server C) /* -------- 6. ENABLE INBOUND CONNECTIONS ON THE WITNESS -------- */ /* enable inbound from the mirror */ DROP CERTIFICATE B_SECONDARY_CERT GO DROP USER MIRROR_SECONDARY_USER GO DROP LOGIN MIRROR_SECONDARY_LOGIN GO CREATE LOGIN MIRROR_SECONDARY_LOGIN WITH PASSWORD = '123456' GO CREATE USER MIRROR_SECONDARY_USER FOR LOGIN MIRROR_SECONDARY_LOGIN GO CREATE CERTIFICATE B_SECONDARY_CERT AUTHORIZATION MIRROR_SECONDARY_USER FROM FILE = 'C:\certificates\B_SECONDARY_CERT.cer' GO GRANT CONNECT ON ENDPOINT::Mirroring TO MIRROR_SECONDARY_LOGIN GO /* enable inbound from the primary */ DROP CERTIFICATE A_PRIMARY_CERT GO DROP USER MIRROR_PRIMARY_USER GO DROP LOGIN MIRROR_PRIMARY_LOGIN GO CREATE LOGIN MIRROR_PRIMARY_LOGIN WITH PASSWORD = '123456' GO CREATE USER MIRROR_PRIMARY_USER FOR LOGIN MIRROR_PRIMARY_LOGIN GO CREATE CERTIFICATE A_PRIMARY_CERT AUTHORIZATION MIRROR_PRIMARY_USER FROM FILE = 'C:\certificates\A_PRIMARY_CERT.cer' GO GRANT CONNECT ON ENDPOINT::Mirroring TO MIRROR_PRIMARY_LOGIN GO ----------------------------------------------------------------------------------------------------------- Is there any wrong for the t-sql scripts Hope can get further assistance here. Thx. Best Regards, Hans Tag: Jump to URL
  - 16
    - Schedule SQL Express BAckup using SQL DMO Well, since you want to schedule automatic backups, and SQL Express doesn't support SQL Agent, I think your only option is to copy the code to a VBScript file and schedule that through Windows Scheduler. The ASP code doesn't help you with the automatic processes so it's superfluous. Tag: Jump to URL
- Next
  - 1
    - Migrating Data from MySQL hi a way to migrate is you import into Access and afzer them you build in SQL-Express the Table structure and import via ODBC the dates into the new table. I have this do somtimes from MySQL to acces and then to SQLExpress 2005 and vice versa sincerly Helmi Tag: Jump to URL
  - 2
    - Cross Domain Windows Endpoint Authentication? Hi Remus Thank You for the reply. I must admit though i am a bit more lost. Either way i cannot even get the first thing to work. We have Domain A and Domain B, i 1 way trust relationship exists between DOmainA and DomainB, that is DomainB trusts DomainA. BUT, if you go onto the sql server instance in DomainB, i can go to Users ANd groups and add a DomainA user, so the instance in DomainB can authenticate DomainB accounts, HOWEVER when i go into sql server management studio and create a new login, DomainA\user , it says that it cannot find sucha user or group, i can click the search by the login name navigate to domainA and find the user but when i click ok i get the same error message, so i really dont know whats going on, since at a windows level i can add DomainA users but not in sql server So obviously there ar emore issues than simply this. Just to clarify the scenario is as follows. Initiator - DomainA Forwarder DomainB Target DomainB - 1 way trust relationship between DomainA - DomainB, DomainB trusts DomainA. Intiator sql service account runs under DomainB user, i want to make the forwarder service account run under a Domain B account but like i said i cannot add the login in sql server even though i can add the user ont he server innormal windows ANyway thanx for the help , this is a serious issue, i think we may open a microsoft case to resolve it today, or move a bunch of servers to the other domain, either way lots of fun awaits. Cheers Tag: Jump to URL
  - 3
    - Periodic "SQL Server Assertion" error So you keep working with error ! Tag: Jump to URL
  - 4
    - pass hidden parameter from one dataset to another I have 2 datasets in my report and I want to pass a field from the 1st dataset as a parameter to the 2nd dataset. How can I do this I tried to set the report parameter from a query using the 1st dataset but the parameter is always equal to the first record in the recordset-it never changes per row. Tag: Jump to URL
  - 5
    - Activation Failure FYI - I was trying to make this work on SQL Server Express and was getting the same error message. This might be because it's not supported, according to: http://msdn2.microsoft.com/en-us/library/ms165636.aspx I don't know, but thought I would share. Cheers, -Richard Tag: Jump to URL
  - 6
    - How To Connect Remote Server's DataBase from another's Server's QueryWindow Please Help Me to do this... Consider i hv already logged in sql server 2005 ip no : 192.168.2.20 db name: framework from this query window is it possible to access the objects(tables,stored porc's) of another server's database for example , sql server 2005 ip no : 192.168.2.21 db name: framework1 ................................................... Im able to access the same server's db objects consider im frame work db declare @qry as nvarchar(max) set @qry= ' use [master] select * from [Sales] ' exec (@qry) ... but when i use use statement like,(its not working) use 192.168.2.21 use [master] Please help me out ..... Tag: Jump to URL
  - 7
    - SSIS I am using Microsoft OLE DB provider for DB2 Tag: Jump to URL
  - 8
    - Help - Can't get Compact Edition to work with CE.NET 4.2 ! Hi Ilya, I'm not sure what you mean by this The OS is CE.NET 4.2 and I've installed the CF 2.0 SP1 and I've tried to install (seperately) SQL Server 2005 Mobile Edition, SQL Server 2005 Compact Edition and the HotFix. What other dependencies are required Tag: Jump to URL
  - 9
    - What solutions make returning from a disaster easier? I'm trying to figure out what solution (replication, mirroring, clustering) would work best for me. I have been reading many articles in BOL and in this forum. Most talk about getting data TO a backup/standby/subscriber, but I can't find a lot of info regarding getting the data BACK after a disaster is over. We have a main office and a disaster recovery facility. Most of the time there are no data updates at the disaster location. So, I need to get data to the disaster facility via WAN (latency is not a huge issue - end of day syncing is fine) for backup purposes. In the event of a disaster, the main office will be offline and data changes will happen at the disaster site. When the disaster is "over" and we return to the main office, what's the best scheme to reverse the data back to the main office to start business again We are a financial company, and have gigabytes of relatively static data. Most changes are current day. So, to snapshot a 100GB database when I know only a few hundred MB changes a day doesn't seem feasible to me. Most replication scenarios (at least from what I see) can't easily "reverse" the replication after a disaster situation. I'm looking at merge replication on a schedule which seems to look good, but was wondering if anyone else has any ideas or suggestions Tag: Jump to URL
  - 10
    - Error while importing Text file using Import Export Wizard OK, time for me to eat some crow. Long story short, turns out there was a corruption being introduced in the flat file from a zip extraction library. I was having this problem with multiple files, all of which had been extracted in the same way. The corruption did not exist in another copy of the file that I had, which is why I was so convinced that there was nothing wrong with the file. The copy of the file that was testing with BULK INSERT directly had the same corruption. My apologies to the SQL team at Microsoft for being so convinced there was a bug here. :-) Dan Tag: Jump to URL
  - 11
    - Read the transaction log (ldf) file. My first post ever :) J-A.G. wrote: I know there exist som applications that can read log files, like Lumigent Log Explorer. But it would be nice with an freeware version TANSTAAFL But in order to learn you can always use something like the undocumented DBCC LOG ( Northwind , - 1 ) Tag: Jump to URL
  - 12
    - SSIS Connection Manager passwords Already tried that, as well as SQL SP2. No luck. Tag: Jump to URL
  - 13
    - How to drill down on fields Hi All , I am new to Sql Server and Reporting services .. I was trying to make a drill down report I have created Grooup on detail row and set the Visibility with one of the group rows just above .. But when preview the report I cannot see any data .. How ever If I Delete the Groups I can see the data .. Is there anything that I am missing Please help Tag: Jump to URL
  - 14
    - System.Data.SqlServerCE.dll reference causes error ... Hello All ... I am attempting to create a program that will run on the PocketPC 2003 environment. I have upgraded Visual Studio to SP1, I have installed SQL Server Compact Edition on my development machine and I have installed SQL Server Compact Edition Tools For Visual Studio on the development machine. I have created a new project Visual Basic - Smart Device - Pocket PC 2003. I have created a form for user input. I build and deploy the form to the Symbol Pocket PC to test - no connection to data and it works. I then add a reference to System.Data.SqlServerCE.dll and rebuild and redeploy the application to the handheld. When I attempt to open the form I receive the following error: psmPocket.exe NotSupportedException System.Drawing.Bitmap at System.Resources.ResourceReader.LoadObjectV2() at System.Resources.ResourceReader.LoadObject() at System.Resources.RuntimeResourceSet.GetObject() at System.Resources.ResourceManager.GetObject() at System.Resources.ResourceManager.GetObject() at pmsPocket.frmSetSOPType.InitializeComponent() at psmPocket.frmSetSOPType..ctor() at System.Reflection.RuntimeContructorInfo.InternalInvoke() at System.Reflection.RuntimeContructorInfo.InternalInvoke() at System.Reflection.ContrcutorInfo.Invoke() at System.Activator.CreateInstance() at MyForms.Create__Instance__() at MyForms.get_frmSetSOPType() at psmPocket.SetSOPType.Main() Now the confusing part is that I haven't changed any of the forms or the code behind the forms, I have simply added the reference to the project. Any idea why adding the reference to System.Data.SqlServerCE.dll would cause the system to start generating these errors I've checked, the install process has loaded the .NET 2 framework to the handheld. And as indicated at the beginning of this message, the application showed the form prior to my adding the reference. Thoughts Thanks ... Tag: Jump to URL
  - 15
    - Deploying reports to MOSS 2007 Hello, I wonder if anyone can help me save the few remaining hairs on my head I am trying to deploy reports created in SQL Server Business Intelligence Development Studio to SharePoint running SQL Server 2005 Reporting Services in SharePoint integrated mode. Whenever I try to deploy a report, the Reporting Services Login window pops up no matter which user/password I provide it won't accept any. I have the Reporting Services database set up to use Windows credentials and my Domain adminstrator account so I presume that this is user that I should be providing when prompted when deploying. Can anyone give me any clues Thanks, Michael Tag: Jump to URL
  - 16
    - How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005 What version of SSIS are you using RTM SP1 SP2 Tag: Jump to URL

Kiranvukkadala

to open a report in a new window

i looked up the following line of code

=window.open('" & Globals!ReportServerUrl & " " & Globals!ReportFolder & "/" & "myreport" & "&rs:Command=Render&rc:toolbar=true','','width=800,height=600,left=10,top=10,resizable=1,menubar=no,location=no,status=no'),_top"

I do not understand what & Globals!ReportServerUrl & " " & Globals!ReportFolder & "/" & "myreport" &

this implies.

I have the current report name as

http://houapps277/ReportServer/Pages/ReportViewer.aspx %2fIMS-Reports%2fCR000648

and I need to jump to

http://houapps277/ReportServer/Pages/ReportViewer.aspx %2fIMS-Reports%2fCR000699

both reports are in same folder IMS-Reports.

Thanks

Re: Jump to URL

rakam

"javascript:void window.open('ReportViewer.aspx %2fCR000699', '_top', 'location=0, menubar=0, toolbar=0, resizable=1, width=800')"

use the above code.

In reportviewer.aspx page you need to write the code as

rptViewer.ServerReport.ReportServerUrl = new Uri(http://Reportservername);

rptViewer.ServerReport.ReportPath = "/IMS-Reports/" + Request.QueryString[0];

rptViewer.ProcessingMode = ProcessingMode.Remote;

Hope it will help you

Rakam.

Re: Jump to URL

Kiranvukkadala

Thanks for the reply rakam,

Where do I write and store reportviewer.aspx

Sorry for being illiterate here.

Thanks

Re: Jump to URL

Rakam

Just use the following code

"javascript:void window.open('http://houapps277/ReportServer/Pages/ReportViewer.aspx %2fIMS-Reports%2fCR000699', '_top', 'location=0, menubar=0, toolbar=0, resizable=1, width=800')"

hope it will work