I have been trying to make chart like illustrated in ProductLineSales example. But, I cant figure out how and what data is been captured into it as sql command is very complicated (nor I am interested) to understand. I have some tables like, Messages, DeviceMessages and BranchMessages....You can have look at it in attached snapshot.
I just want to show chart (horizontal bars) showing me COUNT(Messages.MessageId) per day, that is COUNT(Messages.MessageId) on x-axis sorted in descending Messages.DateAndTime order on y-axis.....Can anyone please help me making this report?
I`ll be very thankful.....