1. radha rani
  2. PowerBuilder
  3. Tuesday, 10 April 2018 14:17 PM UTC

Hi,

 

I want to create a report in powerbuilder using sql 2012

In which firstly i want to create a form in which user fills their entry and these enteries on the click of save gets saved in the database and then on the click of another button whole enteries which is saved in database gets fetched from the database and present infront of us as a report .

Please help me how to start it and prepare it.

Mail:radharani10jan@gmail.com

 

Govinda Lopez @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 10 April 2018 22:28 PM UTC
  2. PowerBuilder
  3. # 1

Hi Radharani,

 

I would also recommend you to read through our Getting Started document. In it you will find a tutorial and all the basic knowledge you may need to start coding. It is applicable to previous versions of PowerBuilder in most of it's content.

 

I hope this helps!

 

Regards,

Comment
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Tuesday, 10 April 2018 17:24 PM UTC
  2. PowerBuilder
  3. # 2

I have coded this exact requirement.

First off, if coded generically - allows the user to add other reports to the list of reports accessible to the user - then this is a project, not a task - its a complex piece of code.

If this is simply for a specific set of reports, it's much easier.
 

For the simple case, create two tabpages.

1.  Tabpage 1:  You need to create an INPUT page for the users. This is where they will enter the parameters.

     - create a datawindow that accepts the user input. These values will be the  parameters for the report. 

     - you can SAVE these values into a database, and auto-populate the fields the next time this user returns to this INPUT screen for this report, if you wish.

 

2.  When the user clicks on Tabpage 2, they go to the REPORT page, and the report is processed and displayed to the user.

     - The values in the dw of tabpg 1 are used to populate the fields of the report DW in tabpg 2.

     - Retrieve the data, and put the DW into Print Preview mode so the report will display in the manner in which it will print.

     - Options on this page should include the ability to SAVE AS or PRINT.

 

Good Luck,

Olan

Comment
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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.