I'm developing a SSRS site using SQL Server 2000 and Visual Studio 2003. The target device is a Nokia 770 Internet tablet over a wireless network using VPN for authentication (corporate requirement). The 770 currently has a problem resolving server names to a fully-qualified URL. It's been...more >>

I'm developing a report site that will be accessed by mobile devices (mainly a Nokia 770 Internet tablet). The site works fine up to the point that the user selects a report or chart to view, then stops. The problem stems from the mobile device being unable (for whatever reason) to resolve s...more >>

Hello, I have been attempting to set up a report using the ReportViewer control in VS2005. The report graphs the TOP X number of records based on certain criteria. Naturally, I modified the report with a filter for the TOP N results. This works, however, in the case of ties on the last ent...more >>

I am trying to have lay 3 report parameters in one single row and have teh next line have just one. In other words, I want to control the layout of these parameters. How can I do that? I am using Sql Server 2000 Reporting Services. Also, I wanted to create a checkbox type report parameter. ...more >>

When creating a filter with Report Model against my cube (or perhaps any source) - it seems to force me to free form type how the filter will work. For example - Attribute: Does_Client_Smoke Values: Yes, No, N/A, Won't Answer, Cannot Answer When I create the filter it makes me type in on...more >>

SSRS 2005 I am rendering reports in an ASP.NET app using the Report Viewer Control. I have data values (text boxes) in the reports which are links that allow the user to drill down/through to other reports. Ideally I would like these data values to appear normally (black text) when rend...more >>

SSRS 2005 I have set the width of the Report Viewer Control in my page like this: <rsweb:ReportViewer ... Width="100%" ... </rsweb:ReportViewer> Which does what I want...it resizes the width of the control as the page (browser) is made wider. However I noticed that on a high resolution disp...more >>

SSRS 2005 I have an ASP.NET app using the Report Viewer control. I would like the Report Viewer control to resize as the browser (web page) is resized. Setting <rsweb:ReportViewer ... Width="100%" ... </rsweb:ReportViewer> controls the width as expected. As the page is made wider, the c...more >>

Hi I'm not sure if this is possible, but hoping that someone out there can give some guidance. I'm using a reporting services ReportViewer object to view reports via an ASP.NET application. I've just upgraded to SP2 to make use of the print functionality. However a requirement i have is ...more >>

Thanks in advance for any assistance. Is there a way to force an explict # of rows for a table? For instance, if I only have 3 rows of data, I need to force 6 rows to be rendered, with no data in the remaining 3 rows. Thanks, Morgan ...more >>

Hi all, Is it possible to group parameters fields into logical groups in report view? eg. filters: start date: end date: colors: table border: chart background: .... TIA, Kamel ...more >>

Layout problem - I've created a report with the wizard and it looks fine. It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table. Whan I run ut it look fine (In the first page there is the header and under...more >>

Layout problem - I've created a report with the wizard and it looks fine. It have a TITLE, a few SUB TITLES (all are textbox with values) and a textbox with JUMP TO link that use as a back button. beneath is a table. Whan I run ut it look fine (In the first page there is the header and undernea...more >>

Hi People, I have set up a new Windows 2003 Server and installed SQL 2005 with Reporting Services. I had to turn on IIS to do this. How can I make my new server publish reports to a different IIS server, one that doesn't have SQL installed on it? Thanks. ...more >>

I want to use data-driven subscriptions but cannot create one - the "New data-driven subscription" button does not appear in Report manager. I believe this may be because I'm running SQLRS Standard - can someone confirm this please? If true, is there an easy way to upgrade to SQLRS Enterpr...more >>

Can you have a report parameter to list the data, if you already have the data grouped in the layout tab? ...more >>

In crystal reports you can just preview reports quickly can you do this anyway in report services? I need to test out reports quickly as I build them... ...more >>

Hi, I'm using Reporting Services 2000 with the latest SP. The javascript code in Jump To URL is giving a Page Cannot be Displayed message. Here is the code: ="javascript:void(window.open('" + Globals!ReportServerUrl + "?"+ Globals!ReportFolder + "/Detail&Country_Code=" + Parameters!Coun...more >>

Hi, has anyone else seen this or know of why it's happening? I have a report with a parameter Region. The region values are pulled from a query: select null as id, '' as name union select regionid, regionname from region The Region parameter allows nulls and has a default value of null. ...more >>

I have a Report with a chart on it and have a Jump to report setup on the Action tab of the Chart control. I pass the report Parameters in the Jump to Report. My problem is that if I have defualt values for the report parameters, when I pass values in the Jump to report they get over written...more >>

Upgrading our Custom Data Extension from SQL 2000 Reporting Services to 2005 has necessitated dealing with code access security to a new degree. My extension is actually a complex set of interdependant DLLs: 1. My managed assembly that implements the Data Extension and two delivery extens...more >>

I am new to reporting services and have installed SQL Server 2005 and have imported about 7 .rdls from another reporting services server to a brand new installation of reporting services in a new project. When I go to Build and Deploy the reports, it prompts me to add the TargetServer URL. I...more >>

Hi, Is there any way to get more user information to the reporting services reports? In the globals section I can only find the userid and the language, but thats it... I'd need the username and user title, but it seems that that information is not possible to obtain. True or false? If it can...more >>

I need to pull some reports from an older ERP system in the US via ODBC I have the report in play, but want to limit the criteria to the items shipped today I have a TODAY_FIELD as a calculated Field with the parameter =TODAY() The Format of the Oracle view is mm/dd/yyyy hh:mm:ss AM and th...more >>

