Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: CrystalChris
- Order by date
-
Count Distinct (Per day) IP Addresses for a date range
Hi, I am looking for some help to create a mysql query to get the distinct (per day) count of ip addresses a link has been clicked for a date range. Lets say my IP address clicks on the same link 5 times every day during January 2012 using the same ip address. There would be 155 (5*31) records...- CrystalChris
- Thread
- Replies: 1
- Forum: MySQL
-
Slow Performing Report
Below is the final solution: SELECT CPINFO.REFVAL, CPINFO.ADDRESS, CPINFO.EHAREATM, CPINFO.TRADEAS, XIREC.REFVAL as REFVAL2, XIVISIT.XIVTYPE, XIVISIT.DATEVISIT, XIVISIT.VOFF, XIACTION.XIACT, CNOFFICER.NAME FROM (((CPINFO INNER JOIN XIREC ON CPINFO.KEYVAL = XIREC.MDKEYVAL) INNER...- CrystalChris
- Post #6
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Slow Performing Report
Thanks for both your input on this. I've tried the minus command. However, it brings back records that have a letter type (XIACTION.XIACT='LETT1'). I managed to resolve the problem by using the NOT IN command. Thanks Chris- CrystalChris
- Post #4
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Slow Performing Report
Hi, I've developed a report in Crystal Reports XI which will list the records in Command 1 which are not in Command 2. The problem that I'm facing is the report takes forever to load. However, if I do the same query in Microsoft Access it loads within 10 seconds. Command 1 SELECT...- CrystalChris
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 2 Data Access
