Hi All We have requirement where we need to hide some of the options which we have in Format drop down i.e we need only CSV,PDF and excel . How can we do this? Thanks in advance Rehan Mustafa Khan --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.SqlJunkie...more >>

Hi, I want to use a stored procedure as the dataset for a report. Even though I could execute the stored procedure in the query designer view, the report designer did not generate the fields list (in the fields window). Then I specified all the fields explicitly in the fields property of t...more >>

When I log in as domain admin, I don't have problem to browse over the report manager to view reports. But when I log in as domain user, the home page do not have any report show up. Please give me some info about how to set up the security on the home folder, so that the domain user could browse r...more >>

Hi all Im using a stored procedure with in params as datasource to a report. These params are initialized to null by default in the procedure. When executing this datasource in the report designer's data tab every thing works fine - i can live these parameters with nulls (or set other values) a...more >>

Hi: I want to have my table rows with two colors depending on which row is (odd or even). I am assigning =iif(rownumber(nothing) mod 2, "white", "red") to the BackgroundColor property of my rows; but it does not work when I have my rows within an aggregation level. How can I do that...more >>

I am installing SQL Server 2000 Reporting Services trial version from the cd I received at the recent simiar, here is the details of the errors I get while running the installation 1. Report Server component requirement - explaination of the problem is iis is either not installed or not iis 5.0...more >>

I have an appliction that we want to convert to ASP and RS if we can. We are trying to figure out if we can do it effectivly. Our current appliction allows a user to apply a criteria to any report in the appliction. The appliction will change the where clause for a report at run time and even ...more >>

Using VS.Net 2003, I don't have the Business Intelligence Project type. I have installed Reporting Services today and would like to start creating some projects with it. When installing reporting services, I didn't install the server software on the same machine as VS.Net. I don't need to do t...more >>

I'm working on a project to create a Report. Currently, I have an Excel spreadsheet with a macro running that creates the report that I want to move to SQL reporting. There are 2 tables. One Table has 2 sets of price ranges, with a "StartPrice", "EndPrice", and a "Type" to select between the 2...more >>

Hi, I have reports which need public access. I have a web application in 1 server which has public access.Database in 1 Server and the Reporting Services in another server(Database and Reporting Services are behind the firewall).I have links in my webapplication which will create pdf's and exc...more >>

I am currently migrating all our Crystal reports over to Reporting Services and I am having a few issues that I am hoping someone else has already had. In Crystal you can set up formula’s and trigger them during the report, theses formula’s are triggered in the order of the report being printed,...more >>

I try to install reporting services for the client so that I can develop reports and I get an error: Set Dialog Error Code: 1603 Below is part of the install logs: <Func Name='RedirectorCAX'> Function=SetDialogs <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastE...more >>

Hi, * I have an image named BrandImage defined on my report. * I have a parameter in my report called Brand, with values based on a query. For example, the query would return three rows with the values: BrandA, BrandB, BrandC, respectively. * I have three embedded images in my report. The are...more >>

After installing SP1, a report failed to render to PDF, with the following error from IE: "Internet Explorer cannot download Format=PDF from myserver. Internet Explorer was not able to open this Internet site. The requested site is either unavailable or canot be found. Please try again later...more >>

I am getting this message when installing Developer - Reporting Services on my Win XP Pro machine. I have run aspnet_regiis, DotNet is running and working. Anyone know how to fix this issue? ...more >>

Hello, I am restricted to using stored procedures for data access. I would like to be able to create a "Text" Dataset named C which is a join of two "Stored Procedure" data sets (sp1, and sp2). Any idea how I can do this. Thanks. ...more >>

Hi: I am trying to build a report off of a stand alone MS Access 2000 database. I can create the Data Source using the "Driver do Microsoft Access" driver, version 4.00.6019.00. When I go to create the query to create the Dataset, I right click to add a table, I can see the table list and c...more >>

