🔥 Demo -> Json And [XML now too!] to SSRS Dataset (Updated!)

[Mark_Wonsil]

If we’re working with DataSets, could we also use the built-in methods for XML usage?

DataSet Class (System.Data) | Microsoft Learn

Like .GetXml

DataSet.GetXml Method (System.Data) | Microsoft Learn

[CSmith (Clint Smith)]

This is a separate DB server not Epicor’s but I thought I would share the example as there are many things you can do inside of SSRS reports. Agree about the SSRS service principal access permissions. This was created to provide automated subscription as it will use 0 as the default for the prior month and year in the stored procedure.

I thank you for your constant reminders; they are very much appreciated!

[klincecum (Kevin Lincecum)]

@Mark_Wonsil

If we’re working with DataSets, could we also use the built-in methods for XML usage?

Like from where?

@Mark_Wonsil

Like .GetXml

If you mean inside Epicor, sure, I didn’t use it because I wasn’t working with an actual “DataSet”, and I just wanted to play with the recursive function for making xml from json.

If I had pulled a real dataset, that could have just been pushed as is, or if it was a tableset, I could have used Ice.DatasetAdapter.ConvertToGenericDataset and serialized either.

---

If you are talking about inside the SSRS, yes, they should be available in VB with the proper namespace reference added.

[Mark_Wonsil]

The thought I had a few years ago (before the JSON revolution) was to use the WriteXml to serialize objects to be used later for testing in a test harness or automated testing for upgrades.