Any help is appreciated, I'm using CR11 and SQLserver 2000. I have 2 different tables of simliar data: Table1 is a list of webtrends hits:
date, visits
And there's only 1 row for each day. Table2 has 2 fields, Date, and title, but there can be multiple rows for each day.
What's the best way to link and group these tables, so that I can have a report that shows each day, and then the "visits" from the web trends report, and the count of titles from table2. This gives me the number of webtrends hits and on the same row, the number of titles found on that day. It's a comparison type report, and I would put a line chart plotting the 2 totals over time to show a relationship. (more hits = more titles)
Any help is greatly appreciated, thanks!
date, visits
And there's only 1 row for each day. Table2 has 2 fields, Date, and title, but there can be multiple rows for each day.
What's the best way to link and group these tables, so that I can have a report that shows each day, and then the "visits" from the web trends report, and the count of titles from table2. This gives me the number of webtrends hits and on the same row, the number of titles found on that day. It's a comparison type report, and I would put a line chart plotting the 2 totals over time to show a relationship. (more hits = more titles)
Any help is greatly appreciated, thanks!