I am using Crystal Version 8.5
Database is MS SQL
I do not have database access to create a stored proceedure or a temporary file.
The field look like this...
Hi. Using a SQL database I have a series of fields that are a comma delimited list of states. It is not a list of every state, just a list of states that qualify for a certain job category. I need to make a grouping on this state field so that I can count the number of people who do a job...
Unfortunatley, not really. They want to see the categories tiled across and then down on the page. They want the new totals for each category next to the cumulative totals.
Using Crystal 8.5 and a MS SQL database
I am trying to create a report that does a count of total number of jobs and a summary of the cost of the jobs. I need to have two columns for each category of jobs. One for the last week (or another parameter) and one that is all jobs since the begining...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.