Hi, I hope anyone can help me with this problem! I have installed RS on Win2k Server with all Servicepacks. From my client in network i can view all Reports but I can't add new subscriptions. On the site "SubscriptionProperties.aspx" the "OK" and "Cancel" Button are not working. On my client...more >>

The overall question: How do I get the Reporting Services tools for Visual Studio 2003 if my web hosting company owns the SQL Server? I am a lone developer with a laptop and a web hosting company. I have Visual Studio 2003 installed on my laptop (Windows XP Pro). My web host provides me wit...more >>

Need help please... I have one folder 'RSFOLDER' with all reports and subreports in it. I don't wont to set any permissons on that folder. This fodler is hidden... I have second folder. That folder is not hidden, it has user friendly name, and contains linked reports from folder RSFOLDER. U...more >>

I have one other issue, possibly related to my last post, that I thought I should post in a separate question. When I specify a default value for a parameter using an expression, the form postback process seems to get scrambled. If I enter a value in a text parameter, then click "View Repo...more >>

I've created a data source connection using the sa login and password with the save password option. Running the stored procedure returns a good result set. Ok, I'm feeling pretty good at this point . But after clicking on the Preview tab, I receive the following message: "A connection cannot be ...more >>

When I create a parameter and specify a default value using an expression, the control appears disabled, even though the default value is correctly applied. For example, I have a boolean set of radio buttons, that should default to true if the report is in a certain folder, and false in all o...more >>

Is it possible to default Zoom to 'Whole Page' instead of 100% in Reporting Services (not through a custom application). I understand that I can manually do it each time I ran a report but I was wondering about some kind of custom preferences setting. Thank you....more >>

I am trying to incorporate custom assembly code calls inside of my sql that comprises my dataset. I open up the Generic Query Designer, select Command type "Text", and give my dataset a name "TempFilterTable". This is what I have done so far: ="select * from " + MyClassLibrary.CarolynCl...more >>

I have created my own SRS DPE. When I run the Report Wizard and step through the pages to the "Design Query" page, the "Edit..." button is not enabled (and thus I can not get to my Query Designer Control). What is required for this button to be enabled?...more >>

If i am working in debuglocal and want to use one datasource then when i switch to debug i want to use a diff. datasource, i don't know how to do this. i have both the datasources set up as shared and i can see them in my project. but when i want to change configurations, i want the datasource to...more >>

Hi, I've some searching around this group but haven't found any good answers on my question. There isn't an out of the box way of attaching a calendar object to let's say a startdate parameter on a report. I was reading you could accomplish this through the use of an active x object. Has a...more >>

Hi all, Hoping someone can shed some light on the problem we're having here. The situation is that we have built hundreds of web based reports utilizing softartisans excelwriter. The basic functionality is that a report is built for excel in an aspx page and then exported to excel. Is it ...more >>

Hi All, There are two parameters in our DataSet based on the query below. @Year causes "syntax or access violation" error, because it's in subquery. @Parameter2 works (in the main query) ------------------------------------------------------------ SELECT *, ( CASE WHEN Av_MTD >= ISN...more >>

In my report, I have one group and details. The group has two rows, with the 2nd row's visibility toggled by one of the textboxes in the first row. The detail row is also toggled by the texbox in the top group row. (the second row of the group has the titles above the detail row). Anyways,...more >>

I currently have several sprocs that require a variable which determines which set of fields get returned. For ex: X returns fields 1, 2, 3 and Y returns fields 4, 5, 6. When I run the sprocs the appropriate fields show up in the results window but when I refresh the fields, reguardless of wha...more >>

I am specifying in the report to use Arial 8pt font, but when it prints out, it uses Arial in about 14pt font. I can export the report to a TIFF and it prints perfectly. How do I get the report to print with Arial 8 when printing from the extension? ...more >>

