how to create a reportMl file

[mar]

To everybody who has resolved this problem:

To create a reportML file from an Access report or table I have followed the instructions suggested by Microsoft Help; in particular I have executed the following procedures in a VBA module:
<VBA>
Const sPath = "C:\Program Files\MSDNTrain\2657\Practices\Mod09\"

Public Function EsportaReportML()
Application.ExportXML acExportReport, "Books", sPath & "Books.xml", sPath & "Books.xsd", , , , 32
End Function

Public Function EsportaReportMLbis()
Application.ExportXML acExportTable, "Books", sPath & "Books.xml", sPath & "BooksSchema.xsd", , , , acPersistReportML
End Function
</VBA>
I have worked with Access2003, but I haven't seen any report file created (I expected books_report.xml file).

Thank you for your help
mar

[PEB]

Hi,

When you start one of those function what happens? Is there any message for error?

From where do you start them?

Have a nice day!

:)

[mar]

When I start this funcion, in a standard module of a database format Access 2000 (using Access2003), I doesn't get any error message.
File Books.xml are correctly exportated and schema file are created, but I don't see ReportML file. I don't know where and how I ought to see it.
Searching in all c: disk I don't get any file with format ObjectName_report.xml, as described in Microsoft Online Help, due to flag 32 or acPersistReportML.
What have I to get, really?

By by
mar

Hi,

When you start one of those function what happens? Is there any message for error?

From where do you start them?

Have a nice day!

:)

[PEB]

Hi,

In the documentation I don't see nothing about Reports:

The ExportXML method allows developers to export XML data, schemas, and presentation information from Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), Microsoft SQL Server 6.5 or later, or the Microsoft Jet database engine.

expression.ExportXML(ObjectType, DataSource, DataTarget, SchemaTarget, PresentationTarget, ImageTarget, Encoding, OtherFlags, FilterCriteria, AdditionalData)
expression Required. An expression that returns an Application object.

ObjectType Required AcExportXMLObjectType. The type of AccessObject object to export.

AcExportXMLObjectType can be one of these AcExportXMLObjectType constants:
acExportForm
acExportFunction
acExportQuery
acExportReport
acExportServerView
acExportStoredProcedure
acExportTable

DataSource Required String. The name of the AccessObject object to export. The default is the currently open object of the type specified by the ObjectType argument.

DataTarget Optional String. The file name and path for the exported data. If this argument is omitted, data is not exported.

SchemaTarget Optional String. The file name and path for the exported schema information. If this argument is omitted, schema information is not exported to a separate XML file.

PresentationTarget Optional String. The file name and path for the exported presentation information. If this argument is omitted, presentation information is not exported.

ImageTarget Optional String. The path for exported images. If this argument is omitted, images are not exported.

Encoding Optional AcExportXMLEncoding. The text encoding to use for the exported XML.

AcExportXMLEncoding can be one of these AcExportXMLEncoding constants:
acUTF16
acUTF8 default

OtherFlags Optional AcExportXMLOtherFlags. A bit mask that specifies other behaviors associated with exporting to XML. The following table describes the behavior that results from specific values; values can be added to specify a combination of behaviors.

AcExportXMLOtherFlags can be one of these AcExportXMLOtherFlags constants:
acEmbedSchema Writes schema information into the document specified by the DataTarget argument; this value takes precedence over the SchemaTarget argument.
acExcludePrimaryKeyAndIndexes Does not export primary key and index schema properties.
acLiveReportSource Creates a live link to a remote Microsoft SQL Server 2000 database. Valid only when you are exporting reports that are bound to a Microsoft SQL Server 2000 database.
acPersistReportML Persists the exported object's ReportML information.
acRunFromServer Creates an Active Server Pages (ASP) wrapper; otherwise, default is an HTML wrapper. Applies only when you are exporting reports.

FilterCriteria Optional String. Specifies a subset of records to be exported.

AdditionalData Optional AdditionalData. Specifies additional tables to export. This argument is ignored if the OtherFlags argument is set to acLiveReportSource.

Remarks
Although the DataTarget, SchemaTarget, and PresentationTarget arguments are all optional, at least one must be specified when you are using this method. When the ExportXML method is called from within an AccessObject object, the default behavior is to overwrite any existing files specified in any of the arguments.

Example

[mar]

Hello,
thank you for your interest in my problem.

From link
http://office.microsoft.com/en-us/assistance/HA010345461033.aspx?mode=print
is possible to read:

