Hello,

   I am using crystal 9 + ASP.Net(VB code behind). I am using two subreports in te main report and each of the subreprts are using two diffrent tables.When I am using repdoc.RecordSelectionFormula(repdoc is my report) I am gettign the following error. Anybody knows te reson, please post it.

Thanks
Ceema



Error in File C:\DOCUME~1\IBRA\ASPNET\LOCALS~1\Temp\temp_c4d395e 7-f3e8-4803-9828-929b40a74398.rpt: Error in formula <Record_Selection>. '{tmpForm7.SchoolID}=Ab1' This field name is not known.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: CrystalDecisions.CrystalReports.Engine.FormulaExce ption: Error in File C:\DOCUME~1\IBRA\ASPNET\LOCALS~1\Temp\temp_c4d395e 7-f3e8-4803-9828-929b40a74398.rpt: Error in formula <Record_Selection>. '{tmpForm7.SchoolID}=Ab1' This field name is not known.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[FormulaException: Error in File C:\DOCUME~1\IBRA\ASPNET\LOCALS~1\Temp\temp_c4d395e 7-f3e8-4803-9828-929b40a74398.rpt:
Error in formula <Record_Selection>.
'{tmpForm7.SchoolID}=Ab1'
This field name is not known.]
   .F(String  , EngineExceptionErrorID 
) +676
   .A(Int16 
, Int32 ) +537
   CrystalDecisions.CrystalReports.Engine.FormatEngin e.GetPage(PageRequestContext reqContext) +539
   CrystalDecisions.ReportSource.LocalReportSourceBas e.GetPage(PageRequestContext pageReqContext) +189
   CrystalDecisions.Web.ReportAgent.u(Boolean N) +164
   CrystalDecisions.Web.CrystalReportViewer.OnPreRend er(EventArgs e) +108
   System.Web.UI.Control.PreRenderRecursiveInternal() +62
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Page.ProcessRequestMain() +1489

Hi buddy,

I have faced the same issue.

My report was working fine with the database source in which I have designed it. Then we decided to use different database name. I was providing the database name through config file, once I changed this database name I started getting the same error as you mentioned.

I resolved this by setting the database location as we required while executing it.

for that open ur report, select Database Expert, then select SetLocation option then create new connection and choose the database you are expecting while executing the report.

See if this works for you.........

Just now I have registered into this forum , so this might be so late for you.

Regards
Swaps

Hi Swaps,

Thanks for your solution.

Regards
Bayzid.