Report server has been failing on my machine ever since I installed the .Net framework 1.1 SP1 to correct another problem. The error reported was that the encryption keys were not working. Based on previous posts to solve this problem I performed the following staps: 1. I ran rskeymgmt -d t...more >>

I have the following query = "SELECT * FROM " & IIf(Parameters!ar.Value = "renewal", "vwRenewal", "vwOPL" & " Where 0=0 " & IIf(Parameters!ar.value = "renewal", "AND (IIf(boolExtension = 1), (dateEXTENSIONDATE >= '" & Parameters!begindate.Value & "') AND (dateEXTENSIONDATE <= '" & P...more >>

Hi, One of our reports has a table where the elements can contain multiple lines, seperated by CRLF pairs. CanGrow=True and Shrink=False is set for each element. Everything is ok, except that in some occasions the export to Excel does not expand the row lines as shown in the browser. Does a...more >>

In SQL Reporting Services, i am having a problem with passing the label value(eg. on x-axis) as a parameter to another report. So for example, lets say i have the days of the week as my x-axis values in the graph. Is there any way to allow the user to click on this label value(eg. monday) whic...more >>

I have got GMT Time Data on my database. It is possible to used the user's time on a chart or in a table ?...more >>

Hi, I have a SQL stored procedure query that creates an alias for one of the column names. The alias is "Event_Number_Count". I tried to reference it in my report using =Fields!Event_Number_Count.value but I'm receiving an error: "Report item expressions can only refer to fields within the c...more >>

The dropdown list for using a Shared Schedule in a Subscription or Snapshot does not appear to be sorted Alphabetically. What deterines its sort order? I ask becasue I am trying to create several Shared Schedules for my Users to have for scheduling their own reports at times of the evening w...more >>

Following some advice i'd found about solving an alternative problem, i ran the rskeymgmt.exe -d and now both http://<machine>/reports and http://<machine>/reportserver both display a rsReportServerNotActivated message. Any ideas on how to get my service back?...more >>

I have several queries and stored procedures in a report. Two of the stored procedures return the error: "This field is missing from the returned result set from the data source." when previewed or executed from the web server. Both Stored Procedures take one parameter @JobDate and return a...more >>

Hi; I have a problem with the pdf rendering.When I try to render the report to the pdf with diffirent language like "de" or "fr" I give a error.How can I export the report to the pdf with "de" language????Any ideas???? ...more >>

I have a report that has multiple measures coming from an OLAP data source. Some of these measures are counts, some are % and some are $. How can I set the format property for each. Thanks. -- Michael Hardy ETL Developer Visit our web pages: www.atlantis.com www.oceanclub.com www.on...more >>

Does anyone know how to open two or more reports in adobe reader (pdf)? For example, the user wants to print multiple reports in one whack, so I'd like to be able to render several reports and ship them to adobe all at once. I am using the render method of the web service to render reports al...more >>

I have a matrix with sums grouped by a project pk. Every row in the matrix is a project. I want to show the sum like it is in one column and in another column I want to sum the same data but this time I want to use only rows filtered by a filter for the sum. (The row values that I add to th...more >>

Hi, I'm having this strange problem while configuring RS on a Windows 2003 server. The SQL server DB exists on another machine. Whenever I visit the report manager with the credentials used to install RS (this is also a local admin account), everything is OK. When I use other credentials, t...more >>

I am trying to convert a Crystal Report into a MSRS report. In CRW, I have the following formula: WhilePrintingRecords; NumberVar ClassC; NumberVar ClassS; NumberVar ClassN; Select {CreateManualReport;1.ProductTypeCode} Case "C","CB","CE","CP" : ( ClassC := ClassC + ({Cr...more >>

Hi Everybody, here is my Problem: I've tried to design a small Report. Everthing works fine, but now I would like to bind a Chart to the Details-Colums of a Table. Is it possible to bind the Chart ? and for every repeating of the Table (next row in dataset) there must be a new Chart ? Does...more >>

Hi I have an input parameter 'AccountNumber' in one of my reports. I would like to make it possible for the user to put in multiple accountnumbers in this parameter. I was on a reporting server courser and we did this by creating a function that accepts the list of accountnumbers and (comm...more >>

My reports will keep data regions together with no problems in web reports but once I export them to pdf I frequently get data split in silly places. Is there a way to keep the data together in pdf without having to break after every item?...more >>

I get the following messages in both the /Reports and /ReportServer applications. Server Error in '/Reports' Application -------------------------------------------------------------------------------- Configuration Error Description: An error occurred during the processing of a configura...more >>

Hi, guys, I have an application which only accept Plain/Text format email, but the email sent out by Reporting Services Email Delivery was wrap in HTML format. Is it possible to configure Email Delivery to send out Plain/Text format message? Many thanks! David Zeng ...more >>

i have create a paramenters and use in the sql, but after i deleting it from the sql statement, i still need to enter the paramenter in the PREVIEW. i have check and clear the parameters clicking the "..." button but when i check the properties of a table and set the expression, the parameter...more >>

Development Environment 1 Web Server - name: dev1, platform: windows 2003 web edition, .net framework 1 SQL Server - name: dev2, platform: windows 2003 enterprise, .net framework 1 Workstation - name: dev3, platform: windows xp pro sp1, visual studio 2003 pro, .net framework Will reporti...more >>

Now I met this question: Our project need us must write a driver to retrive data from file but not from database to form a report. That is to say: I want retrive data from a text file to form a reporting service. How did I ? ...more >>

Is it possible to access report properties in embedded code? An earlier post was looking to set the visible property of a table column depending on the "RenderFormat" of the current output. I am also interested in doing this and began playing in the embedded code window with code similar to.. ...more >>

Hi I'm installing RS Dev Ed. on my WinXp SP1 machine. At the end of the setup project I get this error. Error 1920. Service 'ReportServer' (ReportServer) failed to start. Verify that you have sufficient privileges to start system services. I'm in the Adminitrators group. I also tried wit...more >>

Can I do a check if a field name exists like in an expression: iif(Fields!Time_Month.Value,,) iif(Exists(Fields!Time_Month.Value,,))...more >>

This is my first report. I used VS.NET 2003 wizard to create the report, which consisted of a very simple select query report. When I switch to preview tab in IDE, I am getting the following error. Processing Errors: An error has occurred during report processing. Cannot create a connecttio...more >>

I'm trying to use dates. And sometimes I'll call a query with month, = and sometimes by year. Sometimes if I run the mdx query for month I'll get fields, = Fields!Time_Year.Value and Fields!Time_Month.Value But if I do year, I'll just get Fields!Time_Year.Value. When I try to = write an e...more >>

Hi, is there a way to show labels and value to data point in a pie chart? I'm able to show the value, and i am able to show the label. But I want to show the two. ex: a pie chart of departement, I want the point labels show DEPT1 : 500,2 DEPT2: 200 ECT... thanks francis ...more >>

Hi, this is a pretty vague post but hopefully someone will be able to help. I've recently experienced some problems where the charts wouldn't render at all and the standard IE broken image X would display. Refreshing the page doesn't help and neither does reopening the report. I have a feeli...more >>

When trying to Deploy from my workstation (XP Pro) to the Win Server 2003 which is hosting both the Reports Web site and the SQL Server installation where the ReportServer database is loccated I get the following error: Deploying to http://localhost/ReportServer?%2fRepReport Error rsReportSe...more >>

Will the table header row not print on the last page if the only output for that page is the table footer row? This seems to be that case in my report, but I would like the table header row to also print. Can this be done? ...more >>

Hi, How can I display the report description on the report itself? Have been looking over the books online but can't find the answer there. Maybe its not supported? regards, ...more >>

Hi, I need an application that displays reports, and prompts the user for the parameter values. I have used the GetReportParameters() to retrieve the list of parameters. However, i could not find a way to get the available values when the parameter is of a list type. For example a countr...more >>