stored procedure in sql reportnig 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
    - Using a CSV as data source Hi, I'm trying to use a csv file as my data source, I've used the Microsoft.Jet.OLEDB.4.0 as my OLE DB Provider. My conexion string is Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Mydir;Extended Properties="text;HDR=Yes;FMT=CSVDelimited" and my query is Select * from myfile.csv But the result set I've got shows just one column, instead of the three that are in the file. (separated by comma) What's wrong? How could I config the datasource to get data from a csv without importing it to my SQL DB? Regards, Vinicius Bellino Tag: stored procedure in sql reportnig services Tag: 24411
  - 2
    - Movenext to next record in dataset if condition not met! Does anyone know how I can not display a record or skip to next record in dataset if a condition is not met? I can get it to put a blank when the condition is true, but the report is displaying the row where the data would be. So, it looks like a blank line. For example I am trying to say If the field value coming in is < 6 display value Else skip to next record. Can anyone help? Tag: stored procedure in sql reportnig services Tag: 24405
  - 3
    - using matrix in reports hi, i need to bring the subtotal column before the Dynamic clumns in the matrix... Please let me know how to do this... Thanks, Tag: stored procedure in sql reportnig services Tag: 24403
  - 4
    - problem with images I have a problem with images being displayed in a report when I select the image source coming from the web. The URL I am specifing is http://localhost/Scimitar/media/thumbnail.aspx?lmediaid=1742 In the layout i can see the image, in the preview i cannot nor in the deployed report when i navigate to this page in a browser the image is shown ok http://localhost/Scimitar/media/thumbnail.aspx?lmediaid=1742 I have downloaded service pack 1 which is supposed to resolve this problem Can anyone help? Thanks Richard Tag: stored procedure in sql reportnig services Tag: 24401
  - 5
    - exporting a selection of the report hi, when you have a report that uses groups, it's apparently very difficult to export only a certain area from that report to eg an excel sheet... example: customername 1 product1 price 1 product2 price 2 customername 2 product1 price 1 customername 3 and now i only want the customer names exported to my excel sheet. Any help would be really appreciated ;) thanks Koen Vermeire koen.vermeire@gmail.com Tag: stored procedure in sql reportnig services Tag: 24399
  - 6
    - rs, error We have reviewed the file cab that it leaves log. Let us think that the problem can be by the library of the performance monitor. Had has this problem sometime? Greetings Tag: stored procedure in sql reportnig services Tag: 24397
  - 7
    - Reporting Services setup error I have been setup reporting services success, but after I modify the password of Sql server's default user--"sa",the reporting service can not run, I uninstall the reporting services and try to install it again, but cannot install success. And I modify the password back, also cannot install success. An error window pop up that is: cannot open the user database, install error. Please help me! Tag: stored procedure in sql reportnig services Tag: 24393
  - 8
    - Display of MICR font. I have a check printing functionality which is implemented as an rdl. The check number needs to render in MICR . When the report is rendered in pdf, the MICR font is not getting displayed. I have installed the MICR font on the machine containing the RS and restarted it. Where else may I be going wrong in ? Any help will be appreciated. Thanks. Tag: stored procedure in sql reportnig services Tag: 24389
  - 9
    - language property BUG when using expressions. in one of my projects i was dynamically setting the Language property of tables, textboxes etc , but it just wasn't working.. For my needs i solved the problem by rather setting dynamic Formats however i still thing this is a bug.. it is shown in the example below.. i have textboxes where each are set to =code.mydate which just returns a datetime the first textbox has language set to default (which is english (US) so the date gets shown in MM/DD/YYYY format the next one is set to English (United Kingdom) so it correctly shows it as DD/MM/YYYY however when i set it to English (United Kingdom) via a function or even just an expression ="English (United Kingdom)" it doesn't work.. the language property only works when it is static, not dynamic. Karl <?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> <RightMargin>1in</RightMargin> <Body> <ReportItems> <Textbox Name="textbox4"> <Style> <PaddingLeft>2pt</PaddingLeft> <Format>d</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <Language>="English (United Kingdom)"</Language> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>3</ZIndex> <Top>0.875in</Top> <Height>0.25in</Height> <Width>1.75in</Width> <CanGrow>true</CanGrow> <Value>=code.mydate</Value> <Left>0.25in</Left> </Textbox> <Textbox Name="textbox3"> <Style> <PaddingLeft>2pt</PaddingLeft> <Format>d</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <Language>=code.languagefunc</Language> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>2</ZIndex> <Top>1.25in</Top> <rd:DefaultName>textbox3</rd:DefaultName> <Height>0.25in</Height> <Width>1.75in</Width> <CanGrow>true</CanGrow> <Value>=code.mydate</Value> <Left>0.25in</Left> </Textbox> <Textbox Name="textbox2"> <Style> <PaddingLeft>2pt</PaddingLeft> <Format>d</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <Language>en-GB</Language> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>1</ZIndex> <Top>0.5in</Top> <rd:DefaultName>textbox2</rd:DefaultName> <Height>0.25in</Height> <Width>1.75in</Width> <CanGrow>true</CanGrow> <Value>=code.mydate</Value> <Left>0.25in</Left> </Textbox> <Textbox Name="textbox1"> <Style> <PaddingLeft>2pt</PaddingLeft> <Format>d</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <Top>0.125in</Top> <rd:DefaultName>textbox1</rd:DefaultName> <Height>0.25in</Height> <Width>1.75in</Width> <CanGrow>true</CanGrow> <Value>=code.mydate</Value> <Left>0.25in</Left> </Textbox> </ReportItems> <Style /> <Height>2.875in</Height> </Body> <TopMargin>1in</TopMargin> <Code>Public Function mydate as DateTime return CDATE("2005-5-30") End Function Public Function languagefunc as string return "English (United Kingdom)" End Function</Code> <Width>6.5in</Width> <LeftMargin>1in</LeftMargin> <rd:SnapToGrid>true</rd:SnapToGrid> <rd:DrawGrid>true</rd:DrawGrid> <Description /> <rd:ReportID>b3046005-89ba-47b1-aa40-b446a2205b39</rd:ReportID> <BottomMargin>1in</BottomMargin> <Language>en-US</Language> </Report> Tag: stored procedure in sql reportnig services Tag: 24388
  - 10
    - Report Parameter Problem I have a report based on a stored procedure with three parameters: Start Date, End Date, and Salesperson. The first two are required, and the Salesperson is not. In the report, the Salesperson is based on a query which provides a drop down for choosing a name. It is set to allow nulls and blanks. When I run the report in Visual Studio preview, if no Salesperson is chosen, and both dates are entered, no data is returned. Doing the same thing via debug in a browser, (the drop down is not blank, but says <Selelct a value>), I get prompted to supply the Salesperson parameter. Supplying a value for Salesperson in both cases works fine, but I want the user to have the option to get all the data, not just for a particular person. I've covered this case in the stored procedure, so I'm not sure what is getting passed in the previewer when nothing is entered and no data is returned. If I run the query (sp) via the Data tab, and provide exactly the same values for the parameters, I get the data I expect, and no prompt for the Salesperson. If I put a default value in for the Salesperson, (non-queried), e.g. "All", the preview in VS goes crazy, and locks up. I would have thought with allowing nulls and/or blanks, this should work. Am I missing something? Thanks for any help, Tom Tag: stored procedure in sql reportnig services Tag: 24385
  - 11
    - Page break problem when rendered as PDF I have a problem where a "page break at start" for a group does not occur when the first change in group happens. For subsequent changes in the group value, the page break works exactly as expected. This problem only happens when rendered as PDF (and tiff). Rendering as MHTML works a treat. Anyone got any ideas on how to fix it ? Tag: stored procedure in sql reportnig services Tag: 24384
  - 12
    - Rendering a Batch of Reports I have a business need to allow the user to render a batch of "End of Day" reports with one event click. All of these reports currently exist as separate reports in Reporting Services. I can schedule all of these to run together but I'm wondering how I can handle ad-hoc requests to run them? Thanks, Matt Tag: stored procedure in sql reportnig services Tag: 24376
  - 13
    - Migrating all reports to a new server I'm Managing Reporting Services in a mid-size company, and we are just beginning to develop reports for different departments....We just set up a new server and redeployed all of our reports (there were just a few so far).... My question is..What happens when we have hundreds of reports and need to migrate our entire reporting services system to a new server? Subsequently, In a worst-case situation, how could we recover reports? I appreciate your help! -Scott Tag: stored procedure in sql reportnig services Tag: 24372
  - 14
    - Migrating all reports to a new server I'm Managing Reporting Services in a mid-size company, and we are just beginning to develop reports for different departments....We just set up a new server and redeployed all of our reports (there were just a few so far).... My question is..What happens when we have hundreds of reports and need to migrate our entire reporting services system to a new server? Subsequently, In a worst-case situation, how would we recover reports? I appreciate your help! -Scott Tag: stored procedure in sql reportnig services Tag: 24371
  - 15
    - Migrating all reports to a new server I'm Managing Reporting Services in a mid-size company, and we are just beginning to develop reports for different departments....We just set up a new server and redeployed all of our reports (there were just a few so far).... My question is..What happens when we have hundreds of reports and need to migrate our entire reporting services system to a new server? Subsequently, In a worst-case situation, how would we recover reports? I appreciate your help! -Scott Tag: stored procedure in sql reportnig services Tag: 24370
  - 16
    - When I try to deploy, the logon fails. I am trying to deploy my reports onto a report server. I am using Windows authentication and I am the dbo. The test connection in the datalink properties works fine, both to the database and to the report server. I have tried with SSL and without SSL. Neither works. The error is: The report server cannot open a connection to the report server database. The logon failed. Can someone please help me solve this problem? Thanks. Tag: stored procedure in sql reportnig services Tag: 24369
  - 17
    - Email report Hi Freinds, SQL2005 beta, I create a subscription and want to email report based on a schedule. It doesn't seems working, no error either. Where can I track it down? Which config files keep the mail SMTP information? Thanks, Pat Tag: stored procedure in sql reportnig services Tag: 24368
  - 18
    - MHTML Streaming I am streaming an MHTML file to an aspx page: Response.Clear() Response.AddHeader("Content-Disposition", "inline; filename=MyFile.mht") Response.AddHeader("Content-Length", MyByteArray.Length.ToString) Response.ContentType = "multipart/related" Response.BinaryWrite(MyByteArray) Response.Flush() When I load the aspx page on my computer with IE... I get "Invalid syntax error"... when I load the same page... thru HTTP access from a co-worker's computer... it loads fine... what am I doing wrong? Not sure if it makes a difference... I had the address bar hidden so I didn't notice at first... when my co-worker renders the stream the url stays the same... for me I get mhtml: in front of the url... in addition to the "invalid syntax" error. Tag: stored procedure in sql reportnig services Tag: 24365
  - 19
    - how implement multi-parameters dinamic how can choose more than one parameter in one parameter ejemp id name 1 a 2 b 3 c 4 e I would like can choice 1 and 3 and 4 and same time. thanks Tag: stored procedure in sql reportnig services Tag: 24364
  - 20
    - Where are uploaded files stored When you upload a file in RS - it just gets put in the folder that you are currently in. Does anyone know where there file is physically stored? I uploaded a file and did a search on our RS server and it came up with nothing. I am able to delete my copy of the uploaded file so it's gotta have a copy stored somewhere I just don't know where. Tag: stored procedure in sql reportnig services Tag: 24360
  - 21
    - How to render using .Rendering.ExcelRenderer.ExcelRenderer How do i render a report in Excel using Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer? I have the RDL file available. I need to use the RDL file and render the report. I could do this using Web service. But how to do this using rendering extension? Tag: stored procedure in sql reportnig services Tag: 24359
  - 22
    - OLE DB Provider no registered on local machine I am receiving the following error when trying to run my report from the server: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'SALESLOGIX'. (rsErrorOpeningConnection) Get Online Help The 'SLXOLEDB.1' provider is not registered on the local machine. No error information available: REGDB_E_CLASSNOTREG(0x80040154). I checked and this provider seems to only be available under the profile it was installed. That being said I installed it under both profiles for my service user and DB user. I checked the provider by testing it with a udl file and it worked on both profiles. I rebooted the machine and I am still having the same issue. Tag: stored procedure in sql reportnig services Tag: 24358
  - 23
    - Dynamic way to change font, font size, etc. in reports Hi, I have one report format for many clients. Some of them request different fonts and font sizes. I don't want to duplicate reports because of differnt fonts. Is there a dynamic way to change font or font size using only one report format? Thanks. Chuck Tag: stored procedure in sql reportnig services Tag: 24357
  - 24
    - Dynamic way to change Font, Size, etc. Hi, I have one report format for 20 companies. Some of them require differnt fonts and font sizes. I don't want to duplicate reports because they need different font format. Is there a dymanic way to change font using one report only? Thanks. Chuck Tag: stored procedure in sql reportnig services Tag: 24356
  - 25
    - Error loading custom assembly in Designer I've created a custom assembly using C# that provides utility functions for reporting services. I'm getting a the following compile time errors. 1. Error while loading code module: 'accentopto.report.utilities, Version=1.0.1885.19928, Culture=en-US, PublicKeyToken=null'. Details: File or assembly name accentopto.reporting.utilities, or one of its dependancies, was not found. 2. Error in class instance declaration for class Utilities: [BC30002] Type 'Utilities' is not defined. I've verified the version metadata using ildasm. Here are the CodeModules and Classes elements from the .rdl file. <CodeModules> <CodeModule>accentopto.report.utilities, Version=1.0.1885.19928, Culture=en-US, PublicKeyToken=null</CodeModule> </CodeModules> <Classes> <Class> <ClassName>Utilities</ClassName> <InstanceName>Utilities</InstanceName> </Class> </Classes> Here is the CodeGroup element in the rspreviewpolicy.config file for the Designer <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="Execution" Name="Accent_Reporting_Utilities" Description="Code group for Accent data processing extensions"> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\accentopto.report.utilities.dll"/> </CodeGroup> I've verified that the assembly is in the Report Designer directory. Here's the code snippet from the Utilities class. -- using System; using System.Globalization; namespace com.accentopto.bizlogic.reporting.rs_shared { /// <summary> /// Shared reporting utilities /// </summary> public class Utilities { private CultureInfo culture; private Calendar calendar; public Utilities() { this.culture = new CultureInfo("en-US", false); this.calendar = culture.Calendar; } protected DateTime WeekEndDate(string inDate) { DateTime dateOut, dateIn; string day; dateIn = Convert.ToDateTime(inDate, culture); day = dateIn.DayOfWeek.ToString(); switch(day) { case "Sunday": dateOut = dateIn.AddDays(6); break; case"Monday": dateOut = dateIn.AddDays(5); break; case "Tuesday": dateOut = dateIn.AddDays(4); break; case "Wednesday": dateOut = dateIn.AddDays(3); break; case "Thursday": dateOut = dateIn.AddDays(2); break; case "Friday": dateOut = dateIn.AddDays(1); break; default: dateOut = dateIn; break; } return dateOut; } /* * Entry point for testing only * public static void Main(string []args) { string printDate; Utilities util; util = new Utilities(); printDate = util.WeekEndDate(args[0]).ToString(); Console.WriteLine(printDate); } */ } } The only thing that I can think of is that my refs to System.Globalization aren't available. Thanks for any help. -- -- Chris Mackey Sr. Software Developer Accent Optical Technologies Tag: stored procedure in sql reportnig services Tag: 24354
