Post reply

how to show description and deccription_id

  • February 6, 2013 at 2:31 am

    #269866

    Hi,

    I have two columns Id,id_desc

    i am creating a report using procedure,in SP i am calling id only

    while i creating a report in SSRS,i want show description only

    based on description the id send to SP and get the result

    Regards

    Arjun

  • February 6, 2013 at 2:44 am

    #1584810

    create a parameter, assign the available values section the query, assign the right columns to the right drop downs, then use the parameter in the stored proc.

    So two datasets, one which gets all ID's and descriptions, one which uses the proc and passes in the parameter.

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

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