Dynamic Sub-Reports

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
    - report subtotal calculation I added a matrix table to a report and a subtotal row. I have buyers and a measure buyers count. Buyers is the total sum where as buyers count is like a distinct count if on buyer comes twice. Now I'd like to display this for several stores. I created a matrix with the storename as a column group and a subtotal column. I built my 2 measures in the cube but my subtotal delivers wrong results because if one buyer buys in 2 different stores it should calculate also the distinct count but it sums the buyers up. any ideas? Tag: Dynamic Sub-Reports Tag: 57732
  - 2
    - Updating I have a really simple question, I am sure, but I am drawing a huge blank. All I want to do is go into my table called STATUS_AND_DATES and change the field called JOB_STATUS. I want to change all the records in that field that say 'For Sale/Lease' to 'For Sale'. How do i do an update like that. Lost in Arkansas. Thanks Tag: Dynamic Sub-Reports Tag: 57729
  - 3
    - Whitespace with hidden fields I have a table row that I expanded and merged. Within this I put a rectangle to and then used additional text boxes to get the formatting I want. It looks really great I have the group header the same way. One issue, I have a two large fields in detail section of the group. (this is in the rectagle, in a single row of the table... merged) When one of the large fields is empty, I set the visibility to hidden. (and the lable for the text box) no problem, except in the report the whitespace for that box remains... any ideas on how to make the white space go away when the box is empty? Thanks Tag: Dynamic Sub-Reports Tag: 57727
  - 4
    - URL Access to Reporting Services behind firewall I'm trying to determine if it's possible to have a web front end site that displays reporting services reports from a Report Server that is placed inside the firewall. Currently users log into the web site through a form authenticating them against RSA Cleartrust. My current solution uses web services to render the report, but I end up having to create my own controls to support report parameters and I'm missing features such as in interactive sorting. The examples that I've seen always seem to have the reporting server sharing space with the external facing web server and this something that we're not willing to do. Is it possible to use URL access or the report viewer control in this scenario? Tag: Dynamic Sub-Reports Tag: 57726
  - 5
    - Creating a workbook with multiple worksheets Hello, I would like to ask if you know, how I can create a workbook with multiple worksheets. In MS Access in know that if you export on the same spreadsheet it will not overwrite the workbook, rather, add one more worksheet in it. Anything similar in RS? Many thanks. Tag: Dynamic Sub-Reports Tag: 57721
  - 6
    - User Credential Logon Information Hello, We have the following configuration: 1. Windows 2003 2. SQL Server 2000 Standard Edition 3. We don't have the domain setup. 4. We are using the Data sources option "Credentails Stored securely in the report server". Currently RS reports are working fine in Windows 2000 environment with user authentication prompt. When we deployed the reports in Windows 2003 the reports prompts for the user authentication. We don't want the user authentication prompt. Can anyone please share the knowledge how we could avoid the user authentication prompt and why we are facing this problem in Windows 2003 environment only? Let us know if you need more information. PC Tag: Dynamic Sub-Reports Tag: 57720
  - 7
    - Export to PDF with Purchased Font? Hello, I am trying to export to PDF using Reporting Services 2005. My report is a simple invoice report which includes a custom OCR and Barcode font. Whenever I export to PDF using Reporting Services, my report does not render correctly on machines that don't have the font installed (i.e. our customers\vendors). I know there are certain fonts that are not embeddable, but I have verified that the fonts I am using are in fact embeddable. Is there a way to get Reporting Services PDF Rendering Extension to keep the formatting of the fonts, either as an image or by embedding the fonts with the pdf? Thanks!! Tag: Dynamic Sub-Reports Tag: 57719
  - 8
    - drill down in reports hi, I just made a report with a build in drill down. when not clicking on the drill down sign it shows the total and when clicking on drill down it shows how the total is built. I also add a graph to this table. Is it possible to change the figures from the graph according to the drill down level? Thanks! Tag: Dynamic Sub-Reports Tag: 57717
  - 9
    - order columns hi, if got a dimensional table with an age band - ex.: 0-5 years, 6-10,.... wenn I'd like to browse the cube the row is not sorted right. How can I solve this problem? Thanks! Tag: Dynamic Sub-Reports Tag: 57716
  - 10
    - Error when sending report to PDF "A drawing error occurred". I receive this message when I export to pdf from RS2005. Note that I only have this issue on my reports that have a .jpg in them. "Thats an image"......... Any ideas.................... Tag: Dynamic Sub-Reports Tag: 57714
  - 11
    - Namespaces & UDF? Hello all; I am trying to write a query inside a UDF (Visual Studio 2003, SQL server 2000 reporting services) with the code below, and I am getting an error message that states "type sqlconnection is not defined" - so I have 2 questions: 1)How do I get these types to be recognized? 2)Perhaps more importantly, how can I make it so that my query uses the sql connection that the report already has established? You can see I am a novice at this...any assistance will be greatly appreciated - code is below: *********************************************************************************************************** Dim objConnection As SqlConnection Dim objCommand As SqlCommand Dim objAdapter As SqlDataAdapter Dim dataSearch As SqlDataReader Dim sqlstatement objConnection = New SqlConnection("Data Source=myservername;" _ & "Initial Catalog=databasename;User Id=username;Password=password;" _ & "Connect Timeout=15;Network Library=dbmssocn;") objConnection.Open sqlstatement = "select * from table ;" objCommand = New SqlCommand(sqlstatement, objConnection) dataSearch = objCommand.ExecuteReader() while dataSearch.read somevar = (datasearch("fieldname")) end while objConnection.Close() *********************************************************************************************************** Thanks, Eric. Tag: Dynamic Sub-Reports Tag: 57711
  - 12
    - Charts are not showing up when deploying hi all, I am using report services 2000, and my project works great in visual studio 2003 but when I deploy the solution my charts don't show up. has anyone gone through this before? thanks Tag: Dynamic Sub-Reports Tag: 57708
  - 13
    - Linking Two Reports by passing a parameter I have developed two reports A and B. From report A, I pass a parameter to report B which displays some data based on the value of that parameter. But when I try to run it, following error message is shown. "The 'DimOrganizationOrganizationName' parameter is missing a value" From http://www.developmentnow.com/g/115_2006_7_0_0_0/sql-server-reporting-services.ht Posted via DevelopmentNow.com Group http://www.developmentnow.com Tag: Dynamic Sub-Reports Tag: 57705
  - 14
    - WebUIValidation.js Have recently installed SQL Server 2000 Reporting Services on Windows 2003 SP1 server. When I try to open Report Manager via Programs menu, the console opens fine and then the error is displayed; "Unable to find script library WebUIValidation.js" Any thoughts ? Tag: Dynamic Sub-Reports Tag: 57704
  - 15
    - Rich Text - workaround or tool Hi all, I found the information that RS does not support the output of rich text fields: f.e. "this is my database field and I want THIS to be bold and THIS to be italic." http://groups.google.at/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/12aaa40be360f0c9/2bb64c99ccb37338?lnk=st&q=&rnum=1&hl=de#2bb64c99ccb37338 -------------------------------------------------------------------------------------------- Reporting Services currently does not support rich text. The best you can do at the moment is to write some code to convert the rich text to plain text. Support for rich text is a high priority for the next version (the version after SQL Server 2005.) -- Rajeev Karunakaran [MSFT] Microsoft SQL Server Reporting Services -------------------------------------------------------------------------------------------- Does anybody have a workaround or knows a tool for reporting services to render (simple) richt text or HTML formattings?? Thanks, Tony Tag: Dynamic Sub-Reports Tag: 57703
  - 16
    - RunningValue / RowNumber errors Hi, I hope someone can help me with this problem. I'm trying to create a running total using the RunningValue function in SQL reporting services 2005. the code is below: =RunningValue(Fields!company_id.Value, count, "CompanyID") Regardless of whether i include it in my report or if it is just created but not user i get an error. The error is one of the Send Don't Send microsoft ones which then proceeds to shut down Visual studio 2005. This happens whenever the report is previewed without fail. Has anyone encountered this before and if so could they shed some light on the problem. Many thanks in advance, Grant Tag: Dynamic Sub-Reports Tag: 57701
  - 17
    - The application for project is not installed (project types .rptproj and .dwproj) Hello On my PC I had Reporting Services 2003. After installing RS2005 I can't use RS2003. While I try to open any solution in RS2003 I get error meesage: "Make sure the application for the project type (.rptproj) is installed" Any ideas? Tag: Dynamic Sub-Reports Tag: 57700
  - 18
    - Working with space in Report manager Hi , I am struggling to appear a space between two fields .I do have expression like this Format((Fields!PERSON_ELASPED_TIME.Value\60),"#,###,###0") & ":" & Format((Fields!PERSON_ELASPED_TIME.Value) Mod 60,"00") & Space(4) & Fields!FLAG.Value ) It was supposed to display in format like this 34:50 * It was working Fine in Preview tab. but when i export it to Web(Report manger).it was showing 34:50* which was not correct Can any body pls help me in doing this Suggestions and sharing the Experiences are highly appreciated Thank you Raj Deep.A Tag: Dynamic Sub-Reports Tag: 57699
  - 19
    - PDF Fit to Page I have reports being accessed through report manager in the UK and USA. The reports were created to fit on an A4 page size which works fine in UK but because the standard paper size in USA is Letter the export to PDF is producing reports that are rendering to multiple pages. Is there anyway I can set the PDF to fit to page either in the report itself or in report manager? If this isn't possible can I create a custom renderer that inherits the standard PDF renderer but allows me to set the fit to page? Tag: Dynamic Sub-Reports Tag: 57696
  - 20
    - X-Axis width dependent on legend/label width Hi, We need to make sure all our charts are the same width on the X-Axis. Currently we have 2 charts: 1st with an X-Axis range of 0 - 10,000 2nd with an X-Axis range of 0 - 5 The width of the labels affects the X-Axis width of the actual data displayed. We want both charts to have the same width. The ranges given above were for example and can be any range. How do you work around this? TIA Glen Tag: Dynamic Sub-Reports Tag: 57695
  - 21
    - Reporting Servcies 2005, forms authentication hey all, I have a problem, I'm using a forms authentication for Reporting Services 2005, when I'm trying to programmaticaly step into the Server to get Model Policies using the statement "_rs.GetPolicies("/Models/Stores Model", out flag)" the following error occured "Object Moved to ReportServer/login.aspx". I know that I have to authenticate the user name and password using the custom security extension but how could i programmatically do that?. thanks a lot. Bob From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht Posted via DevelopmentNow.com Group http://www.developmentnow.com Tag: Dynamic Sub-Reports Tag: 57693
  - 22
    - Using Shared Variables in Group Footers Hi folks, Iâ??m relatively new to both SQL Reporting Services as well as .Net programming. I come from a Crystal Reports background and Iâ??m running into a problem duplicating a common technique used in my old Crystal reports. The simplified description of the problem Iâ??m having is thisâ?¦ it seems that public shared variables are evaluated in the wrong order when accessing them from code in grouped tables. It seems that the group header is evaluated first, then the group footer and finally all the detail rows. As a result, if I modify a shared variable in the details section of a grouped table, that modification isnâ??t recognized in the group footer. Here are the details of what Iâ??m trying to accomplishâ?¦ I have added a table to my report which consists of helpdesk ticket information. I've grouped the table by ticket number. For each ticket number, I need to evaluate an audit table to determine how much time the ticket spent in suspend status. To do this, I've added my audit table fields (Old_value, New_Value, Change_date) to the details of the table. So a typical grouping might look like this: Ticket Old_value New_Value Change_Date GH Detail 123456 Open Suspend 1/1/2006 12:00 Detail 123456 Suspend Open 1/2/2006 12:00 Detail 123456 Open Suspend 1/3/2006 1:00 Detail 123456 Suspend Open 1/3/2006 2:00 GF 123456 GH Detail 999999 Open Suspend 2/1/2006 12:00 Detail 999999 Suspend Open 2/2/2006 12:00 Detail 999999 Open Suspend 2/3/2006 1:00 Detail 999999 Suspend Open 2/3/2006 2:00 GF 999999 The total suspend time for each ticket should ultimately be 25hrs in this case. Iâ??m using a custom assembly in this report to do many of my business calculations (which are used in many different reports). In this assembly, Iâ??ve created the following public structure: Public Structure SuspInfo 'Public Members Public OldValue As String Public NewValue As String Public AuditType As String Public AuditDate As Date Public Overrides Function ToString() As String Return OldValue & " - " & NewValue & " - " & AuditType & " - " & AuditDate.ToString End Function End structure Iâ??ve also created the following collection class: Public Class SuspCollection Inherits Collections.CollectionBase 'Add Susp to the collection Public Sub Add(ByVal newSusp As SuspInfo) Me.List.Add(newSusp) End Sub Public Sub Remove(ByVal oldSusp As SuspInfo) Me.List.Remove(oldSusp) End Sub 'Item property to read or update a Suspinfo â??at a given position in the list Default Public Property Item(ByVal index As Integer) As SuspInfo Get Return Me.List.Item(index) End Get Set(ByVal value As SuspInfo) Me.List.Item(index) = value End Set End Property 'New implementation of the clear class Public Shadows Sub Clear() 'Clear the collection base MyBase.Clear() End Sub End Class In the detail row of the table, I call the following function: Public Function AddSuspInfo(ByVal OldValue As String, _ ByVal NewValue As String, ByVal auditdate As DateTime) If OldValue = "Suspended" Or NewValue = "Suspended" Then 'declare Suspinfo record Dim objNewSuspInfo As SuspInfo objNewSuspInfo.OldValue = OldValue objNewSuspInfo.NewValue = NewValue objNewSuspInfo.AuditDate = auditdate If OldValue = "Suspended" Then objNewSuspInfo.AuditType = "Unsuspended" Else objNewSuspInfo.AuditType = "Suspended" End If objSuspInfoArray.Add(objNewSuspInfo) Else Return Nothing End If Dim txtSuspArray As String = "" For Each susprecord As SuspInfo In objSuspInfoArray txtSuspArray = txtSuspArray & susprecord.ToString & vbCrLf Next Return txtSuspArray End Function The function not only builds the array of suspend info objects but it also displays the array in text form so I can see what is happening to the array in each detail row. Iâ??ve also included the following function to validate that the array is populated properly. Public Function showarraycount() Return objSuspInfoArray.Count End Function So, using the first ticket in the table above as a sample, the showarraycount function should return the number 4 in the group footer. If I call the function from the detail row, it increments the count correctly and ultimately, on the last detail row, the function returns 4. This shows that my code for defining and populating the collection is working correctly. However, if I call the function from the group footer, it returns 0 instead of 4. It appears that the objSuspInfoArray is being re-instantiated in the group footer eventhough Iâ??ve defined it as a public shared object. I thought that I may have overcomplicated things so I created the following simple function to be used as imbedded code within the report properties sheet. Public Shared intTest As Integer Public Shared Function AddIntTest() intTest = intTest+1 Return intTest End Function I then called that function in the group header, detail row, and group footer. I would have expected the function to increment the shared variable by one each time it was called regardless of where in the table it was called. Thatâ??s certainly not the result I got. For the first ticket number, the group header returned 1 which is what I expected. In the first detail row though the function returned 3!? It skipped 2 entirely. The remaining three detail rows incremented the variable as expected (4, 5, and 6). Then, in the group footer, the value went back to 2. In the next ticketâ??s group header the value went back to where the details of the first ticket left off and returned 7. The first detail row of the second ticket returned 9, 10, 11, and 12 (again, skipping 8). And finally, the group footer of the second ticket returned 8. So it looks like the report is evaluating the group header first, then the group footer, then the detail rows. Thatâ??s why the first detail row seems to skip a numberâ?¦ itâ??s because the report is evaluating the footer of the table before it evaluates the details. This seems extremely counterintuitive. So, how can I resolve this issue. I really need to set a shared variable in the details row and use that information in the footer. Itâ??s the only way I can think of to evaluate the total suspend time of a ticket. I had planned on populating an array in the details section then building a function to be used in the group footer which would loop through that array and add up all the suspend time. This clearly wonâ??t work if the report MUST evaluate the group footer before the details rows. Crystal reports has a feature called â??Whileprintingrecordsâ?? which lets you evaluate a function after all data has been queried and before displaying the results. Using the â??Whileprintingrecordsâ?? feature Iâ??m able to force Crystal reports to populate the array in the details secion BEFORE it uses that array in the group footers. Is there a similar capability in SSRS? Is there an alternative method Iâ??m not considering? Is this a bug or is it an intentional design plan? Iâ??ve search all over the web for any info on this an it appears that many people have similar isseus but Iâ??ve yet to find a suitable solution. Any help you could offer would be much appreciated. Tag: Dynamic Sub-Reports Tag: 57691
  - 23
    - Position of Point Labels in Pie Chart I have a pie chart. I would like to put the point lables outside of the pie chart. Is this possible? The current options are inside the pie. I am using SQL 2000 RS. Thanks. Tag: Dynamic Sub-Reports Tag: 57682
  - 24
    - Expand ALL Is it possible to "Expand ALL" levels of a summarized report? I have a report that has 3 levels of detail, with about 10 main items, a couple items under that and 4 or so items each under there, it gets tiresome real quick to click all the little pluses... When I export it to Excel 2000 there are three little boxes at the top of the expand columns (1,2,3) and I can click the level of detail I want to show by using these buttons... Really cool. Can that work in Report Services directly? -- Thanks, Bob Myles Tag: Dynamic Sub-Reports Tag: 57680
  - 25
    - Deploying and Managing We plan on using Report Builder as well as some of our power users use BIDS to create reports. What is commong practice to manage the reports - if I understand how it works - we will have this huge library of reports. We already have the slush shared drive where everyone creates folders and puts files on it willy-nilly - won't this become an issue with many folks creating reports? Yet we do want the useful reports to be in a shared area so ppl don't re-create useful reports - or they can build upon some already done. Maybe we just have an administrator where all reports get approved and placed in correct folders? Tag: Dynamic Sub-Reports Tag: 57679
