Hi, I am trying to create two tables in my SSRS report. I have used 2 different packages with same parameters for the dataset creation.
While executing the dataset2 (manually from data tab in the designer), it works fine and gives me field results. But while executing from report (clicking the view report), the second table, which uses dataset2, is not returning anything, while the first table does.
Why is this behaviour? Please give me an idea.