If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

I keep getting an 'Error in Formula' message that states that the 'field name is not known' in the record selection when I open my report a second time from my VB6 application. It works perfectly the first time, but fails every time after that until I close and re-open my application.

1.- Check if there's a blank or space or CR or NL at the end of the RecordSelectionFormula
Obviously you are not going to 'see' it, but if there's one, then the cursor is going to be in the next line of the code
Delete it and test

2.- If point 1 is not the solution then export the rpt to Report Definition format, Destination DiskFile
Please, post attach the created txt file

JG

... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

No, it works every time without issue when I run it from the IDE. This is only when my VB6 application calls it. It works the first time, but fails every time after that. I looked at every variable I could find to see if there was a difference between the 1st and 2nd calls and couldn't find one.

Some things to do (almost sure that you already did) :
1 If the design time database is different from run time database then change database location and execute 'verify database'
2 Remove the subreport and test

JG

... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

I hate to resurrect this thread, but I'm still struggling with this issue. It appears that ANY report which has a sub-report is throwing this error. If I delete the sub-report then it works, but I need some of these sub-reports so I really need to make it work. I have saved off and re-imported the subreports and converted the DB drivers and everything and still no luck. The reports work without issue from the IDE but my application throws the error above after more than 1 open of the report.

* The Perfect Platform for Game Developers: Android
Developing rich, high performance Android games from the ground up is a daunting task. Intel has provided Android developers with a number of tools that can be leveraged by Android game developers.

* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.