Hi all, I would like to create a report like this: row# check# description value subtotal (per check#) 1 FIN2 food for pets 5.00 5.00 2 FIN4 vacation 35.00 35.00 3 FIN8 ...more >>

hi, Is there a way to have a default Font for my reports (2005)? Because now I always have to change them from Arial 10 to Times New Roman 12... Thanks a lot in advance, Pieter ...more >>

Is there a way to pass multiple rows to a function on the report? Here's what I'm trying to do: I have field in my detail section, "customer", that is shows each customer: [Customer1] [Customer2] [Customer3] [etc.] I'd like to wrap these into a single field at the parent...more >>

I have a list that is grouped on OrganizationID. Inside the list is a chart that uses a different dataset. The chart dataset should be passed the OrganizationID from the list grouping. I''ve tried a few different things, but always end up with build errors, such as: Error 1 [rsAggregateInG...more >>

How do I wrap columns on a page once that column is filled up...for example, a list of names, when it reaches the end of the page, and there is still room to the right it wraps and starts over. FirstName PhoneNumber FirstName PhoneNumber Andrew 800-555-1212 ...more >>

I have a report that has detail and a group. I have it set to hide the detail and toggle on the group. When the report first renders, I get the six groups spread over 3 pages. That is 2 lines per page. When I toggle the hidden data, the result still only takes up 3 pages. How can I get t...more >>

Error comes up when I try to deploy RS to my web server, "The underlying connection was closed: Could not establish trust relationship with remote server." Web server has valid certificate, and I'm using https in my connection. OverwriteDataSources: True TargetFolder: Reports TargetServe...more >>

Hello, I am just starting out with reporting services (I have a book which I have not read yet). I have copied the basic part of a report to a new report for learning purposes. This contains a parameter which I included in the query. This works so far. But the original report also inclu...more >>

"Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope." is not quite as obvious as it should be for its length. If Group2 wants to reference something in Group1 does that mean that Group1 must be a parent group of Group2 o...more >>

Suppose the dataset comes back looking like (the counts are arbitrarilly chosen) PO #___Dept___PO Total___PO Line__Colour___ Item Count 1 Dept1 $100 1 Red 5 1 Dept1 $100 2 Green 10 1 Dept1 $100 3 Blue 15 2 ...more >>

I'm trying to pass multivalue string from report to stored procedure. I want to avoid using UDF function since it will complicate my logic ( i have several paramaters, dunamic SQL etc) Can anyone tell me if I selected Value1 Value2 Value3 from my multi-value combo box, how the parameter strin...more >>

Hi. Are there any docs on delivering reports over the internet, particularly on managing the security side of things? We want to open up some reports to clients of ours and are wondering if there are any particular issues to consider. Thanks. -- McGeeky http://mcgeeky.blogspot.com ...more >>

Hi all. Can someone please respond to the question that I posted? Whether it can or cannot be done? Thank you. -- -RB :)...more >>

Hi Every Time I Try To Start Any Type Of Report Server Project Out Of Visual Studio 2005 I Get The Following Error: Could not load file or assembly 'Microsoft.ReportingServices.Designer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=87987fvf5665vv91' or one of its dependencies. The sys...more >>

Hi, Currently creating a report, which contains several sub-reports held in separate rectangles. Some of the rectangles need page breaks to be displayed after the rectangle. I have checked the ‘Insert After Rectangle’ page break attribute on the General tab. The problem is I want ...more >>

I ran into an interesting problem (bug?) in the Report Designer with RS 2005. I am using the new Row_Number ranking function in my SQL Statement. The Data tab of the designer does not like this syntax and throws an error "Must Declare the Scaler Variable @Year" The report still renders correc...more >>

Sorry for the accounting type question, how do you get a negative inside brackets instead of with a "-"? E.g. (200.25) instead of -200.25 Any help would be appreciated....more >>

I have a text box, I do not want to wrap the text in it. I have set CanGrow property to False. It still wraps the field. What else needs to be done not to wrap the text. Thanks...more >>

Is there a way for a custom assembly to access the current HttpContext of a report? We'd like to be able to access the Request.ServerVariables collection to pull a value that will help determine what is displayed on a report. We recently had a problem with a custom assembly accessing an en...more >>

Hi all, I am trying to create a report that runs against a stored procudure. The stored proc (following this) uses cursors to select data into a temporary table, which is then returned to the report. My problem is that the report isn't picking up on this returned data. When I run the proc i...more >>

Into Analysis Services Tutorial cube i defined the Internet Sales Details dimension (rolap storage) and a drill-through action ( Internet Sales Details colums to be displayed) following the tutorial steps. Now browsing the cube with Cube Browser everything goes fine and the drillthrough works ...more >>