I have a Dataset with: Company, Depot, Account, Year Period, Ethical, Glaxo, Drug, Surgical, General, PI, Misc, Phone, PostCode, CustomerName, DepotName, SalesMan, Salesman Number, Drug, General, Status.
I have used Visual Studio to create a report. In design view i have created two tables.The first table contains:
Account, CustomerName, Phone, DepotName, SalesMan, Salesman Number, Depot, PostCode.
I have created a second table above using the fields: Account, CustomerName, DepotName, SalesMan, Salesman Number, Depot, PostCode.
So in essense when the report is run the Account details will be shown first and then the Sales Details will be shown below.
What is happening when i run the report is that the Account Details in the first table are appearing multiple times as opposed to only once.
I assume this is due to the number of periods and year in the Sales fields.
Can anyone suggest a solution to enable me to view the Account details per Sales in a report.