crosstab and date/time
Hi,
I try to use a dbCrossView (D5Ent, FR3.04) and have the following problem:
the datasource is a query in the main program with the following SQL statement:
SELECT InsDate, Category, Count(InsDate) from DB1
GROUP BY InsDate, Category
(InsDate is DateTime, Category is String)
The CrossView should display the Count() against the Date and the category.
So far, so good. Unfortunately the DBCrossView seems to have a problem with the InsDate values. When executing the report I get the error "illegal variant type cast".
Has anyone an idea how I can prevent this error?
Thanks!
I try to use a dbCrossView (D5Ent, FR3.04) and have the following problem:
the datasource is a query in the main program with the following SQL statement:
SELECT InsDate, Category, Count(InsDate) from DB1
GROUP BY InsDate, Category
(InsDate is DateTime, Category is String)
The CrossView should display the Count() against the Date and the category.
So far, so good. Unfortunately the DBCrossView seems to have a problem with the InsDate values. When executing the report I get the error "illegal variant type cast".
Has anyone an idea how I can prevent this error?
Thanks!