I'm creating a report for our telemarketing team. What I'm trying to achieve is a very simple section which shows top line figures i.e total number of calls made, total number of customers. The Team receives data on a weekly basis. I would like this to use this reporting to review monthly and quarterly results based on the campaigns dates are selected.
I'm hoping the final result will look something like this. 01/03/2010 is selected from a list box
Total number of Customers : 3 (count distinct CompID)
Total Number of Calls : 7 (count CallID)
If nothing is selected from the CampaignstartDate we get
Total number of Customers : 6 (count distinct CompID)
Total Number of Calls : 14 (count CallID)
I'm able to achieve the above through adding the code to text boxes but the format doesn't look consistent with the rest of the report.as the data is then broken down through povit tables in a vertical line with graphs which indicate KPI's
