locked
CRM Report Problem RRS feed

  • Question

  • I have a Simple Report in VS 2005. The problem is that I must add two parameters - Region and City. As you all expect they are connected in a one to many relationship. I did a DataSet for all Regions and put a MultiValue Parameter. The second DataSet for all Cities is the problem. I must filter it by the chosen Region. And every time the use choose another Region from the first ComboBox, I must filter the City ComboBox again... 

    I am very greatful for any information and help posted.

    Thank you.

    Monday, May 31, 2010 2:41 PM

Answers

  • Move the cities to the database with a table name like cities. Then fill your cities dataset with a query like:

    Select * from cities where region = @region.

    @region on this case would be the parameter where the user selects the regions.

    In the @City parameter configure it to get the values from a query and chose your cities dataset.

    Regards,
    Damian Sinay.

    Wednesday, June 2, 2010 5:10 AM