Member Avatar for saravanarajan

Hi everybody!
i working in oracle 10g forms and reports.... i try to use this crystal report in 10g...
please help me how to call this report in application.....my application server remote how will i call the remote server in my crystal report.......please help me....

thank you,
saravanarajan...

  • 2 Contributors
  • 4 Replies
  • 99 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by saravanarajan

Dani AI

Generated

Short summary and practical plan for the same problem raised (Oracle Forms 10g, remote app server) with the pointer from about connectivity.

Best practical approach: host the Crystal runtime on a Windows web/middleware server (or use a Crystal/BusinessObjects report server). Put the .rpt files on that server or in the web app, and have the middleware load the report, set the Oracle DB logon and parameters, then render (PDF/HTML) and stream the result to the user. From Oracle Forms you don't need to embed the report engine — call the middleware URL from the form (for web-deployed Forms use web.show_document to open the report URL in the user browser). This keeps the Forms/Forms server separate from Crystal and avoids OS/driver mismatches.

Important implementation points:

  • The machine running Crystal must have an Oracle client (matching bitness) or a working connection method to the database; use a TNS alias or EZCONNECT as appropriate.
  • Make sure the Crystal runtime version supports your .rpt files and that any subreports have their logons set the same way.
  • Pass parameters securely (POST or short-lived tokens); avoid sending DB credentials in query strings.
  • If you have BusinessObjects/Crystal Server available, prefer its viewer/API — it already handles deployment, security, scheduling, and URLs for embedding.

Quick troubleshooting checklist to try now:

  • Run the .rpt from Crystal Designer on the proposed report host using the same DB connection.
  • Create a tiny web page on the report host that opens and exports the .rpt to PDF; verify it works from a browser on the client machine.
  • From Forms, invoke that URL (confirm network/firewall allows it).
  • If you see blank pages or login prompts, re-check Oracle client, connection strings, and subreport logons.

These steps keep the architecture clean (Forms = UI/transaction, Crystal = reporting) and solve the “remote server / path” issue by exposing reports over HTTP from a server that actually runs the Crystal engine.

Recommended Answers

All 4 Replies

Member Avatar for Ramy Mahrous

Crystal report reports can be merged in your application (You don't need to call report from Server) just connect to your Oracle DB Server.

Member Avatar for saravanarajan

Hi....
Thak you for your valid reply, i did connect DB server, but i m using oracle forms10g
its hosted application server, where should i specify path in my form, how can i call report,
please explain detail....I hope you please help me

Member Avatar for saravanarajan

Thank you!!
I will try that one

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.