Post reply

Drillthrough parameters didn''t appear in the report

  • August 28, 2007 at 11:29 pm

    #174480

    Hi all,

    I have created the ad-hoc report via Report Builder. I would like to define some parameters to my report, so I go to Report then select filter and double click at "Year" field which i would like it to be the parameter in my report. The problem is that it does not allow me to drillthrough to view the list of year in my data. When I run the report, the parameter appears in textbox which I have to fill the data myself. Is there anyway I could fix this kind of problem?

    Many thanks in advance.

  • August 29, 2007 at 9:43 am

    #730175

    You need to query the underlying table to retrieve the year and populate the listbox. So you create parameter, and then set its datasource to be the query SELECT DISTINCT YEAR FROM <tablename> in the properties of the parameter.

    Hope this helps.

  • August 30, 2007 at 5:06 am

    #730381

    Thanks, Richard

    Now I finally find the solution for this problem. As I'ved used an olap cube as the data source, when I performed Dimension processing, I have to define the "Interselection" of attribute's properties to be "DropDown". Therefore, when I use this cube to generate a model for Report Builder. The parameter can be drop down.

    Enjoy ur day

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

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