Can I Count Rows From a Filtered Data Band in a Cross-Tab?

[Tom7]

Hi All

I'm wondering if I can do this? I have a Data Source that selects all rows from a table in a database, I then have a Data Band on the report that filters the results from my Data Source according to whether or not the item's creation date falls in between two dates (variables called startDate and endDate) that the user picks.

In my cross-tab I want to set the value of my summary tab to be a count of all the rows in my filtered data band, but setting the Data Summary to Count and the value to DataBandName, DataSourceName.columnID gives me an error:
System.Exception was unhandled
Message="C:\Users\Tom\AppData\Local\Temp\czzpoqzq.0.vb(161,0) : error BC30205: End of statement expected."

but if I only use DataSourceName.columnID then I am getting a count of ALL rows in the table, not just the ones filtered by creation date.

and the way the report is to be designed means I cannot change the datasource SQL to only select back the rows I want

Any one got any help?

[Tom7]

Not to worry, just after posting this, I found the filter option on the cross-tab

[Andrew]

Ok!