I know this has probably been beaten to death, but I still have not found a way to use datetime in a matrix. I have a timestamp field with the value of datetime. I want to group by the date, not using the time. When I format the date, it still groups by the datetime, not the date only. I a...more >>

to be able to multiselect in a parameter? Is that possible'?? -- LUIS ESTEBAN VALENCIA MICROSOFT DCE 3. MIEMBRO ACTIVO DE ALIANZADEV ...more >>

I have a textbox that calculates a value that I use in other parts of my report via the ReportItems collection. I would like to send that value to a query as a parameter. Can I do that?...more >>

Hello, When I export a report of 1 page in Excel, the default name of the tab is the name of my report. BUT, when I export a report that has much of 1 page, I obtain "sheet1, sheet2 and sheet3" for the Excel tabs. It is possible to export my report with specific names for my Excel ta...more >>

Hi We are developing a custom toolbar with the export, zoom,find and previous/next page browsing functionalities. How can we go about developing the page browsing functionality? Thanks...more >>

I'm calling ListSecureMethods to verify the requirements for each of the methods. This call returns no errors but the object does not have any method names. Here is the code: Dim RS As New ProjectName.systemname.ReportingService RS.Credentials = New System.Net.NetworkCredential(sUserName, s...more >>

I have a "Jump to Report" issue. I have created a report that runs itself with new parameters when a cell is clicked on. It works great except that when it is run on the web, the "Jump to Report" has no access to the parameters. I need to be able to have the parameters visible so the users ...more >>

Hello, There are 3 groups in my table. The second and third group are hidden and can be drilled down. I have a code to set alternate color for backgroundcolor of each rows (the first group). The code is "= iif(RunningValue( Fields!uniqueID.Value, CountDistinct, Nothing) mod 2, "white", "yel...more >>

I have a query that returns rows like this: DUEDATE AMOUNT DAYSLATE 12/1/04 100 12 I have a text field that I want to include a sum of all rows that are more than X days late. Seems simple, yes? For the life of me I can't get iif to work inside my sum aggregate. Currently I ...more >>

Hello, I am a new SQL Reporting Services developer, and have a couple of newbie questions. 1) I understand that SQL Reporting Services (SRS) is free with every licensed copy of SQL Server 2000. I downloaded what appears to be an "evaluation" copy of SRS. How do you install / license SRS ...more >>

I have mistakenly deleted the rdl file from my client computer and I don't know how to restore it.it is still in the report server.is there a way to get it from report server? Thanks for you r help. ...more >>

Hi, I have started using Reporting Services only 2 weeks ago but I'm used to = working with reporting tools, such as Crystal Reports and Access. When I tried to use an IIF-function I noticed that it didn't work. = e.g.: "=3DIif(First(Fields!Region.Value, = "dataSetServicePartnerActivityDe...more >>

I have a report the gets the following data for each member in a report table format, this query takes parameters and returns about 20 records and each has the same information shown below. Name company title address phone email effective date However, instead of this data "snaking...more >>

I tried scheduling subscriptions last week and I did not receive any reports. At that, they did not show to have run. However, I ran the report physically from the web today, and then all of a sudden the subscriptions worked and I started getting a bunch of messages. Do I have to do somethi...more >>

Hi I want to create site map with quick access to all reports in my intranet. I have already static map without links, based on Catalog table and i want to expand its funcionality by adding dynamic links. Has someone already solved this problem? thx ...more >>

I am moving reporting services to a new server and I want to move the reports, file structure, and linked reports over as well. I have created a few parameterized base reports that I can simply re-deploy, but there are numerous linked reports - they run specific parameters on a scheduled basi...more >>

Each time I run a data-driven subscription, I recieve the following information ... "Processing: 0 processed of 1 total; 0 errors" ... The report runs fine manually and via a subscription, but not a data-driven subscription. I'm at a lost, where do I start to find this problem? -- ~Jack~...more >>

Hi, I need to know all the possible values that the "Subscription.Status" property can return ( I'm creating my own UI and all text has to be translated into another language ) Thanks, Antonio...more >>

Hi everyone, i'm trying to call a stored procedure that runs rs.exe from a DTS package,the package works perfectly giving me no errors but when i look at the results rs.exe has done nothing. If I call the stored procedure directly it works just fine rendering my pdf report on filesystem Any...more >>

I have a matrix report with a start date & end date parameter. when i run the query in the data payne eveything works fine. when i run the report in the preview pane, the matrix table returns the entire data in the database. same occurs when i add a table. what am i missing?? thanks in advance...more >>