pbroblem subreport with groping

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
    - Access a report from the Internet with no authentication Is it possible to access a report from the Internet (in a non Windows Domain context) without supplying any credentials. For instance, a user types in this URL: http://www.mydomain.com/ReportServer/Pages/ReportViewer.aspx?%2fMyFolder2%2fMyReport and he/she woulnd not be prompted by a login dialog, and could simply view the report. I tried all sorts of different things (stored credentials in the datasource, impersonating a user, etc.) from both BIDS and Report Manager, but I can't seem to make it work. BTW, I can read the report just fine if I supply a user name and password. Thank you, -- Alain Quesnel alainsansspam@logiquel.com www.logiquel.com Tag: pbroblem subreport with groping Tag: 76318
  - 2
    - No print button in Firefox 2 Is it me, or is there no print button on the SSRS toolbar in Firefox 2? Thank you, -- Alain Quesnel alainsansspam@logiquel.com www.logiquel.com Tag: pbroblem subreport with groping Tag: 76310
  - 3
    - how to do grouping how to get report like this, I am using RS2005 From Query I am getting following data Name,Catageory,ItemcODE,ItemQty A CAT1 1 1 A CAT1 2 20 A CAT1 3 15 A CAT1 4 2 A CAT1 5 11 B CAT2 1 18 B CAT2 2 20 B CAT2 3 22 C CAT3 1 0 C CAT3 2 32 For above dataset I want to have report like this Name : A Catagoery : CAT1 Item Qty 1 1 2 20 and so on Name : B Catagoery : CAT2 Item Qty 1 18 2 20 and so on Name : C Catagoery : CAT3 Item Qty 1 0 2 32 and so on i am new to reporting server 2005, On table, I inserted a Group on Categoery and again another group on Items i am getting only one row for each Item, where i am doing mistake or Is there anyway to todo, thanks ka Tag: pbroblem subreport with groping Tag: 76307
  - 4
    - Time-phasing results I am very much a newbie to SRS. I'm using SRS2005 to build a Cash Requirements report where the required date on PO Lines is used to drop the dollar value of the line into weekly buckets. My challenge is in trying to build the time-phasing into the row. I don't know how to build the logic into the results row to place the results into weekly buckets. Any help is greatly appreciated. Frank Hamelly MCP-GP, MCT East Coast Dynamics www.eastcoast-dynamics.com Tag: pbroblem subreport with groping Tag: 76304
  - 5
    - Reporting Services Configuration Manager I'm trying to install SCE2007 but have run into the following problem. I've installed SQL 2005 Express with Advanced Services on a W2k3 x64 SP2 machine. In configuring Reporting Services everything looks good except the Web Services Identity status is a red X. I'm getting the message "object reference not set to an instance of an object" when I click on the red X. I'm using Local Service for all service accounts including the App Pool in IIS 7. I've been through all th eonline help and forum posts I can find but haven't been able to resolve the issue. All help appreciated. Tag: pbroblem subreport with groping Tag: 76303
  - 6
    - Rendering in CSV. Hi, Im trying to render a report in csv but I want it to have the fielddelimiter are tab instead of comma so I tried to set the device attribute in the url as below http://localhost/reportserver?/ReportProjectTest/Departments&rs:Command=Render&rs:Format=CSV&rc:FieldDelimiter="%09" but this is the result I get DepartmentID""CompanyID""DepartmentName""DepartmentHeadID 1""1""Marketing""1 2""1""Accounting""3 3""1""Customer Support""2 4""2""Sales""4 5""2""IT""5 Am I missing something? Thanks. Tag: pbroblem subreport with groping Tag: 76302
  - 7
    - Optional params in DLL? I have a vb.net dll that contains a function with 4 parameters. I recently modified this function, adding 2 Optional params. After re-deploying the dll, I deployed a report that calls the function, both with and without the optional params. It works fine on both. However, all of the other reports that were already deployed are failing to return anything from this function. I redeployed a couple of the reports, and redeploying seems to have fixed one of them but not the other one. Do Optional params mess up SRS reports? Or do the reports all need to be redeployed after adding the optional params? Or does this sound like some other issue entirely? Tag: pbroblem subreport with groping Tag: 76301
  - 8
    - two dataset one chart Hi, I have a chart where I need to display values from two different data sets. I created a parameter that stores the value I need from one of the datasets. I created a field in the dataset that I am using and set the value to the parameter. Here is my challenge: When I display the field that contains the parameter on my report as a textbox, the value associated with the parameter displays as expected. When I add the field to the chart as a data series, the value does not display. Any help is greatly appreciated. Thank you for your time and assistance. Donna Tag: pbroblem subreport with groping Tag: 76297
  - 9
    - Exporting to Excel Hello Everyone, I'm using SSRS 2005 on top of a sql2k database. When exporting a report from the Report manager web interface into Excel, the report gets formatted with the cells merged. This causes a problem with sorting colums since Excel does not like to sort data in merged cells. I could have my users simply unmerge all cells, but that leaves some emply colums that have to be deleted. Is there any way to prevent the cells from being merged after exporting from the Report manager? I create the reports in Visual Studio 2005, is there some setting I can change while creating them in VS05 that will prevent this? Thanks. Tag: pbroblem subreport with groping Tag: 76295
  - 10
    - Print Preview Problems Hi all, Using the SQL reporting services 2005 report manager, our client can access the report published. In the report manager (using IE & type http://reportserver/reports), there's print button & when you push the button it will show print dialog form. The problem is : 1. the printer preference will always using "Letter" papersize. If i change the papersize, then I close the print dialog form, then I push the print button again, it will still "Letter" papersize. I design this report using "A4" papersize. It will very annoying if I'll have to set the papersize whenever I print the report. 2. The print preview will always show in "Letter" papersize. Though I have changed the papersize, the print preview will always show in "Letter" Is this a bug, or am i missing something? Any help will be greatly appreciated. Thx & sorry for my English Tag: pbroblem subreport with groping Tag: 76293
  - 11
    - Printing with SSRS There are a few options listed in the following thread regarding printing with SSRS. http://expertcodeadvice.com/index.php?topic=15.0 I am trying to determine if there is a way to speed up the web service call to rendering a report. Does anyone have ideas on what the best way to print a report faster than 5-10 seconds per page is? Tag: pbroblem subreport with groping Tag: 76273
  - 12
    - Call or Reference a Stored Procedure from a published report Hi All, Got a report published that uses a stored procedure which is on a different server in our Domain. I have the correct connection string info entered via the Report Manager / Data Sources tab, but how and where does one reference the SP to execute it? The SP does work in BIDS. Thanx, ~SD Tag: pbroblem subreport with groping Tag: 76265
  - 13
    - List grouping I am needed assistance with getting multiple datasets data in one LIST. I have 1 parent table with 2 child tables. The parent table contains the primary key for the 2 child tables. This is a 1 to many relationship to both the child tables where 1 child table could have 5 records and the other could have 15. I need data from the parent as well. I am having a hard time getting this data grouped on the ID when trying to nest a list inside a list. It does not seem to work. Any suggestions? -- <moojjoo/> Tag: pbroblem subreport with groping Tag: 76256
  - 14
    - one parameter for two datasets I'm using two datasets to populate two different tables in a report. Each dataset populates it's own table. They do not need to be linked and a sub report is not needed for this particular use. I placed an identically named parameter in both datasets (in this case â??@Dateâ??). When previewing the report, it forces two date parameters to be populated. The second one that is created is has named itself as â??Date_1â??. When I remove It I'm getting an error of course. Is it not possible to use on parameter for two different datasets? -- Marty Cline Tag: pbroblem subreport with groping Tag: 76255
  - 15
    - Can not access Report Manager administration options Recently installed SQL Server 2005 Express with Reporting Services in a W2K3 server. The installation was performed using Remote Desktop Connection to the server, with a domain account in the Administrators group. Initially, the Reporing Services service failed to start, but I could solve this with references to your forum: http://www.developmentnow.com/g/115_2004_10_0_0_452194/Report-Services-did-not-install-properly-on-w2k-and-w2k3-Can-anyone-help.htm After the service could start and completed the Reporting Services Configuration, I can access the Report Manager Home page, but only with HOME and HELP links, no options for the administration of the application. Please help !! 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: pbroblem subreport with groping Tag: 76250
  - 16
    - error - Cannot create a connection to data source Hello. I have installed reporting Services on a serevr and have a MS SQL DB on a different server.I am using a domain id to coneect to db server which have required access on database.Both the server are in same domain. also I have configured a seperate application pool in IIS for /reportmanager which is runnig under same domain ID which i used for reporting service . I have created a connection which is shared by all reports. Now problem is while browsing report i am getting error - "Cannot create a connection to data source 'dbSPSReportingSample'. (rsErrorOpeningConnection) SQL Server does not exist or access denied." I am able to test connectivity to Db server using ODBC connection manager succesfully. Error in logfile says -- w3wp!processing!16a4!29/11/2007-14:43:59:: e ERROR: Data source 'dbSPSReportingSample': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'dbSPSReportingSample'. ---> System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. Please advice Thanks . Tag: pbroblem subreport with groping Tag: 76249
  - 17
    - LoadSnapshot Failure Here's what I have: Windows 2003 R2 x64 SP2 MS SqlServer 2005 SP2 (9.00.3054.00) Reporting Services (9.00.3054.00) Using a web browser, I couldn't connect to the reports. I could select them and get to the point of viewing, but I'd always get the: Execution 'hstdtl55jvaxbs55rlyc2yby' cannot be found Looking in the logs I saw: w3wp!session!1!11/28/2007-16:44:37:: i INFO: LoadSnapshot: Item with session: hstdtl55jvaxbs55rlyc2yby, reportPath: /ReportTry/Report1, userName: NT AUTHORITY\NETWORK SERVICE not found in the database w3wp!library!1!11/28/2007-16:44:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'hstdtl55jvaxbs55rlyc2yby' cannot be found, ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'hstdtl55jvaxbs55rlyc2yby' cannot be found w3wp!webserver!1!11/28/2007-16:44:37:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'hstdtl55jvaxbs55rlyc2yby' cannot be found The ReportServer side worked fine. I could view and export reports fine there. It was when I went to http://hostname/reports that I got that error. I stumbled across the "Local Impersonation" settings in the report virtual directory ASP.NET configuration. It was checked, but no username/password was there. I unchecked this and everything works fine now. My question is, since this is an internal report server not used on our public side, is there a problem with turning this off? When would I want it on, and what username/password should go in there? I tried several username/password combinations and I got the Execution 'sessionid' cannot be found error for each. Thanks, Doug Tag: pbroblem subreport with groping Tag: 76246
  - 18
    - Any way to pop up an alert if users drillthrough to a report with too Good morning all, I want to somehow warn our users if they try to drillthrough when one of the dimensions is near the top of the hierarchy. In the best case scenario, I would love a confirm("You are attempting to go to a detail report at a very high level of the hierarchy. Are you sure you want to continue?") Is there any way to do that? I am using the Jump to Report option on the Navigation tab of the Properties box. Thanks, Kathryn Tag: pbroblem subreport with groping Tag: 76245
  - 19
    - Detecting the render method using an expression Is there a way of detecting (in an expression in the report) the render method that is being used to render the report? Scenario I have created a custom assembly that sits in the footer of a report and writes the total number of pages to a database table. However, the total number of pages varies depending on the render method used, and I need to capture this render method along with the total pages. I can't pass the render method into the report as a parameter because, even when rendering with a single render format such as PDF the report seems to render twice: string format = "PDF"; results = viewer.ServerReport.Render(format, deviceInfo, out mimeType, out encoding, out fileNameExtension, out streamIDs, out warnings); The above code inserts two records into the database table (once as either XML or HTML and then as PDF). The first record reflects the total pages displayed in the viewer, and the second record reflects totalPages as if exported into PDF. If we could detect which format was being used at render time then we could get around this double rendering problem. Tag: pbroblem subreport with groping Tag: 76244
  - 20
    - Internet Explorer y Reporting Server Buenas noches... tengo un problema con internet explorer y reporting server. Estoy abriendo el report viewer en otra ventana diferente a la de mi web app, cuando abro el primero funciona bien, pero al momento de abrir el segundo reporte el internet explorer ya no lo abre.. . no se si logro explicar cuál es mi problema... abro un reporte y luego intento abrir un segundo y no lo abre. Alguien sabe que puede estar pasando? Saludos Tag: pbroblem subreport with groping Tag: 76240
  - 21
    - Subreport page overflow Hello, I have a subreport that consists of a header, text boxes, and a table beneath that I'm exporting it to create a pdf. The report shows fine in the report designer, however when I export it to create a pdf and there's alot of rows in my table, the text boxes will not repeat on the next page. The header shows along with the remaining rows from the table. Is there a way for me to have my text boxes show on page overflow. Thanks for any help you give. Best regards Tag: pbroblem subreport with groping Tag: 76233
  - 22
    - DataSource for Exchange I found some reports for exchanges. Now I need to create a Datasource. Does anyone know how to find the exchange server name? exchange login name? exchange login password? once I have a working datasource These reports should work. Scott Burke Tag: pbroblem subreport with groping Tag: 76231
  - 23
    - SRS "Find" with "Header should remain visible while scrolling" ena When I have the table property "Header should remain visible while scrolling" enabled and use the find in SRS, the found line ends up hidden under the scrolling table header. Is there some sort of work around for this bug? Thanks! Marcus Tag: pbroblem subreport with groping Tag: 76228
  - 24
    - Customise Report Manager Hello We have Reporting Services 2005 and was wondering if it is possible to customise Report Manager interface and possibly add a company logo and maybe status messages of when the databse was last refreshed? Kind regards Ricky (SS2005/SSRS2005) Tag: pbroblem subreport with groping Tag: 76225
  - 25
    - RepeatWith in SSRS I have a text box which is set to repeat with a list. When I use Preview or when Deployed, the RepeatWith does not work and the text box only apears on the first page. Im new to SSRS and it's probabley something realy simple, but I have not been able to find the answer anywhere. Thanks in advance Joe Tag: pbroblem subreport with groping Tag: 76224
- Next
  - 1
    - RSClientPrint ActiveX causes client PC to reboot We have a client PC trying to run a report. When they hit the print button it first asks them to install a SQL active X control which is RSClientPrint Class. Once installed they hit the print button on the report which then loads the active X print dialog - when they hit print their system reboots. I had this person delete the control and go through the same process with the same results; they are running Windows XP SP2 with IE6. Any ideas? Thank You. Tag: pbroblem subreport with groping Tag: 76219
  - 2
    - ssrs chart dotted points Hi, The chart is set to simple line I can not get my SSRS chart to show just the dots, instead it is joining the points together and show the points joining together and therefor appear as lines.. even tried setting the chart to simple scatter but then nothing appears on graph. Any thoughts please? Tag: pbroblem subreport with groping Tag: 76218
  - 3
    - Reports Break I have found I have a problem with my reporting Services 2005 that I am not sure I understand. I Have reports in development and they are about to go live, so when I am working on other things they may not be getting requested for a week or two. But what happens is when I try to run the reports they give all these bizarre error messages. If I then go back into the Project where I created the reports and redeploy them it fixes the problem. Does anyone have any ideas why I have this problem and how I might go about troubleshooting it? Tag: pbroblem subreport with groping Tag: 76215
  - 4
    - <Select all> disappear on server Hello. I have a parameter with multi value option. When I run the report in Visual studio, The first value in the drop down of this parameter is (Select All). When I check this option it check all the other values for this parameter and when I unCheck this value it uncheck all the ther values for this parameter. The problem is thet when I'm publishing the report to the server and then open it in IE the (Select All) value does't appear and I only get all the other values. Any body know how to fix this? Thanks. Tag: pbroblem subreport with groping Tag: 76210
  - 5
    - Error when browsing the page http://localhost/reports I have installed SQL Server Reporting service 2005 and when I am trying to browse the page http://localhost/reports, it is giving me following error: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.IO.FileNotFoundException: C:\WINDOWS\assembly\GAC_32\Microsoft.ReportingServices.Diagnostics\9.0.242.0__89845dcd8080cc91\ReportingServicesNativeServer.dll at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at Microsoft.ReportingServices.Diagnostics.RSConfiguration.GetNativeProductVersion() at Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_NativeServerProductVersion() at Microsoft.ReportingServices.WebServer.ReportingService2005.ServerInfoHeader..ctor() at Microsoft.ReportingServices.WebServer.ReportingService2005.get_ServerInfoHeaderValue() --- End of inner exception stack trace --- SQL Server 2005 is installed on different machine. I am installing SQL Server Reporting service 2005 on CRM server. I have install/uninstall for a number of times. Previously, it was working properly and after some installaion/uninstallation, it has started giving the above error. Tag: pbroblem subreport with groping Tag: 76209
  - 6
    - Samples not installed I recently installed sql server 2005 on win 2003 server. The Samples folder within the C:\Program Files\Microsoft SQL Server\90 was never created. Because of this I can't install the Sample Reports, etc. How do I install it? Thanks in advance. Tag: pbroblem subreport with groping Tag: 76202
  - 7
    - Print to a DYMO Labelwriter 400 turbo Has any one tried to print to a DYMO labelwriter 400 Turbo printer. I am having a hell of a time trying to make it work. Scott Burke Tag: pbroblem subreport with groping Tag: 76201
  - 8
    - Change font size w/ expression? Hi I have a chart whose title I would like to format w different font sizes. The chart title is: <caption>="This is the chart main text" + vbcrlf + First(Fields!subtitle.Value, "Text")</caption> The main chart title is hard coded and the second line is a field. I would like to change the font size on that second line. Is there a way to reference the <caption> line in <style><fontsize> and parse through it? I'm thinking this isn't possible, but why not ask. Thanks! Marcus Tag: pbroblem subreport with groping Tag: 76200
  - 9
    - Exchange Reports I found a set of reports on Microsoft's web site. SqlReportsPachExchange.MSI However it gives an error when I try to install it. Does anyone know of a newer version? Scott Burke Tag: pbroblem subreport with groping Tag: 76199
  - 10
    - Jump To Report Subscription Problem I'm having an issue when using Jump To Report. I am not sure if it's because of all the parameters I have but here goes. I have a master report linking to a child report. I have serveral parameters I'm passing to the child which works fine in the report viewer. But when I subscribe to the master report via email and select web archive as my rendering format, I get the master report with links that have an "amp;" in the url which breaks the link. Anyone know how to solve it? Tag: pbroblem subreport with groping Tag: 76197
  - 11
    - snaking columns My report body has 4 columns. I created a table in the body grouped on a field. The data groups and snakes accross the fields correctly. My problem is that part of a group will snake to the second column. Is there a way to manage this. I would like to have two groups of data per column. After the second group is there a way to force the next group to the next column? Thanks. Tag: pbroblem subreport with groping Tag: 76196
  - 12
    - Reports work fine on one server but on another i get "Index out of range Param.. Reports work fine on one server but on another i get "Index out of range Parameter name: count" HELP I have a web application that produces SQL 2000 reports in the RS 2000 RDL format. Which are then dynamically deployed to the report server then renedered from withni the app using the SQL 2000 RS web service I run and tested it against a SQL 2005 environment and it works fine. Now the Network Admin moved the app to another server under SQL 2000 and when the user hits OK and the report starts to execute but then i get this error message for all the reports which all of a sudden dont work "Index was out of range. Must be nonnegative and less than the size of the collection. Parameter Name: Count" which is bizarre because the reports dont have parameters i have a stored procedure that is executed within the <QUERY> tags which is what the reports run off of. -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200711/1 Tag: pbroblem subreport with groping Tag: 76194
  - 13
    - Lock Report Header I know this question was asked back in 2004 and haven't seen any updates on it.... Is it possible to lock the report column headers - as in Excel - so as you scroll, you'll always see the column title/header? Thanks!! Tag: pbroblem subreport with groping Tag: 76193
  - 14
    - SSRS 2005, Subscription Email addressing is greyed-out I have SSRS 2005 installed. User wants to change email address on subscription to send to external customer or others in our organization. If I modify right "Manage individual subscriptions" to enabled for his security profile, the email address box is greyed-out. I tried changing value <SendEmailToUserAlias>xxxx</ SendEmailToUserAlias> to FALSE in rsreportserver.config, with SSRS restart, but address box is greyed-out. If I modify right "Manage all subscriptions" enabled for his security profile, the address box is not greyed-out, but can now see-edit everyone's subscriptions for that report. How can I turn on address box is not greyed-out, but not open view of ALL subscriptions to my users? Tag: pbroblem subreport with groping Tag: 76192
  - 15
    - visibility of toggleitems I had a hard time finding any posts on toggle items so I am posting an article that helped explain toggle item and visibility issues. http://www.mssqltips.com/tip.asp?tip=1329 Bill Tag: pbroblem subreport with groping Tag: 76189
  - 16
    - How to enable Email delivery for Subscriptions Hello, Grateful if someone tell me the steps that needs to be carried out for enabling the Email delivery "Report Server Email" option when creating a new report subscription. Currently, I do not see this option except Printer delivery and File delivery. Thanks, Kaushik Tag: pbroblem subreport with groping Tag: 76183
  - 17
    - Identify when "Select All" is chosen in a multi value parameter. When a user chooses "Select All" from a multi value drop down list is it possible to identify that "Select All" has been chosen and then dispaly "All Selected" in a textbox? Currently I'm using join(Parameters!ParamName.Label,", ") to populate a textbox, but it's a mess when "Select All" is used as all the parameters items are joined. It would be much neater if I could simply return "All Selected". Cheers PS There's probably a way of using Parameter!ParamName.Count to do this, but I thought I'd ask you guys before I wreck my head. Tag: pbroblem subreport with groping Tag: 76181
  - 18
    - Table Cell Background colors more then two choices I am in the process of building a heat map "green", "yellow", and "red". Based on a value either H, M, L I need to change the color of the cell. I have seen the IIF but that only allows two colors. Any help would be great. -- <moojjoo/> Tag: pbroblem subreport with groping Tag: 76180
  - 19
    - Matrix Report and its column aggregates hello everyone, We have the following scenario, and are struggling to get an efficient way of doing this... We have a matrix report that looks something like this _______________________ | | Column Header | ---------------------------------------- | | Sub Col1 |Sub Col2| ---------------------------------------- | Date | Value Value | ----------------------------------------- We have to evaluate a number of additional attributes - like mean, std Deviation,max value, min value, etc for each of the columns (the total sub columns can vary between 1 and 9). this additional info has to be shown in a seperate table/matrix - |Statistics |Sub Col1|Sub Col2| ------------------------------------------------ |Mean | 1.5 | 2.5 | ------------------------------------------------ |S.Deviation | 0.5 | 1.5 | ------------------------------------------------ |Max Value | 3.5 | 4.5 | ------------------------------------------------ i know that aggregate functions are available to get this info, i am just not sure how i can show this in the second matrix. Also i want to avoid calling the stored proc twice as this might slow down the report (the number of rows can be around 5000). Any suggestion that would lead to an optimum solution will be swell... Tag: pbroblem subreport with groping Tag: 76179
  - 20
    - Calling web service onclick of report column We have a web service that reads a PDF file into binary and inserts the binary text in a database, then returns an ID to the record. Is there a way to call this web service from a Reporting Service Report column? The column will have an Adobe image in the column and when clicked with call the web service and read the record from the Database streaming the binary to a browser window. Thanks in advance! Rick Tag: pbroblem subreport with groping Tag: 76178
  - 21
    - Reportservertempdb cleaning Hi, my reportservertempdb is about 12 GB. I can see that the chunkdata table is the biggest one. Is there any tool/policy cleaning and deleting older data of reportservertempdb? What impact should expect if I delete rows at chunkdata table? TIA, Roberto. Tag: pbroblem subreport with groping Tag: 76177
  - 22
    - View Report! Hi every body! I have a problem with view report,when i show my report and i want to preview my report i have this problem: i have three pages in my report and when my user is in second page and wants to preview second page ,i can't becuse reporting services gives me preview of first page or when i want to find something in second page it's found in first page! I've used from object ViewReport to show my report. Are there any setting for the report? Tag: pbroblem subreport with groping Tag: 76174
  - 23
    - PolygonsCustomReportItem Hi, Is it possible to modify the width of the Report item in the CRI? i.e: public ChangeType Process() { this.m_CustomReportItem.Width = 0.5; .... } It doesn't seem to work, if anyone can help me. Thank you, Tag: pbroblem subreport with groping Tag: 76173
  - 24
    - Viwe Report! Hi every body! I have a problem with view report,when i show my report and i want to preview my report i have this problem: i have three pages in my report and when my user is in second page and wants to preview second page ,i can't becuse reporting services gives me preview of first page or when i want to find something in second page it's found in first page! Are there any setting for the report? Tag: pbroblem subreport with groping Tag: 76172
  - 25
    - report from two facts How to create a report from two facts and the facts have a common dimension? Thanks & Regards Venkat Tag: pbroblem subreport with groping Tag: 76170

hi : i was created report grouping py severity and i was created subreport to details
but problem after privew report show duplicat details in evrey grouping
same this
"Medume"
123
456
789
"low"
123
456
789
thanx.

From http://www.developmentnow.com/g/115_2006_11_0_30_0/sql-server-reporting-services.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Top

Re: pbroblem subreport with groping by EMartinez

EMartinez
Sun Dec 02 10:10:10 PST 2007

On Dec 2, 1:16 am, mansor<magot...@stc.com.sa> wrote:
> hi : i was created report grouping py severity and i was created subreport to details
> but problem after privew report show duplicat details in evrey grouping
> same this
> "Medume"
> 123
> 456
> 789
> "low"
> 123
> 456
> 789
> thanx..
>
> Fromhttp://www.developmentnow.com/g/115_2006_11_0_30_0/sql-server-reporti...
>
> Posted via DevelopmentNow.com Groupshttp://www.developmentnow.com

Normally filtering out duplicates in subreport functionality is not
very feasible in this situation. I would suggest using a single report
with a table control grouping on severity (where applicable). Also, if
you are using a table control, I would suggest right-clicking the
field that has the duplicates in it and select 'Properties.' Then near
the bottom of the 'General' tab, select 'Hide duplicates' and then
below 'Containing group or dataset:' select the severity group. Hope
this helps.

Regards,

Enrique Martinez
Sr. Software Consultant

Top