ADO.NET(XML)

[Former Member]

Hello all! can someone please help me?

I have a crystal report that was created using ado.net...i am trying to open it and it is showing a file path...

how do i open it using OLE DB?

thanks

[KennedyT21 · Accepted solution]

Hi Stephanie Saintil

check with these links

http://scn.sap.com/thread/3214033

http://scn.sap.com/thread/1921398

http://scn.sap.com/thread/1703947

http://www.beabetterbusiness.com/pdfs/knowledgebase/how-to-work-with-crystal-reports-in-sap-business...

Hope Helpful

Regards

Kennedy

[Former Member · Accepted solution]

Hi Stephanie Saintil,

If your report was created with ADO.net connection ,it will ask you for XML path which was created with Stored Procedure written for Report with help of SDK.

** To open the same report In OLE DB (ADO). All you need to do is to establish the connection with your SQL Server using OLE DB (ADO) and then choose the SP written for your report and you can connect your crystal report with database.

Caution : Some times Replacing a new connection with already existing connection ,you can lose your fields from report but you can again Drag and Drop the fields as you are using the same Stored Procedure but from a differnt way.

Ado.net : Creates XML first .

OLE DB (ADO) : Creates direct link with SP

Hope it will help you.

Thanks

Taruna

[Former Member]

Tengo el Mismo Problema, Pero No me da acceso acceso para buscar la conexion de ADO.NET o a lo mejor no se de que forma, por este mismo he tenido problemas de que forma puedo solucionar este problema , he intentando hacer lo que dicen con anterioridad pero no encuentro la manera exacta, le agradeceria su ayuda gracias.

[Former Member]

Thank you both, your input was really helpful

[KennedyT21]

Hi  Stephanie Saintil

Have you managed to do it.. if so pls close the tread by marking Correct and helpful answers

Regards

Kenney