capture sql output parameters

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
    - Trail to Licensed Version of SQL Reporting Services? I have a valid SQL Server 2000 license on a Windows 2003 Server. I have a VS 2003 licensed copy on my desktop. I have the 120 day eval CD set with the SQL Server Reporting Services Trail CD. I don't have an MSDN subscription. If I install the Reporting Services Trail will it automagically become licensed? If the Trial does not get adopted as a licensed version I guess I need to score the CD media somewhere - correct? I see there is a SP1 for download, might it convert the Trail to a licensed version if installed on a SQL Server 2000 licensed server? Thanks! reply here or rheitzman atsign hotmail adot com Tag: capture sql output parameters Tag: 18555
  - 2
    - Report Desinger install error While attempting to install the report designer on a developers desktop we are getting an error. The Developer has the Enterprise edition of Visual Studio 2003 and Windows XP. In the rsstp1.log that was created when the error occured I found this; <Func Name='PerformDetections'> 0 Failed to find property in cache: InstalledInstances Failed to perform discovery on machine: WMPRXP525487 HRESULT: 2147749891 <EndFunc Name='PerformDetections' Return='2' GetLastError='183'> Any suggestions??? Tag: capture sql output parameters Tag: 18553
  - 3
    - My Reports Folder Is there a way for users to create links or shortcuts to reports and put them in their "My Reports" folder? I was able to do it in crystal enterprise, but I would like to do it here to. Tag: capture sql output parameters Tag: 18549
  - 4
    - Generating BorderColor and BorderStyle as an underline I have a matrix report where the columns contains the days of the month and the rows contain various Income Statement Categories. No totaling or subtotaling is being done in the matrix. The matrix is only being used to automatically spread the data over rows and columns and for display. My problem is that I would like add a solid black line above certain rows passed in such "Fees Total". I've set the BorderSytle to Solid for Top and I have a formula in BorderColor along the lines of =iif( First(Fields!cashflow.Value) = "Fees Billed Total" or First(Fields!cashflow.Value) ="Unwinds Total","Black","Gainsboro") This works well except on days in which there are no Fees. In these cases the black line is not generated. I tried adding "or (Fields!cashflow.Value) is nothing to the expression but this underlines every empty cell in the report. Is there a way to generate a line such as this for a row containing empty values for some columns? Thanks Dave Tag: capture sql output parameters Tag: 18548
  - 5
    - Localize Report I've read several places that there isn't a way to localize reports at run time of a report, so I wanted to ask what is the "best practice" of deploying the reports if you have some clients that might want to view 'English' reports and others who might want to view 'German' reports. I'd like to avoid having duplicate reports, but it really sounds like this is my only option. Any ideas you have or suggestions of articles to read on the topic would be greatly appreciated! Dan Tag: capture sql output parameters Tag: 18547
  - 6
    - Calling a DB2 Stored Proc from Reporting Services I am attempting to call a DB2 stored procedure from SSRS through the IBM OLE DB Provider. The procedure has 3 input parameters and 2 output parameters (I don't care about the results of the output parameters). Has anyone been successful doing this? If so, can you share the syntax that you used? Thanks, John W Tag: capture sql output parameters Tag: 18538
  - 7
    - Matrix Pagination Hello, I've been developing a matrix report in Reporting Services, and for some reason, pagination does not work. Instead of getting page breaks when the report runs over the page height, the report renders as a single page. PDF export seems to work fine (i.e., the pagination works correctly), but regular HTML display of the report does not. I've checked every parameter that I could find -- KeepTogether, page height, etc. -- but the matrix does not paginate. Am I missing something? What else should I check? Thanks for your help, Garrett Tag: capture sql output parameters Tag: 18535
  - 8
    - vb.net not recognized during install Trying to install the report designer on a mchine running xp sp2 with vb.net already installed. During the inital portion of the setup it states visual studio.net not installed. What is it actually looking for? Tag: capture sql output parameters Tag: 18527
  - 9
    - IIF Execution I'm having a problem getting this iif statement to execute properly. =IIF(Fields!AlarmLevel.Value = 0, "", Code.rptUtilities.GetPeakLevel(Fields!ThresholdFormat.Value, Fields!SpectrumFormat.Value, CType(Fields!Spectrum.Value, Byte()), CType(Fields!Threshold.Value,Byte())) ) It seems as though it executes both the true and false parts and my textbox always shows #Error when it should have evaluated to "". The logic above is correct because I have done this IIF(Fields!AlarmLevel.Value = 0, "1", "2") and it correctly displays on the report. GetPeakLevel will never work if the AlarmLevel is 0, so I figured I could conditionally execute GetPeakLevel. I know that is executing true and false part because I can place a try catch in GetPeakLevel and return "" when it catches the error. This is not useful though as any level other than 0 that catches an error would return "". Does anyone know if this behavior is by design, or a bug. Tag: capture sql output parameters Tag: 18526
  - 10
    - Cannot connect I have .NET 2003, IIS, SQL server and Reporting services installed on my development pc. I have created a Report Project and can view the results in VB.NET - however when I try to Deploy I get the message that it cannot connect to http://localhost/reportserver Can you advise please.... -- Regards Bob Tag: capture sql output parameters Tag: 18512
  - 11
    - Non-existing parameter in the report parameters collection I have the following code in my report: Protected Overrides Sub OnInit() Dim strTemp as String strTemp = Report.Parameters("PersonNameParam").Value End Sub For now I am just trying to get the value of the parameter, but when I try to preview the report I get the following error. "Failed to load expression host assembly. Details: The expression referenced a non-existing parameter in the report parameters collection. (rsProcessingError)" I have also tried accessing the parameter as: Report.Parameters!PersonNameParam.Value but I got the same error. Thanks in advance for any help. -- Message posted via http://www.sqlmonster.com Tag: capture sql output parameters Tag: 18510
  - 12
    - count property on group? Is there any way to show the count of a collapsed group on the row set to toggle visibility. For example, if I have rows for Purchase Orders and grouped under that, rows for line detail that are hidden with Purcharse Orders number as the toggle textbox, is there some way to show the detail line count on the Purchase Order row? That is, short of establishing a dataset? -- Thanks, CGW Tag: capture sql output parameters Tag: 18509
  - 13
    - Rendering as GIF I have seen that it is possible to render reports as gif image files, but have not been able to find documentation. What has to be added to the configuration file to have the image output as gif rather than tif? Thanks, Ed Fox Tag: capture sql output parameters Tag: 18508
  - 14
    - Justified alignment Does Reporting Services in any way offer justified text alignment? Tag: capture sql output parameters Tag: 18507
  - 15
    - HTML reports size Is there any way to reduce the size of HTML reports generated by reports server? Some of my 3-page HTML reports are as big as 3MB. Tag: capture sql output parameters Tag: 18504
  - 16
    - Table header overlapping with table content Hi Group, In a report, I have a subreport containing a table. The table has a header with "RepeatOnNewPage = True" so that it will be repeated on each new page. The report is being called from the code and returns a PDF document (with Response.BinaryWrite(<byte array>) ). which is in turn displayed to the user. Everything goes fine except that on some pages the table header overlaps the table content, so the first 3-4 lines of content become unreadable... Unfortunately I could not tell whether there is a pattern or not in how often the two of them overlap. Did anybody get this behaviour ? Thanks for any hints ! Andrei. Tag: capture sql output parameters Tag: 18501
  - 17
    - Samples for Calendar Style Reports newbee! question. Want to see sample reports that display the data in calendar format like outlook does. Example ... all appointments for the next 2 weeks arranged as a calendar. Thank you for your help in advance. Tag: capture sql output parameters Tag: 18500
  - 18
    - Visual Studio 2005 & SQL Server 2000 RS Hi there, I have Visual Studio 2005 and SQL Server 2000 with Reporting Services. What Do I have to do, to get the ReportDesigner working with VS2005? If it's not possible, please tell me, when it will be available. Thanks. Betina Tag: capture sql output parameters Tag: 18499
  - 19
    - parameter help in Report Services I have a user defined parameter for my report. I would like to have the option to select all options instead of only one. I already created the query for the parameter and defined 'all' in the following way: SELECT per_initial = 'all' UNION SELECT per_initial FROM Table How do I then define 'all' so that it is all of my options? Thanks! Tag: capture sql output parameters Tag: 18498
  - 20
    - Problem summing a calculated field Any help with this would be greatly appreciated. Thanks in advance. I have a field in my db that is a string field that holds numeric data (salesperson quota). My report is grouped as follows: Group Header 1 - Territory Group Header 2 - Sales Person (hidden) Detail - (hidden) Group Footer 2 - displays salesperson data and total sales Group Footer 1 - summation of territory info. The problem i am having is the summation of the territory quota. Since it is a string, my footer 2 expression for quota is: =format(convert.toint32(Fields!sal_class.Value),"c") in order to show as currency. How do I sum the quota data in the group footer 1. Nothing I have tried seems to work. Help!!!! :) Tag: capture sql output parameters Tag: 18496
  - 21
    - Drop Down lists I have a report that uses a drop down for the user to make a choice. The report works fine when choosing only one selection but I need the user to be able to choose one or all choices. Can someone please point me in the right direction? Tag: capture sql output parameters Tag: 18495
  - 22
    - Daily Caching I have set up a data-drive subscription to do a null report on a report that takes 3 minutes to run. I have it set up to run at 3 am and it works fine. My question is when a user runs it at 6 am, does it use what I cached plus the new data, or does it re-cache the whole thing? This report is intense and I really do not want to run it during the day if I don't have to. If it constantly re-caches the report, would creating a snapshot on a schedule be the better option? Thanks. Tag: capture sql output parameters Tag: 18491
  - 23
    - Login box displayed when browsing to ReportServer Hi, I have RS and SQL Server on the same development box. When I browse to http://localhost/ I can see my reports on my box. However, when other users browse to my machine with http://mymachinename/ they get a Windows Login box pop up. When they type in their Windows Credentials, the box pops up again. If they click cancel, they get "You are not authorized to view this page." How should I configure IIS to get this working? I've never used IIS or Reporting Services before. Thanks. -- Mark Allison, SQL Server MVP http://www.markallison.co.uk Looking for a SQL Server replication book? http://www.nwsu.com/0974973602m.html Tag: capture sql output parameters Tag: 18489
  - 24
    - Excel files are too large I have the following problem with Reporting Services: My report has about 6500 lines and 100 columns. When I export it into Excel the size of the end file is about 20 Mb. As I have to send it using subscriptions, it is a problem â?? too large file for e-mail. Are there any ways to minimize the size of output Excel file? Regards, Boris. Tag: capture sql output parameters Tag: 18487
  - 25
    - Prerequisite check for reporting service in MOM failt I get a failure from the MOM 2005 prerequisite check for MS SQL Reporting Services with an unspecified error and it reports to be unable to contact the Microsoft SQL Server Reporting Services server via Web Service. I checked the deployment guide and release notes and changed the RSReportServer.Config to the value for "SecureConnectionLevel" to 3. SSL is enabled on different virtual webs under the default website. SSL is also enabled for the 'Report' and 'ReportServer' virtual web under the default website. The SSRS is running and the default web site too. No errors in the event log. I installed SSRS with SP1. At the end of the installation of SQL Reporting Services I've got a notice, that the web service has to be initialized manually. What to do? Regards, Thomas Tag: capture sql output parameters Tag: 18478
