• J Livingston SQL (8/8/2012)


    Luis Cazares (8/7/2012)


    I'm not sure if there's a conflict of interests by posting the following but...

    If you're looking for a nice tool that can be easy for the execs to work with, you might try qlikview.

    It's not a replacement for SSRS, but it might be a nice tool.

    Hi Luis

    have you been actively involved in using qlikview?....its something I only yesterday started to research....my company reqs are exactly as you say..."easy for the execs".

    ...but is it hard to admin / set up so that it appears as being "easy to the execs" 🙂

    There are things that really suck in SSRS: Parameter layout is one that drives me mad. I have reports where the user can select an operator and operand(s)

    For example, the first param for a date report might be a choice of <, >, =, between

    When they select between they need to select a start date and end date, so I end up with operator, operand1 on 1 line and operand 2 on a second line.

    Similarly, if I have above and then want another parameter, I can't get the operator to start on new line without adding an empty parameter, which just confuses users,

    so instead of

    Operator1 Operand1.1 Operand1.2

    Operator2 Operand2.1

    I get:

    Operator1 Operand1.1

    Operand1.2 Operator2

    Operand2.1

    The whole thing about not be able to select which parameters don't cascade is a real pain. Having 7-8 parameters and having to wait for a postback after every single one sucks

    Regards

    Mark