# Inspection Report --- FINALLY!

**URL:** <https://www.epiusers.help/t/inspection-report-finally/83769>\
**Category:** Epicor ERP 10\
**Tags:** e10\
**Created:** [October 20, 2021, 9:09pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769 "2021-10-20T21:09:28Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![eeaquino](https://www.epiusers.help/user_avatar/www.epiusers.help/eeaquino/32/47134_2.png) [@eeaquino](https://www.epiusers.help/u/eeaquino)\
**Post date:** [April 10, 2024, 1:10pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/21 "2024-04-10T13:10:57Z")

</div>

No, ended up upgrading to 10.2.700 to get it to work.

---

<div class="post-metadata">

**Author:** ![jenjen7981](https://www.epiusers.help/user_avatar/www.epiusers.help/jenjen7981/32/82044_2.png) [@jenjen7981](https://www.epiusers.help/u/jenjen7981)\
**Post date:** [April 10, 2024, 1:11pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/22 "2024-04-10T13:11:48Z")

</div>

Ok, that’s on my very soon to do list. I may need to make that happen now. Thank you for the response.

---

<div class="post-metadata">

**Author:** ![jenjen7981](https://www.epiusers.help/user_avatar/www.epiusers.help/jenjen7981/32/82044_2.png) [@jenjen7981](https://www.epiusers.help/u/jenjen7981)\
**Post date:** [April 11, 2024, 3:42pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/23 "2024-04-11T15:42:11Z")

</div>

I have a .700 server. Can you share how you used the PreStartConfig. What temp-table do you use or do you use the Paramerters? Then I get an error that SysRowID is not of same variable type when using Char01.

---

<div class="post-metadata">

**Author:** ![jenjen7981](https://www.epiusers.help/user_avatar/www.epiusers.help/jenjen7981/32/82044_2.png) [@jenjen7981](https://www.epiusers.help/u/jenjen7981)\
**Post date:** [April 11, 2024, 3:42pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/24 "2024-04-11T15:42:59Z")

</div>

![image](https://www.epiusers.help/uploads/default/original/3X/e/8/e8691368ef1fc2a745ff8cb1c3aa4fe016cccc6a.png)

---

<div class="post-metadata">

**Author:** ![jkane](https://www.epiusers.help/user_avatar/www.epiusers.help/jkane/32/57624_2.png) [@jkane](https://www.epiusers.help/u/jkane)\
**Post date:** [April 11, 2024, 4:02pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/25 "2024-04-11T16:02:46Z")

</div>

You are adding the GUID of the InspResults table to all of the other tables so you can join them on the fields to ensure you are getting the correct rows.

You need to convert the GUID to a string.

---

<div class="post-metadata">

**Author:** ![jkane](https://www.epiusers.help/user_avatar/www.epiusers.help/jkane/32/57624_2.png) [@jkane](https://www.epiusers.help/u/jkane)\
**Post date:** [April 11, 2024, 6:34pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/27 "2024-04-11T18:34:47Z")

</div>

It is under the configurationRuntimeDS, see screenshot.

![image](https://www.epiusers.help/uploads/default/original/3X/8/f/8f92e5e8b0acd8f3201f7e4b2a10d15dbefdb507.png)

---

<div class="post-metadata">

**Author:** ![jenjen7981](https://www.epiusers.help/user_avatar/www.epiusers.help/jenjen7981/32/82044_2.png) [@jenjen7981](https://www.epiusers.help/u/jenjen7981)\
**Post date:** [April 11, 2024, 6:35pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/28 "2024-04-11T18:35:01Z")

</div>

Getting there!

![image](https://www.epiusers.help/uploads/default/original/3X/2/6/269134b0dd8ff153e905c4bb00ae93a6067e489e.png)

---

<div class="post-metadata">

**Author:** ![jenjen7981](https://www.epiusers.help/user_avatar/www.epiusers.help/jenjen7981/32/82044_2.png) [@jenjen7981](https://www.epiusers.help/u/jenjen7981)\
**Post date:** [April 11, 2024, 6:35pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/29 "2024-04-11T18:35:32Z")

</div>

I ended up converting to string and am past that error. I don’t have the InspResults table available in the ConfigRuntime.PreStartConfiguration though. I’ve never used a BPM that way. I can’t just grab it from InspResults or am I missing something for that? It’s AMAZING that you figured this out and shared, it’s terrible it’s not offered out of the box.

---

<div class="post-metadata">

**Author:** ![jkane](https://www.epiusers.help/user_avatar/www.epiusers.help/jkane/32/57624_2.png) [@jkane](https://www.epiusers.help/u/jkane)\
**Post date:** [April 11, 2024, 6:38pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/30 "2024-04-11T18:38:42Z")

</div>

See my screenshot 3 posts above. You want configurationRuntimeDSPcValueGrpRow.RelatedToSysRowID

---

<div class="post-metadata">

**Author:** ![jenjen7981](https://www.epiusers.help/user_avatar/www.epiusers.help/jenjen7981/32/82044_2.png) [@jenjen7981](https://www.epiusers.help/u/jenjen7981)\
**Post date:** [April 11, 2024, 6:48pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/31 "2024-04-11T18:48:25Z")

</div>

Correct?

 ![image](https://www.epiusers.help/uploads/default/original/3X/0/e/0e2a992d8bd7ecac753b1f848d63d7ca0a18e90f.png)

Then the DD…

 ![image](https://www.epiusers.help/uploads/default/original/3X/d/8/d8f4fd0f71a1652c106ba3f8ba107d40079b6439.png)

---

<div class="post-metadata">

**Author:** ![jkane](https://www.epiusers.help/user_avatar/www.epiusers.help/jkane/32/57624_2.png) [@jkane](https://www.epiusers.help/u/jkane)\
**Post date:** [April 11, 2024, 6:53pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/32 "2024-04-11T18:53:22Z")

</div>

You will want to remove the space in the first image, but other than that it looks correct.

---

<div class="post-metadata">

**Author:** ![jenjen7981](https://www.epiusers.help/user_avatar/www.epiusers.help/jenjen7981/32/82044_2.png) [@jenjen7981](https://www.epiusers.help/u/jenjen7981)\
**Post date:** [April 11, 2024, 7:35pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/34 "2024-04-11T19:35:46Z")

</div>

That was it! I don’t know how you spotted that space. Thank You…now on to the Report 🙂

---

<div class="post-metadata">

**Author:** ![jenjen7981](https://www.epiusers.help/user_avatar/www.epiusers.help/jenjen7981/32/82044_2.png) [@jenjen7981](https://www.epiusers.help/u/jenjen7981)\
**Post date:** [April 11, 2024, 8:17pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/35 "2024-04-11T20:17:37Z")

</div>

What SQL Version is this? Thanks!

---

<div class="post-metadata">

**Author:** ![jenjen7981](https://www.epiusers.help/user_avatar/www.epiusers.help/jenjen7981/32/82044_2.png) [@jenjen7981](https://www.epiusers.help/u/jenjen7981)\
**Post date:** [April 11, 2024, 8:18pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/36 "2024-04-11T20:18:11Z")

</div>

For the .rdl. I thought my comment was below the post for it.

---

<div class="post-metadata">

**Author:** ![jkane](https://www.epiusers.help/user_avatar/www.epiusers.help/jkane/32/57624_2.png) [@jkane](https://www.epiusers.help/u/jkane)\
**Post date:** [April 11, 2024, 8:37pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/37 "2024-04-11T20:37:34Z")

</div>

I used Report Builder to make it, don’t know which one.

---

<div class="post-metadata">

**Author:** ![jenjen7981](https://www.epiusers.help/user_avatar/www.epiusers.help/jenjen7981/32/82044_2.png) [@jenjen7981](https://www.epiusers.help/u/jenjen7981)\
**Post date:** [April 12, 2024, 5:34pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/38 "2024-04-12T17:34:59Z")

</div>

I’ve never had a shared report given to me. I was thinking it mattered on the version of SQL. Thanks, I’m building my report now.

---

<div class="post-metadata">

**Author:** ![jenjen7981](https://www.epiusers.help/user_avatar/www.epiusers.help/jenjen7981/32/82044_2.png) [@jenjen7981](https://www.epiusers.help/u/jenjen7981)\
**Post date:** [April 12, 2024, 6:42pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/39 "2024-04-12T18:42:22Z")

</div>

Thanks John again for your help. The .rdl doesn’t match the RDD. Was there a change. I seen you said no one should have to endure re-creating and I’m trying but am now having an issue with that part of it. Happy Friday!

---

<div class="post-metadata">

**Author:** ![klincecum](https://www.epiusers.help/user_avatar/www.epiusers.help/klincecum/32/100137_2.png) [@klincecum](https://www.epiusers.help/u/klincecum)\
**Post date:** [April 12, 2024, 6:44pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/40 "2024-04-12T18:44:41Z")

</div>

> [@jenjen7981](#):
>
> I don’t know how you spotted that space

![speak season 6 GIF](https://media2.giphy.com/media/3o6MblX3f2qq6lcw7u/giphy.webp?cid=e90edba3z4kvx8jot7ei1ledmnyq2wn2gtuoo3ufnx1jcg29&ep=v1_gifs_search&rid=giphy.webp&ct=g)

---

<div class="post-metadata">

**Author:** ![jkane](https://www.epiusers.help/user_avatar/www.epiusers.help/jkane/32/57624_2.png) [@jkane](https://www.epiusers.help/u/jkane)\
**Post date:** [April 12, 2024, 6:55pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/41 "2024-04-12T18:55:44Z")

</div>

I posted the RDD and all of the BAQs near the beginning of the post.

---

<div class="post-metadata">

**Author:** ![jenjen7981](https://www.epiusers.help/user_avatar/www.epiusers.help/jenjen7981/32/82044_2.png) [@jenjen7981](https://www.epiusers.help/u/jenjen7981)\
**Post date:** [April 12, 2024, 7:04pm UTC](https://www.epiusers.help/t/inspection-report-finally/83769/42 "2024-04-12T19:04:51Z")

</div>

Darn, I know. Mine don’t match when I import and create report. Would you be willing to help me offline. Is that something you can do.

[Previous page](https://www.epiusers.help/t/inspection-report-finally/83769.md?page=1)

[Next page](https://www.epiusers.help/t/inspection-report-finally/83769.md?page=3)