- Next
  - 1
    - Placing labels on line chart Hi, Some of my charts have many data series on them and the colours can be difficult to differentiate. I would like to include a label on the actual line chart as the legend is not helpful - the colours are too similar. Is this easy to do? For an example see here: http://tinyurl.com/3kkou Thanks. -- Mark Allison, SQL Server MVP http://www.markallison.co.uk Looking for a SQL Server replication book? http://www.nwsu.com/0974973602m.html Tag: capture sql output parameters Tag: 18476
  - 2
    - customizing parameter layout Is there any way to customize the way parameters are laid out? It seems there's not much control beyond order, label, and data type. I'm talking about setting the width, location, color, etc. Specifically, my problem right now is that I need to have 4 parameters down the first column, and 5 parameters down the second column, but I can't figure out a way to do that. I tried to add a "spacer" hidden parameter, but that didn't work. It sure would be nice to have a parameter designer so we can customize the layout if we wanted. Tag: capture sql output parameters Tag: 18472
  - 3
    - How to purge old schedules I am allowing users to create One-time Schedule's (via the Web Service API) with "Stop this schedule on" automatically being set to the next day. However, the Subscriptions list is never cleared for the report, even though the schedules are weeks past the stop date. This results in dozens of obsolete schedules being listed. Is there any way to automatically purge old schedules from reporting services, or do I need to do it within my own code? Thanks, Bill Tag: capture sql output parameters Tag: 18469
  - 4
    - Continued from Previous page Hi, how do I test whether I'm in a repeated header so I can indicate that this group is continued from the previous page? many thanks Matt Tag: capture sql output parameters Tag: 18468
  - 5
    - Upload and site setting is disabled. Hi, I have intalled a evaluation copy of sql server reporting a week back. Everything was working, but now Report Upload option and Site setting options are not comming. Could you please help me out and tell me what went wrong. Thnaks -- Message posted via http://www.sqlmonster.com Tag: capture sql output parameters Tag: 18466
  - 6
    - MDX query Parameter display error I am using a MDX query for report. I have a input Parameter as Location Level. The values are L1, L2, L3 and L4. In MDX I am trying to create a member to display value A for L1, B for L2, C for L3 and D for L4 as follows: Member [Test_Member] AS 'iif( " + Parameters!LocationLevel.Value + "= ""L1"",A, iif( " + Parameters!LocationLevel.Value + " = ""L2"", B, iif( " + Parameters!LocationLevel.Value + " = ""L3"", C, D))) ...... But I am getting error such as Syntax error - Token is not valid. I tried all ToUpper(), ToString(), Trim() to match the value Plese if any one knows, 1. How to display Parameter value? 2. Solution on above problem? Thanks, Same Tag: capture sql output parameters Tag: 18465
  - 7
    - images in HTML reports How to render image in HTML reports? I have a webapp which invokes Reporting Services web service to generate reports in HTML format. The reports are for internet users - the image is not accessible to these internet users because they cannot access the report server directly which is in the intranet. Is there a solution to this problem at all? Thanks Sanjay Tag: capture sql output parameters Tag: 18464
  - 8
    - Integration with Windows Rights Management Does RS natively allow the application of Rights Management to reports as or once they are rendered, e.g. to a web site or into a pdf file? If not do you have any insight into how this can be done? Are there plans to integrate with RM? Tag: capture sql output parameters Tag: 18462
  - 9
    - Gurus -> I need a working sample of the rc:ReplacementRoot command Hello there, Ok, I did find some snipped of codes here and there however, I still havenâ??t been able to get it to work correctly. If it is true that people were able to overcome the jump out of Frame while drilling down when using a costume page and the ReportViewer component, could you please share the solution? Thanks. Walter Tag: capture sql output parameters Tag: 18458
  - 10
    - Initial Setup Question Just starting to work my way through the Blackburn & Vaughn book to figure out RS. One thing I need to figure out though so that I can sell this thing to my boss: we have a SQL 2000 database that holds all of our study data. It looks like that makes us good on the licensing, and I was planning on having RS run on a different machine. Question is: will RS run in the same instance of SQL that we're currently using for our data, and is that wise? Tag: capture sql output parameters Tag: 18454
  - 11
    - Charting... I'll be quick and too the point... 1: I have a stacked area chart. 2: Percentages are the values being marked. Issue: I need to make the 100 mark (text and line) on the y-axis to be red. I've tried writing an expression to get at the current "label" for the mark. I keep getting the following error: << The border color expression for the chart 'Sample' contains an error: [BC30456] 'value' is not a member of 'ReportExprHostImpl.EH_Sample.EH_ValueAxis'. >> Here's what I have: '=iif(me.Value,"Black", "Red")' I've also tried .Text and .Label. Any help would be appreciated. Tag: capture sql output parameters Tag: 18453
  - 12
    - Subscriptions and schedules with webservice How do I get the schedule for a subscription represented as a RecurrencePattern? I have the string representation ("2004-12-22T13:30:00.000-08:001TrueTrueTrueTrueTrueTrueTrue"), but I would prefer not to parse this. Thanks, David Ribb Tag: capture sql output parameters Tag: 18452
  - 13
    - Rendering MHTML in browser I am using the Reporting Services Web Service to render the reports. I am doing Response.BinaryWrite(result) to write the MHTML report output to the browser but the browser displays the MHTML text instead of rendering it as a web page. How can I write the MHTML format reports to the browser without rendering to disk such that the browser can interpret it correctly? I have tried setting content type to 'multipart/related' but it didn't work. Tag: capture sql output parameters Tag: 18447
  - 14
    - Stored Procedure not recognizing dynamic SQL I created the sql below as a stored procedure that passes in the sql statement as a paramater. I replace the double-quotes with single quotes and then simply run the sql. I have to uses exec instead of select or else it doen't iniate the query. Why doesn't sql RS recognize the query? It runs fine from analyzer but RS will not recognize the fields in the proc. If I hard-code the sql in the proc and use select instead of exec then it works just fine. .************************************************ declare @SQL as varchar(8000) set @SQL = 'SELECT a.entry_id, a.line_wire_link_id, b.CarrierName AS Carrier, circuit_id AS CircuitID, b.DEAddress1 AS BEndAddress, b.DEClient AS DEClient, b.DECityName AS BEndCity, RTRIM(JBA_Reference_Number) AS JBA_Reference_Number, RTRIM(JBA_Site_id) AS JBA_Site_id, line_lac, system_descriptor, COALESCE(aaa.TraderCount,0) AS TraderCount FROM (AFM_LINE_DS0 a LEFT JOIN AFM_LINE_DS0_Computed aaa ON a.entry_id = aaa.entry_id) LEFT OUTER JOIN AFM_LINE_DS0_Ext b ON a.Entry_ID = b.Entry_ID WHERE 1 = 1 AND JBA_Reference_Number IN ("061IPCE0","061IPCE0","071CAND0","071CAND0","071HKBR0","071HKBR0","071HKBR0","071IPCA0","071IPCA0","071IPCA0","071IPCA1","071IPCC1","071IPCJ1","071IPCL0","901IPCA0","901IPCX0","921IPCS0") AND Carrier = "4801" Order By Line_lac' set @SQL = REPLACE(@SQL, '"', '''') exec (@SQL) .***************************************** Tag: capture sql output parameters Tag: 18442
  - 15
    - Return values into two different textboxes I need to retrieve two values from the report, one is a number and the other is a character. Then depending on the value of the character value, I would need to return a value to one textbox and another value to another textbox. For example (sudo code for the Custom Code option): if account_nbr <> previous account_nbr then y = 0; if type = "ACTN" then y = y + 1 else y; return y to one textbox if account_nbr <> previous account_nbr then x = 0; if type = "INVS" then x = x + 1 else x; return x to another textbox Is it possible to return values to two different textboxes? or can each the above be put into the Expressions options of the two different textboxes? Thanks, Tag: capture sql output parameters Tag: 18439
  - 16
    - Including a data table in a graph Is there an option to include a 'data table' (to show values) as part of the graph - as is available with Excel? Tag: capture sql output parameters Tag: 18432
  - 17
    - Stored Procedures and Data Fields I am using a stored procedure in one of my report and it is not generating a list of fields for my report. I believe the reason I'm not able to see any fields is because in the stored proc I'm building the query string in a variable called @SQLString. At the end of the stored proc I'm calling EXEC sp_executesql @SQLString. When I run the proc in query analyzer I get a result set. Does anyone know why Reporting Services can not generate the fields for my report? Thank you in advance for your time. -Matt Tag: capture sql output parameters Tag: 18431
  - 18
    - Bar Visibility I am trying to toggle the visibility of a simple bar by the value of a parameter named DETAIL. This is the expression used =IIF(Parameters!DETAIL.Value=true,false,true) When I view the report in .NET IDE it displays fine, when deployed to the target server I recieve the following error Reporting Services Error ---------------------------------------------------------------------------- ---- a.. Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help a.. Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. a.. Object reference not set to an instance of an object. ---------------------------------------------------------------------------- ---- Microsoft Reporting Services Any help would be greatly appreciated. -Steve Tag: capture sql output parameters Tag: 18427
  - 19
    - No response from 11/5 Seem to not be able to get set up right. Have split-brain dns (Server2003 with AD) natted at the firewall with 5 domains - one internal only and dynamic; all others static for basically websites and email pointers. Websites, email, sql, asp pages are working fine - EXCEPT REPORTING SERVICES!!! I have uninstalled, reinstalled, added IUSR_MachineName to users and role assignment as browse in RS. Gave IUSR_MachineName read permissions to folder and have the following to report: With <ReportServerExternalUrl>http://domainName/ReportServer</ReportServerExternalUrl> not added. Within IIS Reports set to no anonymous and winAuthen on and ReportServer set to no anonymous and winAuth on: Security options and reports display appropriately. Not viewable using interal ip address. Viewable from outside the firewall using external ip address only after login prompt. With <ReportServerExternalUrl>http://domainName/ReportServer</ReportServerExternalUrl> added. Within IIS Reports set to no anonymous and winAuthen on and ReportServer set to anonymous and winAuth on: Using Internal IP: Login, then Folder Listing, Security options do not display and reports give page not found. Report server - report viewable Using ServerName: Login, Folder Listing, Security options do not display and reports give page not found. Report server - report viewable. Using External IP outside Firewall: Login, Folder Listing, Security options do not display and reports give page not found under Reports. Report server - report viewable. Using domain name: Reports - page not found, ReportServer - page not found. With <ReportServerExternalUrl>http://domainName/ReportServer</ReportServerExternalUrl> added. Within IIS Reports set to no anonymous and winAuthen on and ReportServer set to anonymous and winAuth on AND virtual directories added under website AND home.aspx added and moved to top under documents for virtual directory: Using Internal IP: Folder Listing (no login), Security options do not display and reports give 403.8. Report server - report viewable Using ServerName: Folder Listing (no login), Security options do not display and reports give 403.8. Report server - report viewable. Using External IP outside Firewall: Login, Folder Listing, Security options do not display and reports give page 403.8. Report server - report viewable. Using domain name url: Reports - 403.8; ReportServer - 403.8 Next? Janet Tag: capture sql output parameters Tag: 18415
  - 20
    - Basic Security I am trying to understand the basic security that RS uses. During install, a userid is used to install/create the databases. That userid is then tied to the basic services, like scheduling etc... Is this correct? Are all services using that first-supplied ID? After that when users run a report with a connection that has the credentials stored, are those the credentials used for the database access? I am currently using RS and have 2 shared connections (one to live dB and one to Test dB), both with stored credentials. Is is safe to assume that any report activity using that connection will show that userid? I just want to make sure I can track down problems when they arise. Thanks. Tag: capture sql output parameters Tag: 18405
  - 21
    - week count I have this MDX in RS: SELECT {measures.[net hours]} on COLUMNS, NONEMPTYCROSSJOIN(Worker_code.children, Worker_name.children, Worker_managerName.children, TimeDate.Week.children) on ROWS FROM WorkHours WHERE (Year.[2004], Month.[July], [Organization].[All Organization].[EPO - Enterprise Program Office] ) I need to be able to count how many weeks are in the current month (or any other period I have selected in the slicer dimension)... I would like to account for the hiredate for the employee, going to be a member property.. i can get that.. i just can't figure out how to get the coutn of the weeks. (in other words, I'm not worried about the hiredate right now-- i just need to figure out the weekcount and I'll get it from there I think) I could even do the count of weeks as a different dataset.. Right now, my weeks look like this: 'Week 36', 'Week 37', etc I am basically using this dataset in order to build a report that looks like this: EmployeeCode, EmployeeName, ManagerName, '4/15/2004', '4/22/2004', Total Hours, ExpectedHours (number of weeks times 38.75) and Variance. I have to do all of this on columns so that I can fit it into a matrix in Reporting Services. ps - year and month are Virtual Dims based off of the TimeDate dimension.. I may eventually change this to one single dimension (move the filtering from the where clause (slicerdimension) to TimeDate.Year.[2004].Month.[July].Weeks.members -- I can do this right?? Thanks so much guys Tag: capture sql output parameters Tag: 18399
  - 22
    - ISA or Reporting Services Inserting Unnecessary Port Number The machine which runs our Reporting Services has five other websites on it. Reporting services runs under port 8086, which is governed by our ISA server. An IP address translates the xxx.xxx.xxx.xxx to include the 8086. While this seems to work perfectly, parts of SQL Reports so not. For example, when I click the "Site Settings" the URL has had the :8086 added into this unnecessarially. Other parts of the site (for example, clicking a data source) do not have the 8086 in there. If I manually strip the 8086 out of there, everything works perfectly. I have searched the directories from MSSQL onward for the string "8086" and so the configuration files are not at fault. I imagine it's ISA but I'm not sure. In ISA we tried to use Link Translation to convert any xxx.xxx.xxx.xxx:8086 entries to drop the port number but to no avail. In fact, we can't get the Link Translation to do anything other than pop an error message asking for no entires including '*' of which there are none. Please let me know if anyone has an insight into this issue. Any ideas will be immensely appreciated. Tag: capture sql output parameters Tag: 18393
  - 23
    - Keep Together Table Rows I have a report that uses a table where each data record is displayed using three table rows. When the report pages it sometimes breaks after the first or second row of the three. I would like to have the three rows always on the same page. I can not find a keep together property where I can bind the three rows together and have them display as a unit. Does anyone have any thoughts on the best approach to do this within the table structure? Thanks, George Tag: capture sql output parameters Tag: 18392
  - 24
    - Adding a new static row to a matrix adds a column as well In a matrix, when I add a static row it adds another column. I don't understand this behavior. For example, take a Matrix, define a column group and a row group (just the initial columns and rows groups, just give them each a grouping expression), then right-click on the data area and do "add row". From the "add column" behavior, which adds another column to the right of the one existing one, I'd expect the row behavior to be to add a row below the current one. But in addition to that, it adds a new column to the left of the current one. I really don't get why this is, and it's driving me nuts! Example: http://www.dslextreme.com/users/swrobel/rs.html Tag: capture sql output parameters Tag: 18390
  - 25
    - Uninstallation problem - missing .DLL I am attempting to uninstall a version of SQLRS so that I can install the developer edition. The previous version installed, Standard Edition, was not installed by me. It seems to only have the help files installed; there is no Report Server, Report Manager, or SQLRS databases. I am not sure why this is, as it was installed before I started working with the box. When I attempt to uninstall the Standard version, I get the following error: "Product: Microsoft SQL Server 2000 Reporting Services Standard Edition -- Error 1723. There is a problem with this Windows Installer package. A DLL required for this install to complete could not be run. Contact your support personnel or package vendor. Action Do_LogInstallStart, entry: Do_LogInstallStart, library: C:\DOCUME~1\xxxx\LOCALS~1\Temp\2\MSI1.tmp" Of course it doesn't specifiy which DLL, and the uninstall then fails. When I attempt to run Setup.exe for the new version, I get a message saying that I need to uninstall the previous version of SQLRS before I can install this version. I cannot upgrade or uninstall with the Setup.exe wizard. Any ideas? I am thinking of just deleting all of the SQLRS registry entries and attempting to install if I cannot resolve this error. Cheers in advance. Tag: capture sql output parameters Tag: 18389

When I use a stored procedure for a dataset, is there anyway to capture
output parameter values when the stored procedure executes?
--
Thanks,

CGW

Top

Re: capture sql output parameters by Jeff

Jeff
Thu Dec 30 12:18:08 CST 2004

Sorry, the current limitation is one recordset. The Microsoft folks may
clarify future plans to support multiple recordsets or output parameters.

--
Cheers,

'(' Jeff A. Stucker
\

Business Intelligence
www.criadvantage.com
--------------------------------------
"CGW" <CGW@discussions.microsoft.com> wrote in message
news:96E5024E-A545-4D13-A49D-79ECAC33AD36@microsoft.com...
> When I use a stored procedure for a dataset, is there anyway to capture
> output parameter values when the stored procedure executes?
> --
> Thanks,
>
> CGW

Top