New report style error: Response is not well-formed XML

Epicor ERP 10
1

All –

I am trying to customize (we want to add revision comments) the Job Traveler and am getting a “Response is not well-formed XML” message. Here is what I have done (based on the Epicor Education course, which uses a different example):

  1. Created (and saved) a new data definition
    a. Added the PartRev table
    b. Created a JobPartPartRev relationship
    i. Parent Table: JobPart
    ii. Key: PK_JobPart
    iii. Relation Type: Output
    iv. Child Table: PartRev
    v. Relationship fields are:
    1. Company = Company
    2. PartNum = PartNum
    3. RevisionNum = RevisionNum
  2. Created (and saved) a new report style
    a. Linked new report style to new data definition
    b. Output location: Database
  3. Downloaded SSRS Report style and opened Traveler.rdl in Report Builder
    a. Moved the RevisionNum field over to the left
    b. Added RevDescription field immediately to the right of Revision
    c. Changed the Value property of RevDescription so that the expression is now: =Fields!RevDescription.Value
    d. Changed the size (which shouldn’t matter)
  4. Saved everything and exited Report Builder
  5. Back in Epicor, from the Actions menu selected Upload SSRS Report
  6. Navigated to the directory where I saved it in the first place
  7. Got the “Response is not well-formed XML” error.

I do not get the XML error if I simply download the report and re-upload it without making any changes, so it’s definitely something within the report itself…

Thanks for whatever information you can provide.

—sam

2

Mr. Sam: I will assume you are V10 and using SSRS.

Make sure the Report Style “Output Location” is set to “Database”. If you are running Crystal then it should be set to “XML” or “blank” (depending on Epicor Version).

The other suggestion I would like to offer is:
I have run across this phenomemon a couple times. When using SSRS Report Builder I have been unable to preview the job traveler using report builder. However, if i run the job traveler from Epicor is prints fine. I was able to work around the issue by changing the Report Builder to “Print Layout” BEFORE previewing. Then the Traveler printed fine.

Hope one of these suggestions helps,
DaveO

3

Dave -

Thanks for the information.

The report style Output Location is “Database.”

Will look at the preview functionality in Report Builder. This is all very new to me…

Thanks again.

—sam

4

Are you using 10.1? Before adding a new table and relationship did you explore the existing links and columns available?