Post reply

Deleting Rows after Lookup

  • August 26, 2016 at 8:45 am

    #320922

    Hi,

    First, thanks to all members supporting here.

    I have two datasets

    1)ds1

    2)ds2

    I am using ds1 as datasourse in my tablix1 to show the record. In tablix1 I am doing lookup to get addional data from ds2

    ds1 : Name, Age, Gender

    ds2 : Game, score , Name

    Final Tablix1 should be:

    Name, Age,Gender, Game, Score

    The lookup is on Name to Name from both datasets.

    If the lookup returns blank subject, I wish to delete that entire row in tablix1.

    I am not able to figure out how would I delete the rows from the tablix1 after the lookup or before it on the dataset level.

    Any Clues/help is much appreciated,

    Thanks,

    Shruthy

  • August 26, 2016 at 10:35 am

    #1897865

    Can you not create a dataset inner joining ds1 to ds2 (ie the tables in those ds) to eliminate the records with no join? Then you just use that ds as the source for the report.

  • August 30, 2016 at 2:43 am

    #1898237

    Hi,

    Thanks for the reply. Its bit late replying back.

    My one source comes from excel file and another from SQL server.

    How can I inner join the data sources???

    Thanks,

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

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