September 23, 2010 at 5:36 am
I have a dataset returning two date fields (A and D), and two money fields (B and C). I want A to be the category labels on the x-axis and B and C as my data items (i.e. two series). Date field D holds a date that's common to all the records. I've added this in as I want the chart's x-axis to start from this value, not the earliest value of A. Thought I could do this by placing something like "First(Dataset!D.Value)" in the Scale Minimum field in the x-axis tab of chart properties but it seems to ignore it and still place the starting x-axis category value as being the earliest value of A. Anyone got any ideas?
September 23, 2010 at 9:20 am
Hi,
The you use union operator in your query in datatab resolves your problem.
for instance here is the sample query based on your example
Select Col4, Col2, Col3 from table
Union
Select Col1, Col2, Col3 from table
union operator works on equal number of columns and data types. The result of ur query would be having 3 columns in total. first column would be having Col4 datavalue first and then Col1 data value next.
let me know if this helps!!
September 23, 2010 at 9:58 am
Understood. Thought there'd be a reporting services charting solution rather than a dataset query solution but I've got it to work using your method instead. Many thanks.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply