It appears that the client is obsessed with charts.

Cramming too much information in one page/one chart will be often counter-productive.

If the intent is to analyze the trend in faults, there...

Have you tried a column chart instead of the line chart?

A column chart does not need two points - unlike the line chart.

I see that TKD-BB's suggestion is a sound one.

But, if you want to go with your way, have you tried adding a parameter to the Summary report?

You can define a...

Hi,

Here is an alternative to Boolean type.

Use the data type Integer with available values 0 and 1.

Label Value

Open 1

History...

What kind of report is this?

Can you create a summary report and sub-reports with fewer rows?

It seems that a report with 10000 rows is very difficult to read and...

Just curious. .

In your target, are you storing date in a numeric field?

What was the reasoning behind this decision? Why not store in in a datetime field?

Was it done for...

Lenard,

I think, this is not the way relational tables or SQL are intended to be used.

Here is a quote from the article you referred:

"What we want is the first item...

If you do not care about the values in CADD and CScore, you can use this query:

Select CName, max(CADD),max(CScore) from Customerdetails

group by CName;

Note : You can use any group function -...

Hi Tom,

Sorry, I do not have any expertise in SQL server to offer any suggestion.

But I am just curious about the vendor selling this product.

Are you at liberty to mention...

KARE4VB,

You mentioned : Quote

By the way, I realize the second example would not return all the records in a one to many relationship, but for the sake of argument assume...

Hi Stuart (stubob),

I agree with you. Pre-calculation makes sense. This calculation is done only once and it is a time-saver. (If you do not pre-calculate, the same time-consuming calculations and...

Hi,

Here is an addendum:

In my previous post, I meant storing hours in a separate column with a different data type (float or real or whatever) - not as datetime.

Thanks

RA

Hi Karl,

I am glad you could solve the problem. Here is some thought:

Perhaps it is not the best way to store the number of hours. You will be better off...

cfeisel,

Thanks for updating us on your solution.

More often than not, the members ignore to inform the group after they find a solution to their problem. I appreciate your post.

Just thought...