Post reply

Drop down issue

  • July 13, 2012 at 2:11 pm

    #264210

    Hi friends,

    I have report in which I have start date and end date( as parameters) based on these dates "Team " values is populated.....and if there is no team for that values ..it shows empty dropdown.where I am showing "NULL" in team for no records and when ran showing " No records"

    but according to the requirement : even if team is empty( show no values ) in dropdown

    the report should run and show "no records message"

    is that possible?

    If so how can we do that.

  • July 13, 2012 at 4:06 pm

    #1512733

    No one replied.So, want to ask if we can "Pass blank parameter " and run report???

  • July 16, 2012 at 2:49 am

    #1512962

    in your drop down list dataset query, add new UNION query for no team value

    SELECT ........

    <Original Query>

    UNION

    SELECT 'No Team'

    FROM tblTeam

    WHERE <No team criteria>

    this will add extra value to your drop down list -- 'No Team'

    now, add code to your main query IF condition that, if 'No Team' is selected then display message else run your original query.

    Hope this helps you.

  • July 16, 2012 at 8:20 am

    #1513098

    requirement is that when they select the dates out of range and team should be blank and when ran should show "No records"

    and my parameters are cascading.

  • July 16, 2012 at 8:28 am

    #1513101

    ok...

    you could do like this,

    1. in your date dataset and add CASE statement like if there is a team then it's fine else display as 'No Team'

    2. in your team dataset it's gonna a run for 'No Team' which not gonna have any results, set your tables 'NoRows' property to display 'No Records found message'.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply