convert report to infopath form

I would like to convert an access report or form to an infopath form with all
the layout. I know it has to be done with XML-export and some
transformations, but i do not know the single steps or how to transform... If
anyone could please tell me the necessary steps? Thank you.

Carsten

Hello Carsten,

Based onmy scope, there is no official method to convert an access report
to an infopath form directly because they have different presentation
method.

Usually you could use the XML file exported from the report as a data
source or you could use Access as data source directly:

When you design a form based on an existing XML document, Microsoft Office
InfoPath 2003 creates a data source based on the information in your .xml
file. The more detailed your XML document is, the more detailed the
resulting data source will be.

1. On the File menu, click Design a Form.

2. In the Design a Form task pane, click New from XML Document or Schema.

Also, you may consider to develop your own programs to transform the XML
file exported from Access to the XML file for inforpath form. However, it
might be a little complex.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------
| Thread-Topic: convert report to infopath form
| thread-index: AcV/Rcy+maboc9lLQMqT9sTVijzcvA==
| X-WBNR-Posting-Host: 84.131.15.185
| From: =?Utf-8?B?emFncm9tc2tp?=
| Subject: convert report to infopath form
| Date: Sat, 2 Jul 2005 13:37:01 -0700
| Lines: 6
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.reports
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.access.reports:33443
| X-Tomcat-NG: microsoft.public.access.reports
|
| I would like to convert an access report or form to an infopath form with
all
| the layout. I know it has to be done with XML-export and some
| transformations, but i do not know the single steps or how to
transform... If
| anyone could please tell me the necessary steps? Thank you.
|
| Carsten
|

Hello Peter,
that there is no direct/official way to convert and that it has to be done
with XML-export i already wrote in starting this thread... But how? My
problem are very many ready layouted reports, which has to be exported to
infopath to fill out that inquiries manually. Especially the layout should be
shown like before.

I hope there is someone out there who has a concrete solution which might
show me the required steps.

Carsten


"Peter Yang [MSFT]" wrote:

Hello Carsten,

Based onmy scope, there is no official method to convert an access report
to an infopath form directly because they have different presentation
method.

Usually you could use the XML file exported from the report as a data
source or you could use Access as data source directly:

When you design a form based on an existing XML document, Microsoft Office
InfoPath 2003 creates a data source based on the information in your .xml
file. The more detailed your XML document is, the more detailed the
resulting data source will be.

1. On the File menu, click Design a Form.

2. In the Design a Form task pane, click New from XML Document or Schema.

Also, you may consider to develop your own programs to transform the XML
file exported from Access to the XML file for inforpath form. However, it
might be a little complex.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------
| Thread-Topic: convert report to infopath form
| thread-index: AcV/Rcy+maboc9lLQMqT9sTVijzcvA==
| X-WBNR-Posting-Host: 84.131.15.185
| From: =?Utf-8?B?emFncm9tc2tp?=
| Subject: convert report to infopath form
| Date: Sat, 2 Jul 2005 13:37:01 -0700
| Lines: 6
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.reports
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.access.reports:33443
| X-Tomcat-NG: microsoft.public.access.reports
|
| I would like to convert an access report or form to an infopath form with
all
| the layout. I know it has to be done with XML-export and some
| transformations, but i do not know the single steps or how to
transform... If
| anyone could please tell me the necessary steps? Thank you.
|
| Carsten
|

Hello Carsten,

This issue may require a bit more in depth attention and may fall under the
umbrella of Advisory Services. Microsoft now offers short-term and
proactive assistance for specific planning, design, development or
assistance with installing, deploying, and general "how to" advice via
telephone. For more information:

http://support.microsoft.com/default...dvisoryservice

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------
| Thread-Topic: convert report to infopath form
| thread-index: AcWAZOHY9B0wD3mWRKiKPgpxfjDk0Q==
| X-WBNR-Posting-Host: 84.131.13.132
| From: =?Utf-8?B?emFncm9tc2tp?=
| References:

| Subject: convert report to infopath form
| Date: Sun, 3 Jul 2005 23:52:02 -0700
| Lines: 89
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.reports
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.access.reports:33476
| X-Tomcat-NG: microsoft.public.access.reports
|
| Hello Peter,
| that there is no direct/official way to convert and that it has to be
done
| with XML-export i already wrote in starting this thread... But how? My
| problem are very many ready layouted reports, which has to be exported to
| infopath to fill out that inquiries manually. Especially the layout
should be
| shown like before.
|
| I hope there is someone out there who has a concrete solution which might
| show me the required steps.
|
| Carsten
|
|
| "Peter Yang [MSFT]" wrote:
|
| Hello Carsten,
|
| Based onmy scope, there is no official method to convert an access
report
| to an infopath form directly because they have different presentation
| method.
|
| Usually you could use the XML file exported from the report as a data
| source or you could use Access as data source directly:
|
| When you design a form based on an existing XML document, Microsoft
Office
| InfoPath 2003 creates a data source based on the information in your
.xml
| file. The more detailed your XML document is, the more detailed the
| resulting data source will be.
|
| 1. On the File menu, click Design a Form.
|
| 2. In the Design a Form task pane, click New from XML Document or
Schema.
|
| Also, you may consider to develop your own programs to transform the
XML
| file exported from Access to the XML file for inforpath form. However,
it
| might be a little complex.
|
| Best Regards,
|
| Peter Yang
| MCSE2000/2003, MCSA, MCDBA
| Microsoft Online Partner Support
|
| When responding to posts, please "Reply to Group" via your newsreader
so
| that others may learn and benefit from your issue.
|
| ================================================== ===
|
|
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
|
|
| --------------------
| | Thread-Topic: convert report to infopath form
| | thread-index: AcV/Rcy+maboc9lLQMqT9sTVijzcvA==
| | X-WBNR-Posting-Host: 84.131.15.185
| | From: =?Utf-8?B?emFncm9tc2tp?=
| | Subject: convert report to infopath form
| | Date: Sat, 2 Jul 2005 13:37:01 -0700
| | Lines: 6
| | Message-ID:
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | charset="Utf-8"
| | Content-Transfer-Encoding: 7bit
| | X-Newsreader: Microsoft CDO for Windows 2000
| | Content-Class: urn:content-classes:message
| | Importance: normal
| | Priority: normal
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| | Newsgroups: microsoft.public.access.reports
| | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.access.reports:33443
| | X-Tomcat-NG: microsoft.public.access.reports
| |
| | I would like to convert an access report or form to an infopath form
with
| all
| | the layout. I know it has to be done with XML-export and some
| | transformations, but i do not know the single steps or how to
| transform... If
| | anyone could please tell me the necessary steps? Thank you.
| |
| | Carsten
| |
|
|
|