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!

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.