I have two tables, which you can call master and details. I want to pull data from master table and respective details from details table. Here are tables and data information. Master Table MID Description 1 Person – 1 2 Person -2 3 Person – 3 ...more >>

I have two tables, which you can call master and details. I want to pull data from master table and respective details from details table. Here are tables and data information. Master Table MID Description 1 Person – 1 2 Person -2 3 Person – 3 ...more >>

Hi, After installing SP1 of Reporting Services - viewing the reports in reports manager is very slow (about 20-30 seconds to view a small report). Before SP1 it took a few seconds to view the same reports. I checked the executionlog table - the time fields look ok. Can you help ? Thanks...more >>

Anyone have a source for detailed specs on this? Specifically inclusion of the ad-hoc interface like CR has? (ActiveView?) We are looking at a potential dump of CRE and using SRS if the funcitionality we need/want is there. thanks -- Curt Christianson Owner/Lead Developer, DF-Software S...more >>

Is it possible to toggle the visiblity of recursive data in a table to give the effect of expanding and collapsing the hierarchy. I have created a table that displays the content of my parent child table and indented it appropriately show the different levels, however I want to be able to exp...more >>

All How do I go about validating input that is entered into a filter without using a drop-list? ie. Validate that a date is in the correct format and not greater than today's date. Thanks ...more >>

I asked a similar question recently, but I'm afraid I'm still not sure of the best way to proceed. We need the ability to provide internet users with the ability to access the Reporting Services report viewer. The internet users will not have a Windows accounts. The report viewer is necessar...more >>

Is there a way to display the "Last Run Date" in the actual report?...more >>

I am using a shared data source to access a Teradata machine but the password I need to use is generated elsewhere in a component and changed regularly. Is there a way I can get the shared data source to grab the current password from the component on the fly?...more >>

I expect that this is a trivial problem, but I've banged my head on it for long enough. I'm hoping there's someone out there that can help! :-) I have the MS sample for forms authentication (http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp) working just fine. On...more >>

I had to face a strange behaviour: i am developing an ASP.NET application, part of the application renders reports through the SOAP API. My machine runs W2K Server, the application connects to the database and to the reports via the process identity (machinename\ASPNET). On my machine everything ...more >>

I use RS on and off and I have noticed that when I move a text field in a report and preview it the report doesn't automatically refresh data anymore. I'm I seeing things or is this the case, if it is then good on you MS ...more >>

Having problems with the <CustomAssemblies> attribute in my config files. It doesn't exist!?!. I have a couple books for examples, Enterprise and Dev versions running here onsite. I cannot find this element in the 2 defined configs that are supposed to have this element. Since they don't seem to ...more >>

Does Reporting Services provide any facilities for localizing DateTime values based on the location of the server itself? We have DateTime values stored in the database, and need them displayed converted to local time where the server is located. Thanks, Jas ...more >>

Hello, I have a field in my report that I want to jump to another report but I want it to jump to different reports depending on what is in that field. For example I click the jump to report and put something like this in the expression builder: Iif(Fields!Type = "a", ReportA, ReportB) w...more >>

Hi all, I am exporting to PDF through web service a report that contains matrix. I get almost every second page a blank page. The same report when exported to PDF by the report manager does not contain blank pages. Is it a bug, Is there any work around Thanks, Yuval ...more >>

Is there a function or quick way to convert a calendar date to a julian date. For example 1 September 2004 to 4245. Rus Bailey ...more >>

Does anyone know whats the best way to automate the e-mailing of reports (say at the end of every month) to a list of people based on a certian criteria for each report. We have different sales people and we want to automate thier sales comission report that needs to be generated and e-mailed ...more >>

Is there a way to export to word or at least RTF format? I was using another reporting tool which can export to RTF, so my clients are used to export their reports to RTF and they want to keep that feature but i havent been able to find a way for them to do it. ...more >>

Maybe its just a bug, but today, after making no changes I started to recieve an error when trying to preview the report still in Reporting Services. "An error has occured during report preocessing. Attempted to use and object that has ceased to exist." No build errors, and can get it to ...more >>

Hi, I am creating a data driven subscription via code. I have a shared data source I wish to use as the data source for this data driven subscription. How do you set the DataRetrievalPlan.Item property so that the subscription is set up to used the shared data source (instead of getting ...more >>

Is there any possibility that I can change properties of excel format when exporting into it.? I need to have two or many sheets in that excel and I manage to do that but their names are Sheet1,Sheet2,Sheet3 etc. How can I name them in design mode of report? Domagoj ...more >>

I have a stored proc that receives 4 parameters. When I run the stored proc from the data area RS prompts me for the 4 parameters and executes the query just fine. When I go to preview the report I get a message box with the following error. "An error has occured during report processing. Q...more >>

Currently we're using an application and the Report Viewer to "view" our reports. One report that we need to generate is solely based on the user's SalesRepCode. So what we want is that each user select a report and then pass there SalesRepCode which we get from the application, through the qu...more >>

Hi, The issue is that if a report has all of it's required parameters supplied with a value, the report automatically runs whenever the user navigates to that page. Is there any way of turning this behaviour off (other than by not providing default values)? Or does anyone have some suggestio...more >>

Hi guys I have tried to move my RS from one server to another. The SQLServers & RS are same version & service pack. Once I move the files I have done a rsconfig then a rskeymgmt. After all that I get the following error: Reporting Services Error ------------------------------------------...more >>

What's concensus for report behavior in browsers other than MSIE? Once i'd formatted my report to display all nice in MSIE, i looked at it in NS 4.79 and Firefox, and it looked drastically different. -- Brian Grant Senior Programmer SI International www.si-intl.com ...more >>

Hi there Our company has just started using RS and I would like to know how to set up basic security. Our setup: We have RS installed on one of our SQL servers. Our Analysis department creates reports on their PC's (with Reporing Services & Visual Studio.net installed on their local P...more >>

Hi, When the report comes from the server (ie: not from the preview in VS.Net) the consecutive white spaces in values are lost. Only one white space is left. They are shown correctly in the preview though. Example: the value of a field expression is: ="xxx yyy" the browser shows: "xxx ...more >>

Hi, ERROR: The underlying connection was closed: Could not establish trust relationship with remote server. I’m not able to start the Report Manager (https://myserver/reports) Webapp using SSL. The WebApp https://myserver/reportserver is working fine. My current related RSWebApplicati...more >>

Hi there. I have the following issue with all report subscriptions that I setup from the Report manager that have attached the report files, regardless the format. The e-mail is properly sent with a file of the proper name but of zero file size. It seems to work when I set the render format t...more >>