UnAttended Printing in Reportin Services

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Reporting Svcs
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - How to make comparison characteristics equal for both years (2004 vs.2005)? I was trying to create a simple report to compare two years' sales by region (2004 vs. 2005). We used to have 13 regions before 2005. Now we only have 12 (DOM013 was removed starting 2005). How can I make DOM013 to appear in the comparison table even if we have no data for it in 2005? Any help is appreciated. Keith Tag: UnAttended Printing in Reportin Services Tag: 35415
  - 2
    - Datetime Filter For one of the tables on my report i need to allow only the records where a certain datetime field has Null value. I have not been able to figure out the expression in the filter that would do this. Any ideas? I cannot do this in the select statement as other data regions require records with values in the same field. Tag: UnAttended Printing in Reportin Services Tag: 35414
  - 3
    - Veritas Cluster-Failover Are there special considerations for installing Reporting Services in a clustered SQL environment? Specifically a Veritas cluster in Failover (Active/passive) mode? I know the installer seems to expect you to install to the default directory, but the cluster environment uses multiple named instances of SQL Server- so it is not really possible to use the default. Is there a workaround? thanks, Vince Tag: UnAttended Printing in Reportin Services Tag: 35413
  - 4
    - Report Security over the Internet We need to allow users to access our Reports through the Internet. We authenticate them using our own custom code, and I would like to then allow them to see reports. We've been using the Forms authentication security extension, but I'm wondering if there is a better way. Is there a way to do this using Windows Security/Active Directory? Obviously I don't want to maintain a seperate Active Directory account for each one of our Internet Users. Once I've authenticated them (using our own security code) I just want to map them to one approved account to run reports. Is there a way to do this? thanks, vince Tag: UnAttended Printing in Reportin Services Tag: 35412
  - 5
    - Fields Won't Change I am creating data sets using Oracle stored procedures. I changed a column from varchar to number on a table that one of the stored procedures is pulling from. Reporting Services does not recognize the change. It still shows the field as varchar for that column. It won't change, I've tried on a new report, In a new project, I've tried renaming the stored procedure. I've even tried renaming the cursor. Any other suggestions? Tag: UnAttended Printing in Reportin Services Tag: 35411
  - 6
    - SubReport + Charts I'm assuming that you can use the "jump to" report to run a subreport from a pie chart. I would like to be able to click on a section of the pie chart and have it display the detail records that make up that portion of the pie chart. Has anyone worked with such? Any suggestions on how to make this work effectively? Tag: UnAttended Printing in Reportin Services Tag: 35410
  - 7
    - Access is denied: 'Microsoft.Samples.ReportingServices.CustomSecur I am installing Reporting Services on a Veritas cluster environment on a named Instance of SQL Server. The installation seems to go OK, but afterwards when I try to call up the ReportManager I get this error: Access is denied: 'Microsoft.Samples.ReportingServices.CustomSecurity' I'm using a Domain Account with administrator privlidges, so I'm not sure what to do next? Can anyone help? thanks Tag: UnAttended Printing in Reportin Services Tag: 35409
  - 8
    - Report with Check for file does not run on report server I have a report I created and works fine in the designer. When deployed I get this error Message: The hidden expression for the table 'table1' contains an error: Request for the permission of type System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed. (rsProcessingError) I suspect it has to do with permissions accessing the directory where I am checking for the existence of a file. The expression runs the following code: =iif(Parameters!DocFilter.Value="ALL" OR (Code.GetFileName(Code.GetFileNameAndPath( Fields!STATUS.Value , Fields!BYLAW_NO.Value , Fields!POSSE_JOB_NO.Value ))<> "MISSING" AND Parameters!DocFilter.Value="FOUND") OR (Code.GetFileName(Code.GetFileNameAndPath( Fields!STATUS.Value , Fields!BYLAW_NO.Value , Fields!POSSE_JOB_NO.Value ))= "MISSING" AND Parameters!DocFilter.Value="MISSING") ,FALSE, TRUE) Here is the code I have attached to the report: CONST SEARCH_ZAP_DOC = "\\Cepiplm22\docrepository\infraplan\zoning\bylaws\" CONST SEARCH_ZAP_ROOT_URL = "http://www.edmonton.ca/infraplan/Zoning/bylaws/" Function DoesFileExist(PathnFileName As String) As Boolean DoesFileExist = Len(Dir(PathnFileName)) > 0 End Function function GetFileName(byval strPath) dim i i = 1 do while instr(i, strPath, "\") > 0 i = instr(i, strPath, "\") + 1 loop i = i - 1 GetFileName = right(strPath, len(strPath) - i) end function function GetUrlPath(byval strPath) dim i i = 1 do while instr(i, strPath, "\") > 0 i = instr(i, strPath, "\") + 1 loop i = i - 1 strPath = left(strPath, i) strPath = replace(strPath, SEARCH_ZAP_DOC, SEARCH_ZAP_ROOT_URL) strPath = replace(strPath, "\", "/") GetUrlPath = strPath end function function DropLeadingZeros(byval strFile) do while left(strFile, 1) = "0" strFile = Right(strFile, len(strFile) - 1) loop DropLeadingZeros = strFile end function function GetFileNameAndPath(byval strStatus, byval strBylawNo, byval strPosseJobNo) dim objFSO dim objFolder dim strFile dim strSearchFile dim strSearchType dim strSearchRoot strStatus = strStatus & "" strBylawNo = strBylawNo & "" strPosseJobNo = strPosseJobNo & "" if strStatus = "O" then strSearchFile = strBylawNo & ".htm" strSearchType = "OFFICIAL" elseif strBylawNo = "" then strSearchFile = DropLeadingZeros(strPosseJobNo) & ".pdf" strSearchType = "APPLICATIONMAPS" else strSearchFile = strBylawNo & ".pdf" strSearchType = "PROPOSED" end if if strSearchType = "OFFICIAL" then 'special case for official to improve speed strSearchRoot = SEARCH_ZAP_DOC & strSearchType & "\" & left(strBylawNo, 3) & "00\" else strSearchRoot = SEARCH_ZAP_DOC & strSearchType & "\" end if if DoesFileExist(strSearchRoot & strSearchFile) then GetFileNameAndPath = strSearchRoot & strSearchFile else if strSearchType = "APPLICATIONMAPS" then 'try it with up to 2 leading zeros if DoesFileExist(strSearchRoot & "0" & strSearchFile) then GetFileNameAndPath = strSearchRoot & "0" & strSearchFile else if DoesFileExist(strSearchRoot & "00" & strSearchFile) then GetFileNameAndPath = strSearchRoot & "00" & strSearchFile else GetFileNameAndPath = "MISSING" end if end if else GetFileNameAndPath = "MISSING" end if end if end function Tag: UnAttended Printing in Reportin Services Tag: 35407
  - 9
    - How to call SQL server Reports in VB 6.0 Hi Present we are using crystal reports 8.5 in VB application . database is SQL server 2000. How can convert existing Crystall reports into SQl Server reports and How to call SQL server Reports in VB 6.0 as like Crystal reports. Would appreciate if any one gives suggestion on this. Thanks Venu Tag: UnAttended Printing in Reportin Services Tag: 35405
  - 10
    - How to integrate many authorization database in one RS I can't figure the best way to do this: I have many web applications with their own authorisation mechanism. I have one Report Server containing all reports of all my applications. I want to extension Reporting Services security to integrate our own authorization. The problem is: Inside the security extension, how to know which security to use (the one for the web application 1 or the one for the web application 2)? Imagine I have the same user ID with different rights in both web applications? Thank you, Eric Tag: UnAttended Printing in Reportin Services Tag: 35404
  - 11
    - CreateReport() failure I have a c# program which creates a folder, datasource, and report. If I run it 2 or 3 times it always works. But if I run it once I see the entries for the data source in the DataSource table but when I hit refresh on the report manager they are deleted! ??? Run it 2 more times and they are there. owen Tag: UnAttended Printing in Reportin Services Tag: 35403
  - 12
    - Error 25602 on install We're running SQL/Server 2000 on a Win2003 server and are attempting to load the enterprise edition of Reporting Services. However, installation fails with an unexpected error message and gives the error number 25602. Unfortunately, we are unable to find a description of this error anywhere on Microsoft's website. Can anybody tell us what this error means and how to fix it? Thanks for your help. Henry Robinette Tag: UnAttended Printing in Reportin Services Tag: 35402
  - 13
    - SOAP Api bug or no? I'm trying to simply replace functionality of the improperly rendering report viewer with my own... and I've found what I dont know to classify as a bug or not... I can render reports just fine but the images/other streams in them dont render at all... Heres what I've got. string streamRoot = "ReportImage.aspx?report=" + Server.UrlEncode(reportPath) + "&streamid="; which I throw in my device info, in the report view etc. I set Session["rs"] to the reportingservices option (following an existing example) as well as the parameter value collection etc. Effectively the parameters that get fed to the rs.RenderStream() method are (substituted in for variable values) rs.RenderStream("/SampleReports/Product Line Sales","HTML4.0","cbf6cee8-22e3-412f-93d3-8f22680d8ceb",null,null,parameterValues,out encoding, out mimetype); the parameter value collection is valid as well. Before I recall seeing something along the lines of "user SLO\Wes doesnt exist in database... but the actual exception I am getting is: {"The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. --> The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database." } My question is, if I can render the html of a report, why could I not render the stream that I fetch with the GUID that reportserver gives to ME... Thanks in advance Weston Weems Tag: UnAttended Printing in Reportin Services Tag: 35401
  - 14
    - report manager - hide in list view Is there a property for the hide in list view that I can tap into. I am using ListChildren to get the reports into a treeview but I want to exclude reports or folders that are hidden from the list view. Any help is appreciated. Tag: UnAttended Printing in Reportin Services Tag: 35399
  - 15
    - Problem with charting I am having a problem with RS charting a bar graph. I am using a stored proc that uses 2 parameters: (@StartDate, @EndDate) From this there are 3 sets of data returned: (Pts In, Pts Out, Pts Txt). The stored proc then seperates times of the day into 24 slots: (0-1, 1-2, 2-3... 23-0). Then it returns a count for that time slot, for that set, for that day. I can get the chart to work if I use a 24 hour period, but does not work for several days. Any Help would be greatly appreciated... Ray Tag: UnAttended Printing in Reportin Services Tag: 35396
  - 16
    - Security extension and Windows authentication Any body succeed creating this kind of security extension??? I keep trying using windows authentication. But I have a problem to deserialize de ACL information received by the CheckAccess and GetPermissions methods of the IAuthorizationExtension interface. The information received seems to be different from the one when running in form authentication mode. Any hits will be appreciate, Thanks, Eric Tag: UnAttended Printing in Reportin Services Tag: 35394
  - 17
    - Expose RS to Internet? Hello I have just created some reports and I want to expose them to the internet without windows authentication. I mean that every user outside can see my reports without being part of the domain. Thanks for your help. Tag: UnAttended Printing in Reportin Services Tag: 35390
  - 18
    - DAAB and Data processing extension Hi everybody ! I have a big trouble with my Data processing deployment. To create my DP i use my data application block with iDB2 custom provider. When i deploy my data processing on report server with the correct configurations in config files, i got this error : Une erreur s'est produite lors du traitement du rapport. (rsProcessingAborted) Obtenir de l'aide en ligne Ã?chec de l'exÃ©cution de la requÃªte pour le dataset Â« Annee Â». (rsErrorExecutingCommand) Obtenir de l'aide en ligne The type initializer for "IBM.Data.DB2.iSeries.iDB2Trace" threw an exception I'm not able to find any information on "The type initializer for... threw an exception"... What's that ? I don't have any ideas to make some researches about that. Thx a lot Tag: UnAttended Printing in Reportin Services Tag: 35388
  - 19
    - reportnested bookmarks Good Morning, I have a necessity to generate a reportnested bookmarks. My report (Word) has bookmarks nested, i didn't find a examplein your internet site. My report has this structure: an externalbookmark and inside has more son bookmarks. I used WordWrite from SoftArtisan Tag: UnAttended Printing in Reportin Services Tag: 35387
  - 20
    - Hide subreport in Rpt Mgr using deploy script Hi, How can I hide subreports from being listed in report manager using the deploy script? I can do it manually afterwards but when deploying to test and production environments this needs to be automated. Thanks, -- Fairfield Tag: UnAttended Printing in Reportin Services Tag: 35383
  - 21
    - Watermark Hello, I need a optional watermark (some colored retangles) on every report page. I have tried to add retangles with different background colors. Doesn't work because the retangles match the size of the including table (if the table has half size of page, the retangle also -> Should fill the page). Also the repeating background image doesn't work. It looks only ok on the first page, on the other pages I have clipping problems. Has somebody tried to do something like this? Thanks Eric Tag: UnAttended Printing in Reportin Services Tag: 35380
  - 22
    - Error creating subscriptions for reports that contain UserID. I get an error when I create a subscription for a report that contains the value = User!UserID The report runs fine If I view the report (or run live). The actual error is: "Subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values" The DB connection is Microsoft SQL server, using the "use specific user name" option for DB credentials. Tag: UnAttended Printing in Reportin Services Tag: 35378
  - 23
    - Guage & Meter Charts Does anyone know of a guage and meter chart package that will work with RS 2000? Dundas says theirs will only work with RS 2005. Also, recommendations for any other chart options would be apprecieated. For example 2 column line/bar graphs and the like. Thanks! Tag: UnAttended Printing in Reportin Services Tag: 35377
  - 24
    - filtering on a dataset Hi all! I am trying to filter a dataset. Could someone help me? I only need the last 12 months from the system date. systemDate.field< 12 Months Anyone have any suggestins? Thanks in advance, Kerrie -- Message posted via http://www.sqlmonster.com Tag: UnAttended Printing in Reportin Services Tag: 35374
  - 25
    - insert a page break in between matrix -help me hi, i have a matrix to display the data. i want to insert a page break in between a matrix. i.e if no. of records exceed 25, then it should print in next page thanks mini Tag: UnAttended Printing in Reportin Services Tag: 35373
