Hi, I'm new to Reporting Services: 1) First a question: what's the difference between Views and Stored Procedures? I am rewriting an Access Database to take it into RS....in there, I have 4 tables, 1 query and a report that depends on that query. 2) I need to make a new project in RS. T...more >>

I've installed SQL reporting services on one of our SQL servers along with the .net framework. I then installed VB .net 2003 and I'm trying to open a new project to create a report. When I click on new project, the new project window opens, but there is no Business Intelligence Projects fold...more >>

I'd like to add a report footer to my report,but I don;t find it.Where is it? I have a Group footer and Page footer there,but can't find the report footer. Thanks ...more >>

I'm enclosing the pertinent log entries form the ReportServer_DD_DD_DDDD_HH_MM_SS.log file. Problem: I've written a custom forms auth extension that (naturally) works fine in the test environment. In production, under about 25 - 20 users (80 - 150 report requests) per hour, everything works fine...more >>

We would be updating the Report Server and Report Designer pieces together. If we update the Designer to SP 2 for testing, will that developer still be able to deploy to a production server at level SP 1 without problems?...more >>

Is there a definite sequence for applying Windows 2003 SP 1, Reporting Services SP 2, and SQL Server SP 4? We are looking to avoid a reinstall of Reporting Services SP 2. At this time, there are no definite plans for any of the service packs mentioned. What would be the best sequence of eve...more >>

Can the labels on the x axis be rotated so that they display vertically. The user wants a report that shows the month-year like May-2005, but with the text rotated 90 degrees....more >>

I can create a parameter list box with values from a query from a database table. Note: The database table does not contain any spaces or Nulls. I am trying to find out if it's possible to have a value inserted into the results of the SQL query. This value could be a space or specific value....more >>

After deploy already tested report to customer's ReportServer I have a very strange problem: 1.Embedded image is missed at all in Header,but after export report to pdf it exist. 2.Pressing on + icon for get subreport does not do nothing.No call to subreport.Testing subreport standalone works fi...more >>

I just installed SP2. I republished my report. When I view the report within my web application, I now see a print icon. When I click on the print icon, I get the following error: An error occurred during printing. (0x80004005) Does anyone know what this means?...more >>

I installed RS on a SQL 2K server. Installation went fine. I didn't install the Report Designer since I have VS.NET on my XP box. However when I open VS.NET I don't see Business Intelligence project. Does it need to install as add-on in VS.NET? Thx. ...more >>

I developed an app which uses the forms authentication sample from microsoft as a security extension, but since i upgraded my system to sp2 it stopped working, besides it doent work on a win2k3 server but it works on a win2k, the problems seems to be with ssl im using the selfssl utility to ge...more >>

I've got a report that is supposed to output on an Avery 5160 sized (1" x 2.5") label. The report is set up with a 1" tall x 2.5" wide data area, 3 columns, appropriate gutters and margins. It seems that I'm having to do a lot of really small tweaks to get everything to line up correctly on a ...more >>

I cannot seem to figure a way to implement a watermak. Does anyone have any suggestions? Thanks Josh...more >>

Hi!! I'm trying to install SQL Report Services on my mahicne. I get the designer installed, as well as other tools, but the Report Server doesn't get installed, and I can't open or deploy any report. I have WXP Pro, S2K SP4, RS Dev Edition SP1, and using my admin account. The "ReportServ...more >>

How do you find out the width of a matrix control, I need this to enable me to size the width of a Textbox, as the width needs to be the same size as the Matrix control which keeps growing depending on the data ...more >>

While creating a report using 'CreateReport' API method for Report Services 2000, I am getting the following error. // A field in the data set ‘MainDataSet’ has the name ‘Count Borrower Name’. Field names must be CLS-compliant identifiers. --> A field in the data set ‘MainDataSetâ...more >>

I have a report where I want to create a boolean parameter that has two radio buttons, where one radio botton has label "With Approval" and the other radio buttons label says "No Approval (Under Review or No Request), plus there is not leading text prior to the first radio. Basically I want my...more >>

Hi All, Has anyone got any source code (script) that does the following: I really don't have time to try and figure this out (too much other work) and don't want to have to do it maually and was wondering if some clever person had already done this or had ideas. Thanks K Scripting Dep...more >>

Give me some samples how to use reporting services in ASP. I have done with ASP.NET. Is there any possible way to use the rdl other than .NET application. Thanks In advance. ...more >>

The text in my pie chart legend does not wrap. It is cut off ending with "...". Is this by design?...more >>

Hi I've got a report which takes a start & end date as parameters. It works fine, except that RS seems to insist on my users typing US format dates (mm/dd/yy) rather than UK format (dd/mm/yy). Does anyone know how to change this? Sorry if this gets posted twice - cookie problems Chloe ...more >>

I have Reporting Service up and running and able to send email of the reports. I have a request from a client to set their system up so that reports are email to approved recipients. I have the DefaultHost (called DomainA) to the local SMTP domain, and have put in a domain in the PermittedHost (...more >>

I believe a simple question..but I'm new to SRS. I have three parameters. Two are pulling from queries which makes them drop downs, The first is a simple select query which upon selection passes a parameter of its value to the second. the third is a free form field which a person enters ...more >>

Hi, I dont want to Schedule our Reports, because I dont know when the data delivery of our DTS-Packages is finished. So is there a possiblity to Start a Report within a DTS-Package (after Success). Thx in Advance, Regards, Dieter Felix...more >>

Hi, I encounter the follwing problem: My standard language is german (in VS .NET as well as in Reporting Services), but sometimes (no idea by when) it changes to english. This is not very nice for some of our users. Can I assign the german language somewhere and supress all other language...more >>

Hi, I'm using a barcode font in one of my reports. This font is displayed correctly on my development machine. But when I deploy the report to the production server the PDF doesn't render the font. It's using another font instead. The font is installed on both machines. So I don't know why...more >>

I am trying to build my first report following instructions in a book (Wrox - SQL Server RS). The sample they use (using the wizard) calls for resizing the report header and the detail section in the body. They say to "..click anywhere in the grid and then click on the gray box at the inters...more >>

Hi all, I'm trying to past thru POST a parameter. Works fine but when the parameter has more than 1850 chars the report is not displayed and any error is throw. The server is installed in Windows 2003. Has some limitation the length of parameters when is send by POST? I'm desperate because...more >>

Original machine is Windows 2000 with SQL Server 2000 Enterprise SP3 and RS SP1 all english, new machine is Win2003 with SQL Server 2000 Enterprise SP3 and RS SP1, all german. The new machine doesn't have the same network name as the original machine. After a first failed attempt, I decided ...more >>

Dear all, I have a problem to setup the example in the artice "Deliver User-Friendly Reports from your app with sql server reporting services", Can anyone help me? Firstly, It works fine with IFrameDemo.aspx and RptViewerDemo.aspx However i run Default.aspx, it show "The request failed w...more >>

Hi All, I'm trying to supress the toolbar when printing my reports through IE - but at the same time I still want to be able to allow the users to view the report criteria, and make changes where necessary! There is the option of setting the toolbar=false, and parameters=true - but it seems...more >>

Does anyone know if the reporting services is an add-on to the SQL server license or does it have its own license that must be purchased?...more >>