- Next
  - 1
    - =?utf-8?B??= Tag: Dynamic Sub-Reports Tag: 57678
  - 2
    - CreateSubscription RunOnce Schedule? Is there a way to create a "RunOnce" schedule using the CreateSubscription web service API? It doesn't appear to me that there is a recurrence pattern that supports this type of mechanism... How can it be done? Tag: Dynamic Sub-Reports Tag: 57674
  - 3
    - Total field includes data from rows that were filtered I am having the same problem that Cyndi posted on 5/10/06. I have a group that has a filter on it. The group has a footer that has a Sum field. The sum field is summing all data for the group, not just the rows that are displaying. Has anyone come up with a solution for this problem? Is there anyway that I can get Microsoft to put this on their bug list? Tag: Dynamic Sub-Reports Tag: 57669
  - 4
    - error rendering report with PNG image to PDF I have a report that has an embedded PNG image. The report will render to any format fine but when exported to PDF the image is corrupted. Any ideas? Tag: Dynamic Sub-Reports Tag: 57668
  - 5
    - Security Troubleshooting? We just migrated from 2000 to 2005 on a new box. The migration documentation was wonderful for 2005 and it answered all of our questions. Our main reporting page should allow all users of a group to browse, but it no longer seems to accept the integrated security login for access. It ends up giving them the HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials error. What's the best place to start looking to fix this error? I've re-run the config tool and checked all teh security settings on the current pool and virtual directories but get the same errors on those users. Administrators of the box and domain can continue to use the site. very strange. Tag: Dynamic Sub-Reports Tag: 57665
  - 6
    - getting Error: Subreport could not be shown in report viewer Hi All, I am getting this error - "Error: Subreport could not be shown" only in the report viewer. Strangely, the first row in the parent report has the subreport shown correctly and all the subsequent rows have this error message. The report runs fine when I use the preview in Business Intelligence studio where I develop the report. The log file has this error logged in it: An error has occurred during report processing ---> System.ArgumentException: Item has already been added. Key in dictionary: '84' key being added: '84' Please help me solve this problem! It is taking all my time..... Thanks in advance Bharath Tag: Dynamic Sub-Reports Tag: 57658
  - 7
    - Reload Data Extensions Is there a way to force SSRS to reload my data extensions from the GAC when I install a new version of the extension without having to restart Reporting Services or making a "fake" change to rsreportserver.config file? -Jon Tag: Dynamic Sub-Reports Tag: 57657
  - 8
    - Rendering format options using url post method in reporting services 2005 Hi, I'm using the url post method to generate reports. I'm using the following form to generate the report in PDF format. Whenever I try to generate the report, I get it in HTML format. Am I missing something while setting the PDF rendering option? <HTML> <BODY> <FORM id="frmRender" action="http://servername/reportserver/Pages/ReportViewer.aspx?/SampleReports/Sales Order Detail" method="post" target="Main"> <INPUT type="hidden" name="rs:Command" value="Render"> <INPUT type="hidden" name="rc:LinkTarget" value="main"> <INPUT type="hidden" name="rs:Format" value="PDF"> <INPUT type="hidden" name="rc:Parameters" value="False"> <INPUT type="text" name="SalesOrderNumber" value="SO5414"> <INPUT type="submit" value="View Report"> </FORM> </BODY> </HTML> Thanks, Rohan Tag: Dynamic Sub-Reports Tag: 57655
  - 9
    - Fiscal Year? If I have Calendar Control on Asp.net page and I have a table for Fiscal years on sql server then, How can I check the dates from table to Calendar Control,so that I can format the Calendar control cells according to my need. I want to change the color of Dates according to fiscal month. i.e. As Calendar control has dates for Current + next + Previous months, I need to change the color of dates of month which is comes under Fiscal month. I have table for fiscal years, which has following : CREATE TABLE [AccountingCalendar] ( [AccountingCalendarID] [int] IDENTITY (1, 1) NOT NULL , [FiscalYear] [smallint] NOT NULL , [FiscalQuarter] [tinyint] NOT NULL , [FiscalMonth] [tinyint] NOT NULL , [MonthName] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [MonthStart] [smalldatetime] NOT NULL , [MonthEnd] [smalldatetime] NOT NULL , [CalendarYear] [smallint] NOT NULL , [CalendarQuarter] [tinyint] NOT NULL , [CalendarMonth] [tinyint] NOT NULL , [NoOfWeeks] [tinyint] NOT NULL , CONSTRAINT [pkAccountingCalendar] PRIMARY KEY CLUSTERED ( [AccountingCalendarID] ) WITH FILLFACTOR = 90 ON [PRIMARY] ) ON [PRIMARY] GO And data according to it. Now How can I check the dates from these table with Calendar Date and change the backgrond color for the month Started from MonthStart to MonthEnd field of table. Any suggestion or help will be appriciated. TIA Tag: Dynamic Sub-Reports Tag: 57650
  - 10
    - How to use YTD-Fields in reporting Services Hi, 1) I have an OLAP Cube with a accumulated Field (for example, for March, the values of Jan, Feb and March are accumulated). 2) For my Date-Dimension I have 4 groups in Reporting Services 2005 (Year, Semester, Quarter and Month) which are joined by the visability-Parameter of the group, so I can click on the + of the year and I see the semesters, klick on + at semester will bring the quarters and so on. 3) When I use this field in reporting Services and do the reporting on the last level (Month) all is OK. When I collaps to the quarter, the accumulated fields of Jan + Feb +March will be summed, and I get a total wrong result. How can I do it, that this fields are not be summed, and the accumulated value is right for all levels???? Thanks Hans Tag: Dynamic Sub-Reports Tag: 57649
  - 11
    - Handling nulls in matrix sub totals I have a matrix where I am using the inscope function to return different calculations depending on which group it is in (ie the detail is just the value and the sub totals are sum(values)). In for the subtotal group I have used: iif(isnothing(sum(Fields!CurrentCount.Value)), 0, sum(Fields!CurrentCount.Value) But this is still returning blanks where there are no values in the group to sum together. Can anyone suggest how to get around this issue as it ? TIA Andrew Tag: Dynamic Sub-Reports Tag: 57647
  - 12
    - is not one of. How do I write an expression using "not one of". I know how the sql syntax works but not the code in the report. Tag: Dynamic Sub-Reports Tag: 57646
  - 13
    - Zip file Is it possible that the reporting services will send a zipped excel file instead of just the excel file? Tag: Dynamic Sub-Reports Tag: 57643
  - 14
    - Matrix dataset filter out null I have a dataset which has a ContractNo column which can take a null value. I cannot carry out the filter on the stored procedure which generates my dataset. This dataset is used in a matrix. I need to filter out all rows with a null ContractNo. I thought I could do this on the matrix properties filter tab with an expression like: Fields!ContractNo.Value<>Nothing However there doeas not appear to be a <> (or not equal to) operator in the drop-down list in RS2000. How do I achieve this filter? What is the != operator? TIA, Mageno_man Tag: Dynamic Sub-Reports Tag: 57642
  - 15
    - Grouping/Totals - report builder I have created a group on year. How can I display totals for each year? It keeps giving me the grand total for all years. I need the totals broken down by year. -- K. Thomas Tag: Dynamic Sub-Reports Tag: 57641
  - 16
    - Configuring Report Services 2000 for more than one SMTP Server Is it possible to configure the Report Server Service for email delivery to two different SMTP server? Tag: Dynamic Sub-Reports Tag: 57640
  - 17
    - Report errors in Report Manager, works in BI Dev Studio I have a very simple report which runs off a SSAS cube and returns data fine when run through BI Dev studio. I deployed the report to my local server and when I click on the report in Report Manager I get the following error: Object reference not set to an instance of an object Tag: Dynamic Sub-Reports Tag: 57634
  - 18
    - Reading the URL from Internet Explorer Hi I am running some SQL reports through another web application. Is there a way i can get the report to read what the users currently has in their address bar as the address contains an ID number i need to run through a SQL script which will generate the report? The only thing i can think of is to have a ASP page in between that takes the current link and passes the required variable to the report but this seems messy and i don;t know how to do it. Thanks in advance Tag: Dynamic Sub-Reports Tag: 57632
  - 19
    - dataset in main report and subreport This is a multi-part message in MIME format. ------=_NextPart_000_0009_01C6B485.898E4410 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, We have a main report that calls a subreport. The subreport is being = passed the appropriate parameters. The subreport works correctly in isolation in the preview mode. However, = when it is called in a main report it stops working. I get the message "Error: Subreport could not be shown." The main report is NOT using a shared dataset, but subreport is.=20 Initially the main report was using a shared dataset and the subreport = was working correctly. However, since we need to create report columns on the fly (for ad-hoc = reports) so we have to generate the RDL at run-time and use = ReportExecutionService.LoadReportDefinition method to load RDLto report = server. This method requires RDL to use private data source/dataset. Am I required to do some kind of special handling for these kind of = subreports? Thanks ------=_NextPart_000_0009_01C6B485.898E4410 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.3790.1830" name=3DGENERATOR> <STYLE></STYLE> </HEAD><FONT face=3DArial><FONT size=3D2> <BODY> <DIV>Hi,</DIV> <DIV>We have a main report that calls a subreport. The subreport is = being passed=20 the appropriate parameters.<BR>The subreport works correctly in = isolation in the=20 preview mode. However, when it is called<BR>in a main report it stops = working. I=20 get the message<BR>"Error: Subreport could not be shown."<BR>The main = report is=20 NOT using a shared dataset, but subreport is. <BR>Initially the main = report was=20 using a shared dataset and the subreport was working correctly.</DIV> <DIV> </DIV> <DIV>However, since we need to create report columns on the fly (for = ad-hoc=20 reports) so we have to generate the RDL at run-time and use=20 ReportExecutionService.LoadReportDefinition method to load RDLto report = server.=20 This method requires RDL to use private data source/dataset.</DIV> <DIV><BR>Am I required to do some kind of special handling for these = kind of=20 subreports?</DIV> <DIV> </DIV> <DIV>Thanks<BR></DIV></BODY></HTML></FONT></FONT> ------=_NextPart_000_0009_01C6B485.898E4410-- Tag: Dynamic Sub-Reports Tag: 57625
  - 20
    - RS 2005 Parameter Syntax I've written a simple report to get familiar with RS 2005 syntax, etc. The report contains 2 parameters that are input in text boxes before the report is displayed. The select statement works correctly when executed in the query builder but does not display the report in the aspx page. Here is the select statement: SELECT LastName, FirstName, EmailAddress, Phone, ContactID FROM Person.Contact WHERE (LastName LIKE @LastName + '%') AND (Phone LIKE @Area + '%') Here is the aspx code: ReportViewer1.ShowReportBody = true; ReportViewer1.Visible = true; ReportViewer1.ProcessingMode = ProcessingMode.Local; strLastName = txtLastName.Text.ToString().Trim(); strArea = txtArea.Text.ToString().Trim(); ReportParameter[] param = new ReportParameter[2]; param[0] = new ReportParameter("LastName", strLastName, false); param[1] = new ReportParameter("Area", strArea, false); ReportViewer1.LocalReport.SetParameters(param); ReportViewer1.LocalReport.Refresh(); Why is the report not being displayed when it seems the select statement is OK in the query builder? Thanks, John Tag: Dynamic Sub-Reports Tag: 57624
  - 21
    - Reports - IE7? Are there some major issues with the reports and IE7? One of our systems which is attempting to access the reports via LAN is having the following problems. The system is running IE7 Beta 3 on WinXPPro SP2. 1) When opening report builder the progress window appears showing the download of the application but the report builder never displays. No errors, nothing! 2) When clicking on a report the report shows correctly but IE7 seems to be doing something still, the icon on the tab keep flickering and most navigation has a minute or two delay. There is also an '!' in the icon on the status bar but where you can normally click on the icon to view it never displays. 3) The date select buttons and drop down list from the parameters and export selection don't work at all. Regards, John Tag: Dynamic Sub-Reports Tag: 57623
  - 22
    - Lookup column / combining two datasets I need to display a values from the another dataset. E.g. I have a SQL database with employees details and that is dataset 1; but employees salaries are stored in Excel spreadsheet and that is dataset 2. The question is how can I display a list of employees along with their slaries? Thanks Jacek Tag: Dynamic Sub-Reports Tag: 57621
  - 23
    - Want space and special characters in CSV header I'm exporting a report with table to CSV but the user wants the CSV header to include space and special characters, exactly as seen on the report. I've tried to rename the textbox to the name of the header, but obviously the names can't include any spaces. Enabling the output of table header has no luck either, as the header row will render as separate columns, making the CSV twice as wide. What I need is, simply: "Some price (USD)", "some price (GBP)", "column 3" 100, 180, "some data" Any ideas? Tag: Dynamic Sub-Reports Tag: 57613
  - 24
    - customizing WebForms.ReportViewer control look I am working on implementing a reporting module based on ssrs 2005, and after my research with ssrs 05 i have a few issue that i am not able to resolve. I am ussing the WebForms.ReportViewer control in remote server mode. i am trying to customize the look and feel of the toolbar, to a more extent then just which buttons to show and which don't. I found out several places on the web discussing how this can be achived by changing the HtmlViewer.css class under the ReportServer\Styles folder, and this method does work bu only when using the URL method for accessing ssrs (http://localhost/reportserver/). This method seems not to work when embeding the reportviewer control on an aspx page. When checking the generate html source code, it seems that there is a difference between how the report is generated when using URL access and when using the reportviewer control. In URL access, there is a use of classes for the different, while withthe control usage only the style is directly embeded. for example: direct URL access: <td class="ParamLabelCell"><span>begin_date</span></td> embeded control: <td style="padding:5px;vertical-align:baseline;"><span style="font-family:Verdana;font-size:8pt;">begin_date</span></td> The same report is rendered differently, thus i cannot use a css with the class names to configure the look and feel. thanks, gerald Tag: Dynamic Sub-Reports Tag: 57612
  - 25
    - add totals to a matrix Hi, I've defined a matrix in a report which looks like this: group by column group by column Description Data Data Description Data Data Now I'd like to add a colum which sums up the Data: group by column group by column Total Description Data1 Data2 sum(Data1+Data2) Description Data3 Data4 sum(Data1+Data2) The only thing which I found is to add subtotals but this only counts my first group by column. How can I add a total column? Thanks Tag: Dynamic Sub-Reports Tag: 57610

Is it possible to change the report that is displayed in a subreport?

What I would like to do:

Display to the user a list in a report. They select from the list:

ItemA @key1 @key2 ReportA
ItemB @Key1 ReportB

The report item from the list is then displayed in the subreport area. There
may be a number of different reports with varying parameters. Can this be
done? How would I specify the scripting to change the report and parameters
that are passed?

Top