We created a BOL form using the standard Epicor V10 Crystal Report form.
We added a subreport that looks up some information (ShipHead) using the ODBC MS SQL Driver V11.
I can run the report just fine from the Crystal Reports Developer/Designer. However, when I try to run it from our V10.1.500.11 server - I get prompted for my ODBC username and password - but then I get two erorrs that look like they are related to the Crystal XML.
Has anyone seen this before? Any suggestions?
Not having done any reports in E10 yet a silly question, but are sub reports supported?
Mr. Simon: Yes subreports are supported for both Crystal AND SSRS.
Epicor essentially hands off a DataSet to the reporting tool and then lets the reporting software do its work. So Epicor does NOT limit or constrain the reporting tool (for the most part - their Crystal runtime compile may not be standard Crystal - I am not sure - but the SSRS is pure Microsoft).
DaveO
Similar happened to my OpenEdge E9, it was client failed to access \EpicorData for the xml.
You will need to open the report in Crystal Reports. Click on Database from the menu bar, then Set Datasource Location. Find the report you just ran and Update it. Do this for subreport as well.
Thanks Dave
