June 26, 2009 at 2:54 am
Hi,
I have a data set that brings back 100 rows.
I want a text box (or anything that will do the trick) to display the total cost value based on the id - both of these values are returned in the data set.
So... The data set looks like this.
ID Cost
1 234.54
2 123.45
3 12.45
4 344.54
I want to be able to configure a text box that says show the value of [Cost] based on the supplied ID (either manually or based on the value in another control - I don't mind how it works).
This may seem a strange way of doing things but I have various reasons for wanting to do it like this.
To me it is a simple issue, but I can't get it to work.
Any guru's out there?!
Cheers guys,
Joe
June 26, 2009 at 8:20 am
I'm not sure I understand what you want to do. Can you post an example of what your current report looks like and then what you want it to do?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 28, 2009 at 6:38 am
I don't understand why the ID is important. Do you want a total based on a subset of the data returned.
June 29, 2009 at 1:50 am
Hi guys,
Sorry for not being clear...
What I am trying to do is bring back a data set (currently:- id, totalcost) and load the values on to a report that is formatted like so...
ID Cost
1 234.45 2 45.54 3 45.55 etc...
8 34.56 9 34.45 10 56.66 etc...
1 to 7 goes along the first row and then so on until 175 is reached (this is an RFM Analysis report if you've used them before).
I'm fairly new to ssrs and decided that the best way for me to achieve this would be to create 175 text boxes for each of total cost records and assign a value to them where id = 1, 2, 3, etc. I couoldn't get my head around it any other way.
I have included the current report we use in Excel to help illustrate what I am trying to achieve. It's how I actually reference and use the data that I can't work out. .
Any help much appreciated...
Thanks,
Joe
June 29, 2009 at 8:11 am
By looking at your Excel worksheet as sample, I think the matrix(ssrs2005) is more suitable to what you are trying to achieve.
http://www.simple-talk.com/sql/sql-server-2005/advanced-matrix-reporting-techniques/
There is a tablix in SSRS 2008 that I have not used.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply