Hi, Does any one have samples(code) on how to have a asp.net app call up reports. How about samples on using the Reportviewer control as well? Thanks, JJ ...more >>

hi, I have a console application calling reporting service to generate email subscription. It works but the email from field always show the fix address in RSReportServer.config. Is there a way I can programmable change the From field with my code? Please suggest. regards, Joe...more >>

Hello All, I am building a report for printing billing invoices. In my data source, there are two tables: 1. A header table - 1 record for each invoice (address, payer info, etc..) 2. A detail table - multiple records per invoice (detailed charge info) The user will select multiple invo...more >>

I need to open a aspx page from a report jump to ulr action. but I need to pass in a prameter value. see example http://ktec_inet/gco/productionreports/prod_asp/pcba_station_detail.asp?processname=335ICT&timestampw=999999999&userid=WeeklyYieldPCBA&queryflag= Parameters!prod_cls.Value -- Messa...more >>

I have 3 parameter fields, last-name, middle-name, first-name and the view/table of database has just one string combined of all three(and it is NOT possible to split). I need to provide search facility with any combination of these three fields. I am very new to this environs and would lik...more >>

In troublshooting a rights issue I changed the ReportServer service to run under a domain acount (rather than network service). I believe this may have affected my ability to run subscriptions as well as random authentication issues. I am unable to extract the encryption key which I believe ...more >>

I have installed Reporting services on a win2k3 on a completely different irtual Directory than Default Directory .My Report Server is working fine but I can't get my reporting manager working it give me this error: The request failed with HTTP status 400:bad request, Is there somebody who c...more >>

Is there any way to get data from a real install of Exchange into the database for the Exchange Pack for Reporting Services, or is it just to look at pretty reports that mean nothing to us? Am I missing something here? Michael ...more >>

