Search results for query: *

Ok we've found a solution. Thanks for your help SynapseVampire. Solution: The order by clause table in the Access database was blank and those formulas that were applied to certain sections were trying to reference this table thus causing the data to not appear. Why this would only happen to...

But now that you mention it, when the report is run it usually shows in the CRViewer how many records it was able to return, however it shows zero. I wonder how is it that I am able to browse field Data and see the data yet the report thinks there were no records returned and the Grand Total...

T-SQL statement works fine. I can get it from the VB via a break point, c/p into SQL Query Analyzer and run it and this is the recordset I get back and this is what I see when I browse each field in the report. It is definitely getting a recordset back. Group01: ''...

Btw, New Page Before option is set for Details section where formulas are being applied. When I put the word set I mean it's been checked. Sorry.

previous({AccessTable.LELEC_election_dt}) = {AccessTable.LELEC_election_dt} I think this line is saying that if the previous row's election date value equals the current row's election date then it returns true otherwise false. This was created by a previous developer who is no longer with the...

(For the record I did go through at least the first 80 solutions before posting this here. If there is a duplicate then please point me to it. I'm desperate!!!) Ok Layout of Report is... Report Header - Suppressed, no fields within content area Page Header A - Subreport that displays county...