1. lingaiah T
  2. PowerBuilder
  3. Saturday, 4 June 2022 18:24 PM UTC

Dear Team,

In powerbuilder 2021, or any older version, Can you have a Dynamic reports like Crystal reports?

 

Miguel Leeuwe Accepted Answer Pending Moderation
  1. Sunday, 5 June 2022 14:06 PM UTC
  2. PowerBuilder
  3. # 1

Crystal Report Viewer:

https://www.google.com/url?q=https%3A%2F%2Fcommunity.appeon.com%2Findex.php%2Fqna%2Fq-a%2Fhow-to-incorporate-crystal-report-viewer&sa=D&sntz=1&usg=AOvVaw1q4yZ4z1dtYMqx1KXi1Dmk

NOTES:

- I even got this working also for 64 bit pb executables and powerserver.

- All of the VS code of my example needs thorough revision and adaptation to your database and needs. It's the ruins I had to build my solution upon.

- It's a PAIN to distribute the ActiveX to clients. You have to build an installer that registers everything correctly.

- Avoid Crystal Reports if you can. You can only have one version of the runtime installed on a client. If any other company uses crystal reports on your customer's pc and they use a different version, your version for your application will stop working and you'll have to recompile and redistribute or come to an agreement with the other company working for your customer on using the same runtime versions.

- I'm passing the DB user and password to a C# function in an unencrypted way. This should be avoided. The user can be passed, but the password shouldn't. The C# solution can simply use any predefined user for viewing crystal reports and you can still filter the report by user, since you DO pass that one.

 

regards

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Saturday, 4 June 2022 18:54 PM UTC
  2. PowerBuilder
  3. # 2

Hi Lingaiah;

   There are a number of options...for example:

  • Use Appeon's InfoMaker product to dynamically produce reports. IM reports are actually a DataWindow so your PB App can dynamically pick them up "on the fly" & run them.
  • You could imbed Crystal Reports inside your PB App.
  • You could use PB's "Dynamic DataWindow" feature to build ad-hoc reports.
  • You could use the new built-in Web Browser control to like to other reporting services (ie Google Graphs).

HTH

Regards... Chris 

Comment
  1. mike S
  2. Sunday, 5 June 2022 01:08 AM UTC
I'm not sure if they are still selling this, but: https://www.reporting-studio.net/EN/reporting-studio/embedded-bi.html
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.