I have a report parameter that gets its value from a custom assembly. I am not sure when or where to call the assembly. The examples show that I can override the OnInit() method of the report. Protected Overrides Sub OnInit() m_myClass = new MyClass(User!Language, Paramters!Territ...more >>

Is there a way to not have a report run when all of the default parameters are set? We would like to give the users some defaults so they don't have to type as much when they run a report....more >>

Hi all, I'm really new at reporting services. I'm hoping someone can help. I have a subscription that runs daily. The MSDN tells me "AutoIncrement, the report server appends a timestamp or number to the file name to distinguish it from existing files of the same name". Currently the number is...more >>

Hello, I am finally done installing the RS and started creating reports. Thanks to many people in this group, i read a lot of info to figure out stuff. I have a new problem now. My client doesnt not want a Web interface like what the RS provides. infact they dont want anything to do with b...more >>

I cannot find any really good documentation on programming with the = reportingservices.interfaces. I am looking to use the UpdateDeleteAuthorizationPolicy method of the = folderoperation enumertors to modify the security policy of folders in = the report server. Any ideas or places to chec...more >>

Can the report properties (eg, Report Description) be captured somehow in an Expression to be displayed? Im guessing that ALL the report properties are accessible, but Im not sure of the syntax. Im trying to create generic report header, that will capture the report descriprtion field. -- ...more >>

I am rendering a report containing multiple tables and charts. The byte stream returned is intended to be rendered in a web page. The HTML3.2 and HTML4.0 formats work fine; however, they work because the images are being streamed to the Report Server and my browse can see the Report Server. ...more >>

Hi All I have a very simple report that is grouped on a particular field. I have also set the "Page Break at end property" set to true for this group. I wish to set up a subscription that will email this report as an excel attachment. The excel export shows the records of each group in a se...more >>

We are planning on deploying our application in an ASP environment where each user (or client ompany) will be accessing their own Sql server database. What is the best practice for setting the initial catalog or data source for a shared report to the correct database? ...more >>

Item 1, I have a situation where I need stored procedure output to print horizontally such as: Jackson Tyler Harrison, ..... Item 2: Currently, my sql based report outputs text in the familar column format for the table field I am reporting such as: Jackson Tyler Harrison ...more >>

I have read several discussions that SP1 needs to be installed for the Export to Excel and Emailing PDF. Does Reporting Services SP1 need to be installed on the Reporting Services server? The server is a Windows Sever 2003 Enterprise Edition. Also, does the fix for emailing PDF need to be d...more >>

Hi, When I try to access report manager after installing reporting services (database in on remote server), it is giving me an error message that ReportServer is not activated. I tried rsactivate, but it is saying Windows NT service is not activated. anyone has any clue please. Thank...more >>

I have a ASP.NET web application that uses the sample ReportViewer control (URL approach) to view reports from my report Server. My report server is currently using a custom security extension ( Forms Authentication sample). Is there any way for me to provide the report server hard-coded login...more >>

I have a report where I want to have 1 record per page. I want to have a table that displays only the current record, not all. Is there any way to do this? Using a table instead of manually adding in each textbox for a column is much easier. Example: << >> Name: blah, mr SSN ...more >>

I have a table with a header and a detail. How I can set the detail so that it displays alternate color? Thanks....more >>

how to give deploy roles using Report Manager -- Message posted via http://www.sqlmonster.com...more >>

Hi, How do I change RSs authentication from Windows to SQL Server only? What config files need to be changed? What else needs to be changed? I just want authentication at the SQL Server level only. If I can't how about using Forms authentication instead for RS. What do I need to change f...more >>

Does anyone know of any problems with RS and SQL 2005?...more >>

When you hide duplicates on the report, is there any way to reclaim the space that the duplicate is taking. I am seeing extra spaces between the rows on my reports. I would like the rows with data to be next to each other without the extra white space....more >>

I've created a drill down and when the user expands the group, the container jumps to the top of the page. I've been asked if it is possible to keep this from happening. So, if I am expanding a group half-way down the page, it will stay there when the group is expanded....more >>

I have a cell in a table that needs to display one of 3 different images. I have an IIF statement to determine which one to display, but how do I reference the image file. I have tried to place the filename like "in.gif" in my IIF statement and uploaded the images to the folder on the serve...more >>

I have a report I want the user to add a new entry so I have a jump to url action on a footer item that will take them to a ASPX web page to add a new entry. I need to pass the parameter.value in the link to the url . http://xxxxxx/gco/productionreports/prod_asp/pcba_station_detail.asp?proce...more >>

I can get the column header to display vertically. However, the text reads from right to left. I want left to right. I have played with the format properties, but can't get what I want. Any help is appreciated. Thanks....more >>

I was really impressed with the ease MSRS reports can be created, but at the end of it I have come to a roadblock with MSRS not supporting Multi select in Parameters and also no graphical handle to place the parameters where I want. So I am concluding that MSRS is not a go forward reporting too...more >>

What is a good way to configure report services to put reports on the internet securely? ...more >>

Hi All, where will i find good artilcles on using matrix in RS?? im using the following SQL statement select Count(ResourceOrganization.ResourceID) as ProfCount, DG_office.OfficeBriefDesc, resourcecategory.resourcecategorydesc from DG_Office inner join DG_Office_Organization on ...more >>

Hi All, I have to build a solution where end-users have to operate data input and reports. (This means that the GUI must be very user friendly). Because of this, I was thinking of using Windows Sharepoint Services (WSS) as a front-end for data input and using Reporting Services for genera...more >>

Hi, Does anyone know if it's possible to refer to the name of the textbox in the expression of this textbox without hardcoding? I want to duplicate this textbox to a couple of hundred and my purpose is to use a part of the textbox name a an index for a substring. So for example the textb...more >>

Hi all, I need to show the Sub total row in the matrix in a different color. How can I do this.... Thanks in Advance,...more >>

Hi All, I need the alternate bg colors of the rows in the matrix to be white smoke and grey. when i used the following expression it throws a error. =iif(RowNumber(Nothing) Mod 2,"WhiteSmoke", "LightGrey") The background color expression for the textbox ‘ProfCount’ has a sc...more >>

I know that the SP2 Beta is around for testing. Does anyone know if in this version the Calendar control is made available for use for date parameter input ? I believe the Calendar control is the most needed control in any kind of reporting. Comments Please. thanks, Anand Sagar IN4Velocity...more >>