Any ideas on how to add a rolling sub-total within a group of rows? Essentially I want a report to show the sum of one field up to that row. From http://www.developmentnow.com/g/115_2005_1_0_20_0/sql-server-reporting-services.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

Hi I'm trying very unsucessfully to find the software for SQL Server 2000 Reporting Services. The servers we have, have SQL Server 2000 Licensed. Therefore, I believe don't need additional licenses. The only software I can find is the Trial version, and the Service Packs. What am I ...more >>

Hello all, I need to combine table and matrix.. Problem is that they have different dataset and matrix depends from info from table. In table I show user info and in matrix i should show user activity by event type... I did it with subreport... It very-very slow.. SQL for both dataset are pr...more >>

We use reports heavely and have LOTS of data to work with that needs reports run on, and right now we have a couple reports in crystal XI, but were looking at reporting services on SQL 2005 since we already have it... honest opinnions please, is it a good product? anything its lacking that cry...more >>

I used a report wizard to create a table report...How can I change the table style in design mode ? ...more >>

Not sure what best approach is but I think I need to just add zero's in front to solve sorting and if so - how do I do it: 1 11 12 19 2 22 I want 1 2 11 12 22 ...more >>

I created a report with say 5 columns, then decide I only want 4 of them. My approach was: 1) go to data area and remove from query 2) go to Layout Tab and remove from display But when I preview it - I get error - it still seems to always be looking for the column I deleted - what can I do...more >>

I am having a probelm with the javascript functionality in RS 2000 (sp2 installed). When the field is clicked (using jump to url with javascript...), a first new window is opened with the javascript... in the address bar and "The page cannot be displayed". Then a second window appears automati...more >>

We are in the testing phase of report service; several time through this testing the end users experience performance issue (system come to a crawl). I'm new to sql server 2005 and have not been able to resolve performance issue. I have search several sites and have located several articles ...more >>

I've searched and searched and can't find how to do this. I've got a main report and a report that I am trying to use the 'Jump to' ability with. I am capturing the ReportViewer1.DrillThrough event and am doing this: ReportViewer1.LocalReport.DataSources.Add(New ReportDataSource("JobApplic...more >>

(sql/rs v2K, VS .Net 2003) I have a problem with several multi-dataset reports. I've got several single-dataset reports working just fine, but these multi-datasets are problematic. For example, I have one procedure which works w/out parameters, just returns a statistics report. I have modi...more >>

Hi, I need to allow users to modify end reports to their liking. Changing grouping format etc. Currently I am using Crystal Reports and heard that sql server reporting services offer end user report modifications. I was wondering if any one using it can give me some feedback. Do you know wher...more >>

I want to be able to create a single subscription, but have the render format be BOTH .xls and .pdf. Is this possible? Currently, I'm having to either run 15 large reports manually, or set up 30 subscriptions. I would like to be able to automate this process. Any advice would be greatly ...more >>

I have upgraded our Custom Data Extension from SQL 2000 Reporting Services to 2005. I see that the Report Wizard will now launch my Query Designer for editing command strings (thank you!) but I still can not see a way to get RS to launch my "Connection Designer" dialog. When running Report W...more >>

In layout view: how do I group all the company names together who have the same value for a certain field? For instance, 10 companies all have the same booth size, but in Preview mode, it lists each company seprately with the booth size on each line. I need to have the booth size listed once with al...more >>

hi, all. is it possible to carry-over a subtotal of a page to the page header of the next page? we use ssrs 2005. thx, Carsten...more >>

Hello, is there any way to protect our .rdl-files on a Report Server of a customer to be extracted from the Report Server by one of our customer's administrators? Our customers should not be able to modify or develop further the reports developed by us. Kind regards, Ralph ...more >>

Hi, Until now, I only fount tutorials/howto's on installing Reporting Services, after a WSS install. In my situation, I have RS fully up & running, and I need to add WSS to the same machine. Which steps do I have to take? Can I use the same steps as in this link: http://msdn.microsoft.c...more >>

Hi, I would like to integrate RS with asp.net application. Need your help, some how-to... TIA, Kamel ...more >>

Hello. Is there a way in a report to get his url? I'll explain what i want to do: I want to add an option to export the report to excel format with out useing the menu so i want to add a button (or a table cell) and give him,in the nevigation field, the same url of the rreport with the same pa...more >>

I am using MS Reporting 2000 for Report where in one of the report I am using column chart. Now I would like to give customized color to each column in this chart but don't know how to implement it. Please help me out from this situation! Thanks, Sachin ...more >>

I have created a SSRS 2000 report that charts application crashes on a daily basis. Most of the time this chart only displays a handful of values and renders quite quickly. I had a situation recently though where the chart tried to render 2100 values and the report took around 15 or 20 minu...more >>

Hi all, I'm using SSRS 2005 SP1. When exporting my reports that have = subreports in, the sub report doesn't show up. Instead, the line = "Subreports within table/matrix cells are ignored." is there any settings I'm missing? your help is greatly appreciated. Best regards, Mohamed Sh...more >>

My users access SQL reports via weblinks from a Sharepoint portal. Even though they don't have backward access through the folders, they can still hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy? Thanks for the help JD...more >>

I can't seem to get the format codes to work in RS 2005. I assign one to a field, but it just ignores it and doesn't do any formatting. Is this a 2005 bug? Am I missing a trick? Thanks, Leon....more >>

I am new and I browsed through trying to find the answer but got no luck. Everyone here says that to get a subtotal of a group just right click on the group and get the subtotal. I tried so many times but still can not find out how to do it. Where can i get subtotal of a column? thanks a lot...more >>