CR XI and Access Queries

[rjoubert]

Using CR XI Developer, VB.NET, and MS Access

I have a report that I have based on a query developed in MS Access. The report runs fine through the CR interface, but when I run it through my VB.NET app, it errors out. The error relates to the record selection formula...seemingly it cannot access the values in the query fields.

I have several other reports that utilize the same Access database, and I'm using the same VB.NET code to run these other reports...they all run just fine. The only difference is that the other reports are based on Access tables, not queries.

Can anyone offer any help?

 

[rjoubert]

Additional info...

I've removed the record selection formula (and a couple of conditional formatting formulas) and tried to run the report through my VB.NET app. This time there is no error, but there's also no data. I am passing the data to the report through VB.NET, which again, works for my other reports.

 

[rjoubert]

More info...

I created a table from this query and changed my report to use the table instead of the query, but it didn't change a thing. I still get no data, and when I reintroduce the record selection formula, I get that error again. I have verified that my VB.NET is retrieving the data from the database and that there is data.

 

[rjoubert]

Please disregard this issue...it seems that when I pulled my report into my VB.NET project, it must've been corrupted somehow. After I deleted it from my project and readded a few times, it finally worked.

I'm surprised this isn't in the CR XI technical documentation anywhere...