- Next
  - 1
    - navigate a report in separate window i have a report with linked Item by setting navigation property to another report. when I click the link, i want to open the report in new window if anyone knows, help me thanks mini Tag: UnAttended Printing in Reportin Services Tag: 35372
  - 2
    - Group ..Alternate color ....Help Needed! Hi, I'm using the following in the colorbackground of the group header to change the color of the group when a group name changes. =iif(RowNumber("DTM_Group1")Mod 2, "White", "Cornsilk") But this is not working properly when the group name changes! Could some one help me with this? Tag: UnAttended Printing in Reportin Services Tag: 35371
  - 3
    - Export Excel : formatting has number with a formula in data report Hello, I have a problem when I export my report to Excel : the cells are not considered as numbers. In my report, I have a table witch fills data formatting with 1 decimal if the data is not null. It's important because 0 and null must be considered as different values. An example of one cell : =IIf(""&Fields!AFF_OBJ_ACT.Value = "", "", Format(Fields!AFF_OBJ_ACT.Value/1000,"#,0.0")) So, my report fills data like : empty, "0,0", or "x xxx,0", etc... But, when I export my report to Excel, data are not considered as numbers but strings with the green left top corner ! :-( Any idea to help me ? I understand that I need to format in my report data as number, but how to differentiate 0 and null values... ? Thanks. Tag: UnAttended Printing in Reportin Services Tag: 35365
  - 4
    - can some help me in explaining IIF() actually i searched in google but i couldnot get the proper information. i found some expamples which ofcourse are very confusing. any help will be highly appreciated regards ram Tag: UnAttended Printing in Reportin Services Tag: 35364
  - 5
    - Reporting Services Webparts - Need Inputs Hi All, Has anyone wroked on Reporting Services webparts. If so please clear my doubts.... I need to integrate Reporting Services Report to Windows Sharepoint site, I need to show the Report in the Sharepoint Site (this is possbile by Reporting Service Weparts). - How do I create a simple Reporting Services Webparts - Is the Sharepoint Server and Reporting Servies should be in the same machine - How to add Reporting Services webparts to a sharepoint site server. Thanks Balaji -- Message posted via http://www.sqlmonster.com Tag: UnAttended Printing in Reportin Services Tag: 35360
  - 6
    - Force chart to display all x axis labels I have an xy scatter chart that plots computer outages versus days of the month. Is there a way to force the chart to show all x axis labels? eg. for the month of May I want the x axis to show all 31 labels and associated tick marks (1-May through to 31-May). Currently the chart only displays every third label. eg 1-May, 4-May, 7-May etc. Regards Martin Tag: UnAttended Printing in Reportin Services Tag: 35356
  - 7
    - Setup for hosting multiple webites I have a SQL server in which I installed Reporting Services. The Server also hosts a couple of websites that are accessed over SSL like 'https://www.projectsite.com'. I have SQL reporting in the IIS root website. How can I set up reporting services on each of these websites so that the reports can be accessed like 'https://www.projectsite/com/reports'? Are there some references discussing hosting SQL reporting? Thank you Dan Tag: UnAttended Printing in Reportin Services Tag: 35354
  - 8
    - Cannot render PDF from HTTP request I have a VBScript that invokes the report server through xmlhttp. I can get it to render the report as html but it just won't work with PDF specified. The exact same URL in internet explorer renders as PDF - but from VBScript only HTML. What is different? How can I get it to work? The script is included below: Option Explicit ' ' Constants ' Const ServiceUrl = "/reportserver/?/SampleReports/Company%20Sales&rs:Command=Render&rs:Format=P DF" 'Const Encoding = "application/x-www-form-urlencoded" Const Encoding = "text/html" Const ContentType = "Content-Type" Const DomDocument = "Msxml2.DOMDocument.4.0" Const ForWriting = 2 ' ' get arguments ' If WScript.Arguments.Length < 2 Then WScript.Echo "Invalid arguments, was expecting: <host> <results file>" WScript.Quit ( 1 ) End If Dim Host: Host = WScript.Arguments ( 0 ) Dim ResultsFile: ResultsFile = WScript.Arguments ( 1 ) ' invoke the service Dim Service: Set Service = CreateObject ( "Microsoft.XMLHTTP" ) Service.Open "POST", "http://" & Host & ServiceUrl, false Service.SetRequestHeader "Content-Type", Encoding Service.Send _ "" ' get the results Dim FileSystem: Set FileSystem = CreateObject ( "Scripting.FileSystemObject" ) Dim File : Set File = FileSystem.OpenTextFile ( ResultsFile, ForWriting, true ) File.Write ( Service.ResponseText ) File.Close ( ) -- McGeeky http://mcgeeky.blogspot.com Tag: UnAttended Printing in Reportin Services Tag: 35345
  - 9
    - Parser Error - Can't run Report Manager!!! Hi, I installed (full installation) SQL Server 2000 Reporting Services on my PC (Windows Server 2003, SQL Server 2000 SP3 Enterprise and Visual Studio 2003) and everything went smoothly when no problems... now I am trying to open Reports Manager (http://LocalHost/Reports) but I get the following error message: Parser Error Message: Could not load type 'Microsoft.ReportingServices.UI.GlobalApp'. Source Error: Line 1: <%@ Application Codebehind="Global.asax.cs" Inherits="Microsoft.ReportingServices.UI.GlobalApp" %> Can anybody tell me how to solve this problem, I search a lot to but didn't find anything helpful :( Thanks in advance. Tag: UnAttended Printing in Reportin Services Tag: 35344
  - 10
    - Export to Excel with Expand Collapse Feature not working after SP2 After installing SP2 on Reporting Services, the Expand/Collapse functionality is lost when Exporting to Excel 2003 or XP. Prior to installing SP2, when a report with collapsed columns was exported to Excel, all the columns would automatically expand in the exported file. Now they are lost. Anyone has figured out a fix for this. -- CASystems Tag: UnAttended Printing in Reportin Services Tag: 35343
  - 11
    - Viewing Reports Problem I rolled out reporting services to 180 extrenal users with their own personal pcs and I have a few extrenal users that are unable to view any of the reports. They can get logged into reporting services, see the list of reports available to them, but when they click on a report to view it they get a message that says "You are not authroized to view this page", "You do not have permission to view this direcory or page using the credentials you supplied" and gives an "HTTP 401.2 - Unauthorized: Logon failed due to server configuration Internet Information Services" I'm fairly sure that it's a setting on the users computer, but I'm not sure where to have them look. When the user logs in on someone else's computer they don't have the problem. They are on Windows XP using I.E. 6.0.29 SP2 with the security and privacy both set to Medium to try and access the reports. Any help is appreciated. Jason Tag: UnAttended Printing in Reportin Services Tag: 35340
  - 12
    - Redering Nightmare I finally finesh the report and everything looks fantastic in VS and on the Report Manager. However, as soon as I try to export it to any other format "all hell breaks loose" title and text boxes go into one page and chart to another. I checked previous postings and tried to use a rectangle to control all controls in it, also check the page size and margins and rectangle size. Nothing seems to work. Any help would be greatly appreciated. Tag: UnAttended Printing in Reportin Services Tag: 35338
  - 13
    - SRS SP2 Installation Web Farm I am installing SP2 on a web farm. When I originally installed Reporting services I pointed the database to a separate server. Now when installing the SP the database didn't get updated with the SP and I can't get the SP to run on the server with the database. The error I get basically says that the application to be patched cannot be found. Is there a way to upgrade just the database? Is there a way to run the SP on the server with just the database? Is there documentation on this? Some help would be much appreciated. Tag: UnAttended Printing in Reportin Services Tag: 35337
  - 14
    - subreport howto link please Hi, I have a report I want to add subreports to....but the books online are worthless in this regard of a howto...any help? -- tym, Eskimo Tag: UnAttended Printing in Reportin Services Tag: 35335
  - 15
    - Report Parameter risk Hi, I have implemented a Single Sign On using Form authentication for my asp.net application and reporting services using security extension. Its working great. Now the problem is when we render the parametrised report using URL access, parameter bar is kept visible. One of the parameter is userID along with date range parameters. Now once user is on report he can easily change userId to see other user reports which is not desirable and is big security risk. Please let me know the solution, if you have any. Thanks, Mahesh Tag: UnAttended Printing in Reportin Services Tag: 35334
  - 16
    - Group header doesn't repeat I have a group header on a table and I have checked off "Repeat Group Header" I want this group header to repeat. I have about 6 or 7 groups on the table in total, and some of those groups contain a table with data in the table header only (for easier control of the layout). The group I want to repeat does not have a table in it just one row that has a few cells. Am I doing something wrong or is reporting services not working properly? I think it's the latter.. Any suggestions ? Tag: UnAttended Printing in Reportin Services Tag: 35328
  - 17
    - Unable to communicate with report server I just installed SQL reporting services on a Windows Server 2003 machine. I am unable to open report manager, the error message that i get is "Unable to communicate with report server. Please verify that the report server is operational." Any ideas on how to resolve this problem? Thanks, SSS Tag: UnAttended Printing in Reportin Services Tag: 35323
  - 18
    - List of exportable fonts??? Does anyone where one can obtain a list of fonts that will export properly when exporting to .pdf? I'm looking for a script like font specifically? Any hacks, work arounds, add on's, code, anything to reslove this? I have created a 12 page report don't want to redesign it in Crystal due to this one small issue. Thanks for any help. Tag: UnAttended Printing in Reportin Services Tag: 35321
  - 19
    - Report Parametrs Simple Question Hi, I have a matrix control with actiondefined on the "Data" cell of the matrix. The action is jump to the details report. Now I have 4 parameters. Out which 2 CAN be sometimes nulls or not defined. @month has Fields!Month.Value @Item_Code has Fields!Item_Code.value. I tried setting the value of these 2 parameters as: @month : ISNULL(Fields!Month.Value) @ItemCode : ISNULL(Fields !Item_Code.value) But is get the error " The value expression for text box Quantity has error. Name ISNULL not defined." How can i assign the the value to @Month & @item_Code such that, they can have some value or they can be nulls or they can be nothing..? Please help. Thanks -- pmud Tag: UnAttended Printing in Reportin Services Tag: 35320
  - 20
    - Same parameter for two datasets Is it possible to share one parameter? I wanto to use two different datasets but need to use the same parameter in both of them. I don't want to repeat the parameter selection. Tag: UnAttended Printing in Reportin Services Tag: 35314
  - 21
    - link target I have some 'go to' links and 'back to' links in my report. I want the 'go to' links displays reports in new window and 'back to' links displays the reports in same window. any idea? Tag: UnAttended Printing in Reportin Services Tag: 35312
  - 22
    - Toggle Visibiity not working I have a report that toggles a group properly on my development machine. When I upload the RDL to the server the visibility does not toggle. I do get the + indication. I then change the default Visible property to True and I can see my details. When I attempt to minimize the group the screen refreshes but does not supress the details. It feels like an IE/IIS issue on my Reporting Server but can can not figure it out. If I use my orignal RDL (Details Supressed) the detail data does not export either. -- Randy Smith By Design Consulting www.bydesignus.com Vicinity Manufacturing www.vicinitymanufacturing.com Tag: UnAttended Printing in Reportin Services Tag: 35311
  - 23
    - .RenderStream reports streamid is invalid... Ok, I've got something that seems to be stumping me a bit. I've set up a device info with a stream root etc... that looks like so: "reportimage.aspx?report=" + reportPath + "&streamid="; then the next page for the image url... I get http://localhost/Reports/reportimage.aspx?report=/SampleReports/Product Line Sales&streamid=cbf6cee8-22e3-412f-93d3-8f22680d8ceb which at least LOOKS correct. The actual exception I am getting is: aspnet_wp!library!d50!07/15/2005-08:36:09:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. Thanks for any information in advance Weston Weems Tag: UnAttended Printing in Reportin Services Tag: 35298
  - 24
    - HTTP status 405: Method Not Allowed. hello, I try to in install reporting services. First error i receive is the 25619 error message. I tried to apply the solution as described in the knowledge base. After applying the workaround i get the following error when opening the reportserver "HTTP status 405: Method Not Allowed." Please Help!! Below the log file: <Header> <Product>Microsoft SQL Server Reporting Services Version 8.00.743.00</Product> <Locale>en-US</Locale> <TimeZone>W. Europe Daylight Time</TimeZone> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerWebApp__07_15_2005_16_55_38.log</Path> <SystemName>DIGIBOOKDOO</SystemName> <OSName>Microsoft Windows NT 5.2.3790.0</OSName> <OSVersion>5.2.3790.0</OSVersion> </Header> w3wp!library!c88!7/15/2005-16:55:38:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. w3wp!library!c88!7/15/2005-16:55:38:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file. w3wp!library!c88!7/15/2005-16:55:38:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!c88!7/15/2005-16:55:38:: i INFO: Initializing InstanceName to default value of 'MSSQLSERVER.1' because it was not specified in Configuration file. w3wp!library!c88!7/15/2005-16:55:38:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file. w3wp!library!c88!7/15/2005-16:55:38:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!c88!7/15/2005-16:55:38:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!c88!7/15/2005-16:55:38:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file. w3wp!library!c88!7/15/2005-16:55:38:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file. w3wp!library!c88!7/15/2005-16:55:38:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file. w3wp!library!c88!7/15/2005-16:55:38:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. w3wp!ui!2b0!7/15/2005-16:55:40:: e ERROR: The request failed with HTTP status 405: Method Not Allowed. w3wp!ui!2b0!7/15/2005-16:55:40:: e ERROR: HTTP status code --> 500 -------Details-------- System.Net.WebException: The request failed with HTTP status 405: Method Not Allowed. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods() at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods() at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods() at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI() at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level) at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain() w3wp!ui!2b0!7/15/2005-16:55:43:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm) at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm) at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) w3wp!ui!c88!7/15/2005-16:55:54:: e ERROR: The request failed with HTTP status 405: Method Not Allowed. w3wp!ui!c88!7/15/2005-16:55:54:: e ERROR: HTTP status code --> 500 -------Details-------- System.Net.WebException: The request failed with HTTP status 405: Method Not Allowed. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods() at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods() at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods() at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI() at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level) at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain() w3wp!ui!c88!7/15/2005-16:55:54:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm) at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm) at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) Tag: UnAttended Printing in Reportin Services Tag: 35297
  - 25
    - SP2 Database Upgrade For whatever reason the database was not upgraded when doing the SP2 install. I noticed 6 or 8 sql scripts in the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer directory. Is it possible to just run the SQL scripts against the database to upgrade the database? Is there anything further that needs to be done? I have tried re-installing several times, the database is on a separate server than the front end and I can't get the database to upgrade. I've tried running the SP on the server with the database, but because reporting services isn't actually installed, just the database is installed, the SP won't run. How do I upgrade the database? Tag: UnAttended Printing in Reportin Services Tag: 35296

Hi!
Is there a way to print a report in Sql Reporting Services using a xml web
service.

This is the goal: i write a simple report and i deployed to the report
server . I need to write a xml web service to call that report and print it!

Could be possible? Is so, how could i do it?

thanks!

Top