This field name is not known in Preview

[Former Member]

When trying to preview data in Main Report Preview i get error "This field name is not known." without specifying which filed is that.

[former_member11696 · Accepted solution]

Click on Database, Verify and it should pop up a mapping dialog box and show you which one.

Don

[Former Member · Accepted solution]

well i tried verify database, it says The database is up to date.

[former_member11696 · Accepted solution]

Hi Peter,

Do you have any reserved characters in your formula field names: ? { } @

Can you attach the report, I'll run it through my test app and see if I can find it.

Rename the rpt file to *.txt and then use Advanced editor to attach it.

Don

[Former Member · Accepted solution]

Hello, i am attaching the report files as requested.

tiskDokladAP_SVK.vb.zip

tiskDokladAP_SVK.txt.zip

[former_member183750]

If this is an app using datasets see:

Troubleshooting Issues with VS .NET Datasets and Crystal Reports - Business Intelligence (BusinessOb...

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter

[ido_millet]

Peter, the rpt contains 2 formulas that start with:

Formula = ....

That is an odd expression.  Try to simply remove the 'Formula= ' portion.

[Former Member]

and where can i do that?

[ido_millet]

In the formula editor.

[former_member11696]

Hi Guys,

I do get an error loading saved data due to a missing UFL in CR Designer.

Also, I see there are multiple SQL Expressions and a table in the subreport that is not linked which is not allowed.

Try linking the one table in the subreport and see if that works.

And is it a dataset so you should move it to another subreport and in the Report Options uncheck Use Server for speed...

In my app the report never loads so there is something very strange with it... Likely though it's because of the SQL Expression and I don't have the database, App is trying to resolve/verify the database/tables/fields usind in the SQL Expressions.

Likely the error is due to one of your SQL Expressions is not valid so you need to confirm each one.

Don