<TEXT>Saving a ReportML file

The ReportML file (ObjectName_report.xml) is created by default when you export a datasheet, form, or report to XML by using the ExportML method.

You can save or persist a ReportML file by setting the appropriate value in the Otherflags option in the ExportXML method. For example, the following sample code exports the table called Customers in the current database as XML. The data and schema are exported as separate files, and the schema is in XSD format. The value 32 after the OtherFlags flag persists the ReportML file:

ExportXML _
ObjectType:=acExportTable, _
DataSource:="Customers", _
DataTarget:="Customers.xml", _
SchemaTarget:="CustomersSchema.xml", _
OtherFlags:="32"

For more information on the ExportXML method, see .
<\TEXT>

Probably OtherFlags:="32" isn't correct because OtherFlags, as written in .NET help must be a numeric long. Also in text you sent is foreseen OtherFlags.
I have tried also with value 16 for this parameter, as indicated in Help in the Microsoft Visual Basic Editor, but the risult is the same: nothing.


But what means "persist"? What has to happen?
I would like to create a ReportML file, as I have seen in MOC 2657: Programming in Access 2002

Bye bye
mar

Hi,

In the documentation I don't see nothing about Reports:

The ExportXML method allows developers to export XML data, schemas, and presentation information from Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), Microsoft SQL Server 6.5 or later, or the Microsoft Jet database engine.

expression.ExportXML(ObjectType, DataSource, DataTarget, SchemaTarget, PresentationTarget, ImageTarget, Encoding, OtherFlags, FilterCriteria, AdditionalData)
expression Required. An expression that returns an Application object.

ObjectType Required AcExportXMLObjectType. The type of AccessObject object to export.

AcExportXMLObjectType can be one of these AcExportXMLObjectType constants:
acExportForm
acExportFunction
acExportQuery
acExportReport
acExportServerView
acExportStoredProcedure
acExportTable

DataSource Required String. The name of the AccessObject object to export. The default is the currently open object of the type specified by the ObjectType argument.

DataTarget Optional String. The file name and path for the exported data. If this argument is omitted, data is not exported.

SchemaTarget Optional String. The file name and path for the exported schema information. If this argument is omitted, schema information is not exported to a separate XML file.

PresentationTarget Optional String. The file name and path for the exported presentation information. If this argument is omitted, presentation information is not exported.

ImageTarget Optional String. The path for exported images. If this argument is omitted, images are not exported.

Encoding Optional AcExportXMLEncoding. The text encoding to use for the exported XML.

AcExportXMLEncoding can be one of these AcExportXMLEncoding constants:
acUTF16
acUTF8 default

OtherFlags Optional AcExportXMLOtherFlags. A bit mask that specifies other behaviors associated with exporting to XML. The following table describes the behavior that results from specific values; values can be added to specify a combination of behaviors.

AcExportXMLOtherFlags can be one of these AcExportXMLOtherFlags constants:
acEmbedSchema Writes schema information into the document specified by the DataTarget argument; this value takes precedence over the SchemaTarget argument.
acExcludePrimaryKeyAndIndexes Does not export primary key and index schema properties.
acLiveReportSource Creates a live link to a remote Microsoft SQL Server 2000 database. Valid only when you are exporting reports that are bound to a Microsoft SQL Server 2000 database.
acPersistReportML Persists the exported object's ReportML information.
acRunFromServer Creates an Active Server Pages (ASP) wrapper; otherwise, default is an HTML wrapper. Applies only when you are exporting reports.

FilterCriteria Optional String. Specifies a subset of records to be exported.

AdditionalData Optional AdditionalData. Specifies additional tables to export. This argument is ignored if the OtherFlags argument is set to acLiveReportSource.

Remarks
Although the DataTarget, SchemaTarget, and PresentationTarget arguments are all optional, at least one must be specified when you are using this method. When the ExportXML method is called from within an AccessObject object, the default behavior is to overwrite any existing files specified in any of the arguments.

Example

[PEB]

Hi,

Reelly I can't understand what they mean under:

acPersistReportML Persists the exported object's ReportML information.

It's very simple very short and tells nearby nothing!

And they don't give exemples! ;(

:)

[mar]

Thank you all the same for your attention

mar

Hi,

Reelly I can't understand what they mean under:

acPersistReportML Persists the exported object's ReportML information.

It's very simple very short and tells nearby nothing!

And they don't give exemples! ;(

:)