Search results for query: *

Dear All (any help will be greatly appreciated) Database version: SQL 2000 I have created the following query which combines 2 tables containing multiple rows to the table CPCASE which holds unique records. SELECT C.SERNO, C.DOFF, C.REGNO, C.STATE, C.STATE_DATE, P.DESC1, SUM(CASE WHEN...

I have the following query that I have written for a database running on SQL 7. The query relies on the users inserting a specific string into a memo field within the application which is stored in a CHAR field in the database. What they enter is LRD dd/mm/yyyy unfortunately this...

The situation I have is that our end user system does not always correctly update the sequence number within a names table. We often experience the following; A user will add name details against the main case details screen within our system. This means that the name details are added to a...

I am trying to pass the following to the SQL v7 server IF CurrentDate > date(year(currentdate),04,01) then {CPCASE.DOFF} in date(year(currentdate),04,01) to date(year(currentdate)+1,03,31) else {CPCASE.DOFF} in date(year(currentdate)-1,04,01) to date(year(currentdate),03,31) {CPCASE.DOFF}...

Not sure if this is the right Forum for this but I'll put it out into the playing field anyway. I have been tasked with providing basic Crystal Reports training to about 5 supervisors within my department (it’s been highlighted by a consultant that no-body else really understands what I do with...

Is the above possible????? Lewis United Kingdom

Good Morning! I have an interesting query. I have to generate a report which will diplay 15 detail sections per page. I have created my report (v8.5 to SQL) so that only 15 lines are displayed per page but on the final page unless there are 15 sets of data I get a reduced number of sections...

I have created a report in v8.5 which runs on a grouped month. I have to use parameters for Jan - Dec that allows me to input the number of hours worked in each month. If I use a simple date range parameter linked with my table {table.DOFF} I can run the report as long as I only select full...

I have a created a report in v8.5 which uses Running Totals based on selection formulas. The report is created so that it is grouped by month, and then by week. The report contains about 34 Running Totals for each week, with the same number again for the months totals, and again for the...

I have got to calculate the difference between group subtotals to display as a monthly variance on the previous month. eg; sub totals variance period 1 5 period 2 10 5 period 3 7 -3 period 4 15...

I hope that somebody might be able to point me in the right direction... I am trying to create a report that will combine history (Table 1)and audit actions (Table 2)by time into a group. The first table contains information tracking a user through differnet locations. It holds info as to...

I would be greatful for any help on the following... I have to create a report which displays results of daily activity by employees, but also incorporates a calcluation based on the total number of hours worked in the month. Currently I have my report grouped by month and then by week. I...