Create report with multiple tables?

Tiwaz

Hi guys
I use Report builder and I wish to create Price list report.
I have a table Pricelist with fields: Type, No., Price, Date
Type can be Item, Resource and Fixed Asset.
For example:
I want to display data about Item such as description or shelf no. from table Item and then, below, all prices for that item from my pricelist.
Then, after that, data from Resource and then all prices from pricelist etc etc.
How can this be done? I have no idea how to link one to many tables in report and how to group it in layout
Thanks in advance

mohana_cse06

report 801, 90 etc

RockWithNAV

Tiwaj,

Report 206 Sales Invoice is the one in all Reports. You will find almost everything there OR any common login you are searching for. Even RDLC Layout of Report 206 will guide you all niggle concepts of RDLC reporting that you need to implement.

mohana_cse06

please check some standard reports which used multiple tables and how they linked with DataItemLink property

Tiwaz

Could you please tell my which report can I check out

mohana_cse06

report 801, 90 etc

RockWithNAV

Tiwaj,

Report 206 Sales Invoice is the one in all Reports. You will find almost everything there OR any common login you are searching for. Even RDLC Layout of Report 206 will guide you all niggle concepts of RDLC reporting that you need to implement.