Updating the schema programatically when using DataSets

[Former Member]

Hi,

We are generating reports using dynamically created DataSets where the schema may change sometimes (new fields/new tables). Is there a possibiliy to "link" the report to a new schema (xsd file) programatically? Similar to the function "Verify Database" in the designer. I've read the Report Application Server (RAS) allows to change reports programatically. But all examples with RAS are web applications. We are needing this functionality within a WinForms desktop application (fat client).

Thanks in advance!

Chris

[Former Member · Accepted solution]

Hi,

Have you checked the samples [here|https://boc.sdn.sap.com/node/6197] or [here|https://boc.sdn.sap.com/node/10959].

Does that help?

Regards,

AG.

[Former Member · Accepted solution]

Hi, Christian;

Just to expand on AG's reply -

It's not possible to change the schema that an existing report is based on.

Instead, you could use the RAS engine to create the report at runtime. See the second link mentioned, Creating a report with RAS.

Regards,

Jonathan

[Former Member]

Thank you for the very quick answers!

All the tutorials and sample code only deal with web sites. Is this just a limitation of the samples or can RAS only be used in a web environment?

Regards,

Chris

[Former Member]

The samples show how to use our sdks as an example and I believe it should not matter if it is a web or windows application.

Have you tried using them in windows app. and are you getting any errors?

Thanks,

AG.

[Former Member]

Hi, Chris;

RAS was designer for, and is only supported in a Web environment. It can be used within a Windows based application, but I don't think we have any samples for that.

Regards,

Jonathan