Hi, I need to have a table of contents with page numbers in a report. The report will only ever be rendered in PDF. Is there way to do this natively in RS? The only thing I can think of right now is to render the PDF using SOAP, extracting out the document map values, generating a new PDF pa...more >>

Hi All, How I can apply format to a parameter field? Actually I want to truncate the time field from a DateTime Parameter. Thanks, Sam ...more >>

My dates are in unix time and the paramaters are entered as 7/6/2004. How can I convert the date in the parameter field back into unix time so it will retireve the records. Unix time is the number of seconds from 1/1/1970 at 12:00am Thanks...more >>

Once I installed Reporting Services in the server how do I find out if I installed the latest version? Which file tells me the version that is currently installed?...more >>

Hi Guys, Just wondering how to display Sub Totals in a Page in a Report I just have a simple report which lists some numerical tabular data.. I just want to display the subtotal of certain columns at the end of each page in the Reports. I have groupings on the whole data and i can always ...more >>

I'm confused about this property. I have a textbox that I want to appear under certain conditions. If it's not visible, won't it shrink as well if I set the property? Thanks! ...more >>

I have basically completed my due diligence of looking into Reporting Services as a replacement for a large Crystal Reports deployment. There are several problems past the obvious infancy of the product, and I am suspecting that the power of the software will continue to rapidly evolve. But as o...more >>

Hi All, I developed a report in my local machine and it is output is perfect when i view it under Report Designer. But the output is slightly differs when I deploy it on a report server. The fields are wrap around to the next line while generateded by the Report Server. Is any settings need...more >>

Hello all: We have recently adopted this platform for our reporting. A couple of issues I am having: 1. We would like the grouped columns to start on the same row as the parent, so that there is not a break before the grouped items begin. Any way to do this? 2. Our parameters include a ...more >>

Is it possible to programmatically export a published report to a pdf file in SQL Server Reporting Services. I need to know if SQL Reporting Services allows that to be done programmatically in code without user interaction. If so can you point me as to where I can see some code samples or if a...more >>

Hello, I've got a stored procedure that my report uses as a datasource. One of the parameters for the stored procedure is an Integer called "OfficeTypes". The stored procedure checks if OfficeTypes is null, and if it is it returns every record. I want to hide the "OfficeTypes" input on the report...more >>

My environment: --Windows NT 4.0 SP6a Domain -- SQL Server 2000 Ent. installed on Windows 2003 Server (member server), in mixed mode, terminal services disabled; SQL server is running two instances, default and named; Reporting Services installed on a named instance of the SQL Server; the ...more >>

I have set up reporting services in a test environment. When I type the report services homepage URL in the format http://ipaddress/Reports from a client machine, I get a prompt for Enter network password with username, password and domain. What should I do to bypass authentication?...more >>

After I hook up a datasource with a stored procedure, I run the query and expect the fields box to populate with the retun query columns. This does not happen. Are there certain conditions that the query has to meet for SQL RS to do this, for example, does the query have to return a perm...more >>

Hi All, I have a barcode that I use on one of my reports. When I test it on locally, the barcode displays and exports to PDF fine. I have made use of the barcode code samples on this forum (thanks), that makes use of a barcode font (FREE3OF9.TTF) that results in the DLL assemlbly (ReportUtils.DLL...more >>

Hello there I am trying to create a Matrix report from an OLAP cube but not having any luck. the end result I want is the UserName along the Row section, Months of the year along the column section (the date range will be specified in the MDX statement), and the Data will be a count of hi...more >>

Hello, I would like to modify dynamically my footer. I have a list displayed on several pages and grouping my data on IDCategory. I would like to put on the footer the name of the category on each page of the list. When I use a textbox (with the name of category) on the body, with a link Repo...more >>

I have 4 reports. 2 of them with two matrix. One inside the other. They work fine. I have a map in one of them and it also works fine. The other 2 have a matrix and a listbox inside. They can't be expanded. When I click the (+) icon it shows an error: "Error inesperado al procesar los inf...more >>