Last post Apr 01, 2011 08:50 AM by jonathandp01
Apr 01, 2011 08:50 AM|jonathandp01|LINK
Hi, I wanna display multiple values in a report and be able to select some kind of values. I'm going to explain it better.I have this:
Department Type Projects Time Off Money
dep 1 C1 20 30 500
dep 1 C2 30 65 900
dep 1 C1 40 90 300
dep 2 C1 90 30 250
dep 2 C4 85 63 462
That's an example of my table in SQL SERVER.So I do a query to sum the proyects.
SELECT Department, SUM(Projects), SUM(Time Off), SUM(Money)
What I do is, I have a DropDownList showing all the departments so ppl will be able to chose which dep wanna see and I have code in VB to give the DS with the data that I want to show in the report.
PROBLEM: SUMs values goes in the top part of the chart and DepNom goes on the low part wich is X in design mode.When I chose I can see what I want except for the part that it shows on the X the name of the Department and the columns have colors and in the leyend
it goes the name of my columns in this case "Projects", "Time Off" and "Money"
I NEED: I need to show the name of this columns on the lower part, each column with respective name.I've tried to move the data values but thats the only way where i can get the values in the form that I need.Is it possible to do that?