- Next
  - 1
    - Error while loading custom assembly in Designer I've created a custom assembly using C# that provides utility functions for reporting services. I'm getting a the following compile time errors. 1. Error while loading code module: 'accentopto.report.utilities, Version=1.0.1885.19928, Culture=en-US, PublicKeyToken=null'. Details: File or assembly name accentopto.reporting.utilities, or one of its dependancies, was not found. 2. Error in class instance declaration for class Utilities: [BC30002] Type 'Utilities' is not defined. I've verified the version metadata using ildasm. Here are the CodeModules and Classes elements from the .rdl file. <CodeModules> <CodeModule>accentopto.report.utilities, Version=1.0.1885.19928, Culture=en-US, PublicKeyToken=null</CodeModule> </CodeModules> <Classes> <Class> <ClassName>Utilities</ClassName> <InstanceName>Utilities</InstanceName> </Class> </Classes> Here is the CodeGroup element in the rspreviewpolicy.config file for the Designer <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="Execution" Name="Accent_Reporting_Utilities" Description="Code group for Accent data processing extensions"> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\accentopto.report.utilities.dll"/> </CodeGroup> I've verified that the assembly is in the Report Designer directory. Here's the code snippet from the Utilities class. -- using System; using System.Globalization; namespace com.accentopto.bizlogic.reporting.rs_shared { /// <summary> /// Shared reporting utilities /// </summary> public class Utilities { private CultureInfo culture; private Calendar calendar; public Utilities() { this.culture = new CultureInfo("en-US", false); this.calendar = culture.Calendar; } protected DateTime WeekEndDate(string inDate) { DateTime dateOut, dateIn; string day; dateIn = Convert.ToDateTime(inDate, culture); day = dateIn.DayOfWeek.ToString(); switch(day) { case "Sunday": dateOut = dateIn.AddDays(6); break; case"Monday": dateOut = dateIn.AddDays(5); break; case "Tuesday": dateOut = dateIn.AddDays(4); break; case "Wednesday": dateOut = dateIn.AddDays(3); break; case "Thursday": dateOut = dateIn.AddDays(2); break; case "Friday": dateOut = dateIn.AddDays(1); break; default: dateOut = dateIn; break; } return dateOut; } /* * Entry point for testing only * public static void Main(string []args) { string printDate; Utilities util; util = new Utilities(); printDate = util.WeekEndDate(args[0]).ToString(); Console.WriteLine(printDate); } */ } } The only thing that I can think of is that my refs to System.Globalization aren't available. Thanks for any help. -- Chris Mackey Sr. Software Developer Accent Optical Technologies Tag: stored procedure in sql reportnig services Tag: 24353
  - 2
    - No Data Selected message back to .Net Hi All We have a .net application calling some reporting services reports and we pass the parameters to the reports from the application. When no data is selected, is there any way to pass a paramter or something back to the .net application so that we can display a 'No data selected' message within the .net application. Thanks Pete Tag: stored procedure in sql reportnig services Tag: 24350
  - 3
    - How to hide individual cells I have a report with a table. Initially the details are hidden and the table looks like this: +Item Summary1 Summary2 Summary3 What I want to do is to hide Summary1, Summary2 and Summary3 when I expand Item and leave Item visible. Is this possible? Tag: stored procedure in sql reportnig services Tag: 24342
  - 4
    - Unable to Display Integer Values in the Report Hello, I have been trying to create a report which gets the Name and ID of a person and then print an X in the column of a Head H if the person belongs to the Head H. In the Stored Proc I insert a 0 if no entry exists under the head for a person or the # of times that persons name is under the head (eg 2 times value inserted is 2). I am able to print the name and ID just taking the values of the fields But when I try to print number in the columns using the iif(fields!head1.value = 0, "", "X") I dont print anything. i even tried to fields!head2.value but still I dont get any thing printed out. Is it a problem from the Stored Procedure or Some bug in my design/code ? Thanks Ravi Tag: stored procedure in sql reportnig services Tag: 24338
  - 5
    - Setting DataSourceReference before call to CreateReport I am working on an automated report deployment tool. I'm working on the last feature, being able to override the datasource in the RDL to point to a common shared one in a specific directory on the report server. I have the data source reference override working for after a deployment. But the deployment of the report doesn't work if the data source doesn't exist in the same directory on the report server as the report. I can change the data source reference after deployment if the data source exists in that directory. I am looking into ways to updating the data source references prior to calling CreateReport. One way is to update the RDL file programatically, which I can do, but when deploying up to 200 reports at a time, this can be very slow. I found another method that might work. I can set properties via the Property objects prior to calling Create Report. My question is, is there a property that I can set to set the data source references on this report? I can't find a list of available properties that can be passed into CreateReport. Thanks, Mike Tag: stored procedure in sql reportnig services Tag: 24336
  - 6
    - Searching for SQL Lab-Files used with Hands-On Lab Manual SQL 2005 Hi, I'am searching for the lab files needed with the Hands-On Labmanuals downloaded from the SQL2005 site. We need: c:\SQL Labs\Lab Projects\.... all subdir's and files. Should be available on the ResourceKit DVD from SQL 2005. The download of this resourcekit does not include these files. Regards, Frank Tag: stored procedure in sql reportnig services Tag: 24333
  - 7
    - Dynamic Parameters I need to be able to schedule a report with a dynamic parameter. For example, The user may select "Start of Last Month" as the date parameter value. I then need to turn this into something like : CStr(Month(DateAdd("m", -1, Date))) & "/01/" & CStr(Year(DateAdd("m", -1, Date))) When scheduling this report, this parameter should then always be "the Start of Last Month" I don't know how to make the parameter look at the code as an expression and not as a String. Any help would be appreciated. Tag: stored procedure in sql reportnig services Tag: 24331
  - 8
    - Error during deploy Hi, I am publishing my reports to a server and for 2 out of 7 reports I receive the following error message: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was thrown. On my machine the reports worked fine. The server does process the other reports correctly. The server is a SQL Server 2000, my machine has SQL Server 2005 Beta 2. These two failing reports don't seem to have anything special compared to the others. Any suggestions what might be causing this? (And how to solve it?) Thanks a lot for your help, Edgar -- Message posted via http://www.sqlmonster.com Tag: stored procedure in sql reportnig services Tag: 24330
  - 9
    - sort on a calculated column I have a table like this: Product M1 M2 AddCol ABC 3 2 5 DEC 4 5 9 DEF 2 4 6 The third column is the addition of the previous two columns. (The actual math is much more complex than this example and I can't move it to the database layer.) I would like to sort my table depending on this calculated column. Hiding the table and showing another after sorting programmatically is a performance hit for me. Any ideas? Thank you. Regards, Cem Demircioglu Tag: stored procedure in sql reportnig services Tag: 24329
  - 10
    - Forced auto refresh to avoid page caching Good Afternoon! I've run into an issue whilst developing a report using VS.NET, RS and SQL Enterprise Server 2000. The problem I have is that I'm using RS to develop a web based app that can be used to edit base table data. I have the app working fine, but it keeps taking it's data from the cached reports. Obviously, this means that every time a change is made to the base data, the user needs to refresh the page - not an easy thing to remember when processing several hundred entries. I have the "Do not cache temporary copies of this report" radio button selected (by default). Also, the "Autorefresh" text box is not an option I can take as it is unusable when there are groups set up on the table - they keep expanding and collapsing. I've seen ways of embedding some (rather shaky) HTML to force the refresh. See below: <META HTTP-EQUIV="Pragma" CONTENT="no-cache"> <META HTTP-EQUIV="Pragma-directive" CONTENT="no-cache"> <META HTTP-EQUIV="cache-directive" CONTENT="no-cache"> Is anyone aware of how I can write this into the .rdl, or report? Or, is there a way to force the page to refresh? Thanks in advance Jon Tag: stored procedure in sql reportnig services Tag: 24325
  - 11
    - Runtime Exception During "Save As" Excel (Still Unresolved) Hello, I have a relatively simple report (no sub reports or objects nested in table cells, etc) that apparently runs fine that I can export to any other format with no problems. However, when I export the report to Excel format I get this error: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index This happens in both the report designer and when access via the Report Server. I've applied Reporting Services SP1. I know that SP2 is in beta. In this a known issue? Here is how the error is documented in the Reporting Services log: aspnet_wp!library!bd8!02/21/2005-10:19:17:: i INFO: Call to RenderNext( '/XXX/ResultsBySegment/ResultsBySegment' ) aspnet_wp!chunks!bd8!02/21/2005-10:19:17:: i INFO: ### GetReportChunk('RenderingInfo_EXCEL', 2), chunk was not found! this=dfc728bb-8ff6-4137-ac52-650f9d9b5a4a aspnet_wp!reportrendering!bd8!02/21/2005-10:19:24:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown., ; Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index at System.Collections.ArrayList.get_Item(Int32 index) at Microsoft.ReportingServices.Rendering.BIFFUtility.Formula.ProcessParsedExpression() at Microsoft.ReportingServices.Rendering.BIFFUtility.Formula.GetData() at Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteCell(Cell biffCell, Stream stream, ArrayList cellAddress, Int32 row, Int32 col, UInt32 firstRowEndStreamPos) at Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32 minCol, Int32 maxCol) at Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer excelRenderer, Stream stream, Int32 offset) at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout pageLayout, Int32& currentPageNumber, Stack& stack) at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout& lastPageLayout) at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets() at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet() at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream createAndRegisterStream) at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream createAndRegisterStream) at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) --- End of inner exception stack trace --- at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback) --- End of inner exception stack trace --- aspnet_wp!webserver!bd8!02/21/2005-10:19:32:: e ERROR: Reporting Services error Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index Thank you, Bryan Tag: stored procedure in sql reportnig services Tag: 24323
  - 12
    - Table - How to add all rows above for a column? I am using a Table and I wanted to add all rows above for particular columns. It it possible without using the = Sum(Fields!HistoryDollars.Value) ? I certain Fields that if I use the =SUM() they will not work correctly. Maybe by referencing the the controls inside the Table? Thanks Peace in Christ Marco Napoli http://www.ourlovingmother.org Tag: stored procedure in sql reportnig services Tag: 24322
  - 13
    - PDF rendering error; log file entries included. I am having a problem getting a report with many charts to export to PDF. Currently the report contains 52 line charts (possibility for much more than that)and fails when the subscription is running. If I only choose data that returns about 10 or less charts than it will successfully create the PDF. Is there a file size limitation or another setting I am missing in the configuration? Begin of log entries. ReportingServicesService!reportrendering!f54!02/25/2005-20:37:19:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown., ; Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> System.Threading.ThreadAbortException: Thread was being aborted. at System.Drawing.SafeNativeMethods.GdipDrawImageRectI(HandleRef graphics, HandleRef image, Int32 x, Int32 y, Int32 width, Int32 height) at System.Drawing.Graphics.DrawImage(Image image, Int32 x, Int32 y, Int32 width, Int32 height) at System.Drawing.Bitmap..ctor(Image original, Int32 width, Int32 height) at System.Drawing.Bitmap..ctor(Image original) at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.Process32bppArgbImages(CanvasImage image, StringBuilder streamString, StringBuilder imageContentString, Int64& streamLength) at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessImage(CanvasImage image, Double left, Double top, Double width, Double height, Boolean scaleImage) at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawImage(OutlineObjects outlines, CanvasImage image, Double left, Double top, Double width, Double height) at Microsoft.ReportingServices.Rendering.ImageRenderer.Chart.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.ListContent.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.List.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase theComposition, Report theReport, Boolean needTotalPages, Int32 startPage, Int32 endPage, Boolean render) at Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStreamCallback) at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) --- End of inner exception stack trace --- at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3, CreateReportChunk A_4, Boolean& A_5) --- End of inner exception stack trace --- ReportingServicesService!runningjobs!f54!02/25/2005-20:37:22:: i INFO: CancelableJobExecution.Execute caught some other thread abort exception ReportingServicesService!library!f54!02/25/2005-20:37:22:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. ReportingServicesService!emailextension!f54!02/25/2005-20:37:24:: Error sending email. System.Threading.ThreadAbortException: Thread was being aborted. at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification) ReportingServicesService!notification!f54!02/25/2005-20:37:25:: Error thrown by delivery provider: System.Threading.ThreadAbortException: Thread was being aborted. at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification) at Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item) ReportingServicesService!notification!f54!02/25/2005-20:37:26:: e ERROR: Error occured processing notification. Thread was being aborted. ReportingServicesService!dbpolling!f54!02/25/2005-20:37:27:: NotificationPolling no longer processing item 36b6fea8-ebac-4de7-b5ef-74c792df8276, will be requeued ReportingServicesService!dbpolling!f54!02/25/2005-20:37:27:: Queue worker thread caught unhandled exception: System.Threading.ThreadAbortException: Thread was being aborted. at Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item) at Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem item) at Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object state) Tag: stored procedure in sql reportnig services Tag: 24321
  - 14
    - URL Access not working I'm trying to get this URL to hide the parameters and pass values directly, but it always opens with the defualt parameters. http://sql_box/Reports/Pages/Report.aspx?ItemPath=%2fAM%2fAM+Stats&rs:Command=Render&rs:Format=HTML3.2&rc:Parameters=false&StartDate=2/1/2005&EndDate=2/10/2005 Tag: stored procedure in sql reportnig services Tag: 24314
  - 15
    - ReportServer refuses to install Hi all, I'm getting an odd problem installing Reporting Services, hope someone can shed some light. First a bit of background. I had RS SP1 installed on SBS2003 and it was working fine. Joined the SP2 beta and installed this. At first it seemed to be working OK including web parts on the Sharepoint site. Then I started getting errors with reports unable to load ReportingServicesCompression.dll - only the Sample Reports would work. I couldn't find any resolution to this so finally decided to remove RS and start from scratch. Now when I run the install from CD the ReportServer components do not install at all. The steps I am presented with are 1. Accept licence agreement 2. Component update 3. System Prerequisites Check where the Sharepoint warning is displayed 4. The setup dialog appears stating that I can click next to continue but instead the routine launches straight into the install process 5. Dialog to say install has completed successfully I've tried installing a few times generally without even getting output in the RSStp_.cab file. The last time I did get something but I cannot see any obvious errors. Has anyone experienced this or have any clue where to look or what to try next? Any suggestions would be appreciated. Thanks, -- Andrew Gaskin Tag: stored procedure in sql reportnig services Tag: 24313
  - 16
    - Prob installing on SharePoint Portal 2003 Hello, I have a problem installing Reporting Services on a SharePoint Portal Server. I have followed the procedure outlined. I have followed the procedure listed in the msdn article for troubleshooting a side by side installtion of reporting services and Windows Sharepoint services listed here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_9fdy.asp The error message I receive when I try to access the reportserver site is: The XML file D:\inetpub\wwwroot\web.config could not be loaded. Access to the path D:\inetpub\wwwroot\web.config is denied. The ReportServer service is running as a domain user that is a member of the administrators group on the server. The server has an SSL certificate. Please help! Thanks! Tag: stored procedure in sql reportnig services Tag: 24310
  - 17
    - Evaluation Edition of RS has expired? I am getting this message: rsEvaluationCopyExpired This copy of the Evaluation Edition of Reporting Services has expired. I downloaded this version from internet and I thought it is free. Is it not? How should I solve it? Thanks, Jim. Tag: stored procedure in sql reportnig services Tag: 24308
  - 18
    - report has user profile dependencies and cannot be run unattended This is on a report that I am trying to schedule for deivery. Seemed to work fine the first week, now this. Failure sending mail: The '/CPlus Home/Contract Income' report has user profile dependencies and cannot be run unattended. It's on a timed subscription, and has the last run date on Friday, as it should. Do I need to set up an exchange profile for sql rpt srv to run under? Tag: stored procedure in sql reportnig services Tag: 24306
  - 19
    - RS, error. When we have installed the Reporting Services, it leaves an error to us in event to viewer. This it is the error: Schedule and delivery processor Error id event 113 somebody has had this problem? Thanks Tag: stored procedure in sql reportnig services Tag: 24305
  - 20
    - Subreport attributes??? Is it possible to acces some attributes from a report??? I mean, I wolud like to display or hide a table if the subreport is empty? is there a value from the subreport that i can use?? my expression would be like: =iif(subreport . ????? = XXXX, AAA, BBB ) Tag: stored procedure in sql reportnig services Tag: 24304
  - 21
    - Value Expression contains an error. Attempted to divide by zero. Hi, I have a matrix where a couple of columns are percentages derived from other fields. It is possible that one of the fields I am trying to divide on will have no data. I am using the following expression in the Value property of the textbox. =IIF(Sum( Fields!previous_month.Value)>0,(Sum( Fields!this_month.Value))/Sum( Fields!previous_month.Value),"") I wanted to try and not display anything if the field I was dividing by was Zero, but I still get the value displayed as "#Error" I am assuming this is because the report has to calculate the (Sum( Fields!this_month.Value))/Sum( Fields!previous_month.Value) value at the same time as it determines whether Sum( Fields!previous_month.Value)>0 My question is, is there a way to achieve what I am trying to do without an errror? Is there a way to see whether a value is zero or does not exist and then display something else or BLANK instead of the calculated value, but display the calculated value if the field value divided by is greater than zero? Thanks Tag: stored procedure in sql reportnig services Tag: 24303
  - 22
    - Is this possible? Hi, I have a request for dynamic creation of the chart axis scale at runtime from some users, based on the displayed results. Is this possible? Thanks Tag: stored procedure in sql reportnig services Tag: 24302
  - 23
    - Is this possible? Tag: stored procedure in sql reportnig services Tag: 24301
  - 24
    - Export to Excel - Change the Sheet Name I need to change the sheetname with the field value retured by the stored procedure. Say the stored procedure returns 10 rows, when exporting the report , the report should contain 10 sheets with the sheetname(field 1 value). How can I do this. Balaji -- Message posted via http://www.sqlmonster.com Tag: stored procedure in sql reportnig services Tag: 24298
  - 25
    - Create a hidden resource Good day I am using the CreateResource method (C#) to upload a jpg file to a report server. I have completed this task, however I am manually navigating to the Report Manager, going to the Properties section of the jpg file and checking the "Hide in list view" checkbox. I am sure this can be done programmatically, and I suspect it has to do with this last parameter of the CreateResource method? Please could someone help me. Thanks Tag: stored procedure in sql reportnig services Tag: 24296

hi,
my stored procedure has two select statements so it returns 2 result sets.
Can i refer to these results sets from my table object in sql reporting
services??

Thanks

Top

Re: stored procedure in sql reportnig services by Bruce

Bruce
Tue Mar 01 08:13:09 CST 2005

No, RS only supports only one result set. Either split it into two SP or add
a parameter to determine which to return (of course it will get called
twice).

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"CCP" <CCP@discussions.microsoft.com> wrote in message
news:01231CFE-3303-4705-82A6-6A50B8C506EE@microsoft.com...
> hi,
> my stored procedure has two select statements so it returns 2 result sets.
> Can i refer to these results sets from my table object in sql reporting
> services??
>
> Thanks

Top