in rep s 2005 there is a reportbuilder - anybody know if this will be available with 2000 ? ...more >>

I finally got forms authentication to work, but when I create a new user and log in, I don't get any menus. My question is how do I assign the user I created access to the appropriate menus (e.g., view report list, subscriptions, etc.)? The sample dB is different then the ReportServer dB...more >>

Sorry, already posted this but forgot to use new MSDN nospam alias so here it goes again... Has anyone actually found a Crystal 8.5, 9, or 10 conversion tool to take those reports to MS SQL RS? Seems like this would have been a great tool for MS to do, but perhaps they're worried about the go...more >>

I am unable to get the reportviewer to display a server report from my aspx page. If I configure the report server as Http://server/reportserver/, I get a http 401 error. If I configure the report server as http://server/reports/, I get a http 404 error. The report name is report1. The repor...more >>

Dear Why in my reports dont show print icono or print button? Help me please...more >>

We were using reports on our intranet environment for a while and tried to create couple of reports on internet. We did this - Installed a Windows 2003 Server/SQL Server 2000/Report Services, then uploaded reports. Can we get reports on our web pages without giving an external IP for Report...more >>

s it stands, my table skips the second column on the page and flows into the first column on the second page, and then the first column on the third page, ad nauseum. I want the table to fill up both columns on the page before breaking to the next page. All the docs I've found state that flowing...more >>

Hello, how would I write an if statement to ensure that a "0" is displayed if a divide 0/0? Thanks ...more >>

I've published my first three reports from VS.NET 2K3 to my local Web site, and the drillthrough links do not work when I view them through the Report Manager. The links work fine in Preview mode. When I view the first report and use the drillthrough links to the second-level report, I get ...more >>

I am hosted by an office in MN. At our end we will have report browser and VS 2003 for development. The host office is on sql 2003, according to the logo that comes up. I was wondering if they have RS 2003 (i asked and have not received a response)? Is there such a thing? All I see in the...more >>

Hi, I just installed on XP Pro SP1 - the developer edition for SQL 2000 & Report Services. The problem I am encountering is that I can not get any report to render. I can publish/deploy them without error. The report manager works fine until I click on a report. Here's the odd part, i...more >>

I have two date parameters which will be used as data range in my report. But when I enter same date in both date parameter text boxes it appends the timestamp (12:00:00 AM). Example: When I enter 07/24/2004 and 07/24/2004 it converts that into 07/24/2004 12:00:00 AM and 07/24/2004 12:00:00 AM....more >>

I am currently evaluating RS for SQL Server 2000 and the question has come up as to whether we can upgrade to SQL Server 2005 and have all our reporting projects moved as well? Is this possible? If there is additional work involved to do this upgrade, where can I find this information? I did...more >>

I am currently evaluating RS for SQL Server 2000 enterprise, and the topic has come up whether or not we could easily upgrade from SQL Server 2000 to 2005 and all our Reporting be moved over as well? Is this a straight upgrade? If not, what type of work is involved when we do decide to make t...more >>

Hi I want a report that can give me a layout as follows: Name Address Quantity Month Quantity YTD Amount Month Amount YTD Paul xxxx 2 5 300 850 John dfsfd 1 3 100 250 Peter dssd 5 7 900 1200 Samantha sdfgdsgf 3 5 450 650 The table in the SQL 2000 db only st...more >>

All, I have a report where I have implemented sorting and paging. I have implemented sorting in the Sorting tab of "Table properties" and I have implemented paging using a suggestion in this forum. I dynamically create groups based on the row number so that each group has exactly 19 ro...more >>

Ok, I just cut and pasted it: =IIf(Fields!Purchase.Value < 0, "Red", "Black") Is this in the correct format, or is their a problem in the font settings? Thanks, Trint ...more >>

sp2 must also me installed on the developer machine or only on the server machine? Thanks ...more >>

HI: RS newbie here. I have several reports that I'd like to use as a template for other reports. Is there any way that I can duplicate a report once I have created it. I tried to copy of all to files connected to the report (rdl , suo etc) and then rename them with a new report name ...more >>

Hello, as long as I know RS Sp 2 comes with a webpart. the fact is that I have reporting services in a server different of the one where WSS is installed. How can I use the WebPart in my SharePoint Site. ...more >>

I have been working through a solution to allow multiple parameters to be passed into a SQL RS report. I have created a windows application that calls sql reporting services. The problem that I am having now is passing the multiple values the user selects from the dropdown to sql reporting s...more >>

I am having problems trying to prevent data to be displayed in merged cells. When the report is exported to excel, the start and end of a control forces a start and end of a cell in excel. To prevent this I have snap to grid on and I am using the properties to get exact measurements to lin...more >>

Here are the expresstions: =(Fields!Purchase.Value + Fields!Matrix.Value + Fields!QualiFly.Value + Fields!Dist.Value + Fields!SM.Value + Fields!BreakAway.Value + Fields!Transfer.Value + Fields!Spent.Value) =iif(fields!Purchase.Value=0, "black", "red") Thanks, Trint ...more >>

Hello, Is there a possibillity to use Report Bursting in reporting services ?...more >>

Hi, I have a report with 25 subreports which needs to generate one pdf file on schedule basis (ie. schedule report to render in to PDF format based on some time and date setting). Is there any way of doing this? Thanks in advance for the helper. Regards. Anitha ...more >>

I have a warehouse load that runs overnight (executed via SQL Server DTS packages) and generates a lot of metadata including data errors, reconciliation totals etc. Once the warehouse load has completed, I want to e-mail the relevant people with a reporting services report summarising the meta...more >>