Set the start of the x-axis on a chart from a dataset field

  • 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?

  • 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!!

  • 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