Forum Replies Created

Viewing 15 posts - 136 through 150 (of 183 total)

  • RE: ChangeLegend

    No Worries .. Here is what I found was helpful

    http://technet.microsoft.com/en-us/library/dd239321.aspx

  • RE: Display data

    Really helpful.

    Thank you

  • RE: Display data

    Guess I should be a little more clear.

    I am looking to count the # of requests for the current month and last 3 months(Static).

    But don't know how COALesce will be...

  • RE: Display data

    Thanks a lot.

    I shall try that.

  • RE: Last 3 months data

    Thanks.

  • RE: CAST in AND statement

    Thank you. Got it working...

    SELECTCAST(

    CASE WHEN someCondition THEN someValue

    ELSE otherValue

    END

    as CHAR(11)

    )

    FROMtableExpression

  • RE: COUNT

    Yes so I am counting RoundTables in ('1', N/A') AND IsVideo in ('1', 'N/A').

    and then need to do an and between these to counts.

    Should I separately count and then add...

  • RE: COUNT

    Let me mention that when I individually execute without the AND part for each , I get the count as 3 and 8 respectively .

    I am expecting the answer...

  • RE: Show Subreport

    Can you explain how? , in this case

  • RE: Sum of Counts

    No worried .. I figured it out:)

    Its

    Sum (case .... then 1 else 0)

  • RE: Multiple Cases

    I get this error : 'SUM' is not a recognized built-in function name.

  • RE: Sorting in stack column

    Thaks you for the reply.

    My query shows the sequence in correct order in management studio. However , its in report builder that it messes up.

    P.S : I am trying to...

  • RE: Hyperlink

    No worries, I figured out. I was seeting up actions on text box . Setting up actions on the text made the difference...

  • RE: Display secondary axis values on right of chart

    On the Chart look for Series Properties ( You can see when you right click on a bar /Column), select Axes and Chart Area and you will be able to...

  • RE: 3-D bar chart report help

    Say if you are displaying Production for each month select Months in Category groups and production as values for bars.

    You will be able to see seperate months......

Viewing 15 posts - 136 through 150 (of 183 total)