Power builder questions and answers power builder interview. Many powerbuilder developers have had this question in many forums and i thought it best to document the process we follow to save to pdf using ghostscript in powerbuilder applications. How to save datawindow as pdf on windows 7 64 bit sybase. Display pdf into a window reals powerbuilder howto.
Powerbuilder 12 save datawindow as excel stack overflow. I have been trying unsuccessfully to use the distill method to save as pdf. And if you happen to open a datawindow that retrieves a million record, youre screwed. Net, its serverside architecture, and ui technology, and put forward an innovative product roadmap that is being delivered in agile 612 month cycles. Choose add printer next choose local printer, uncheck automatically detect and install my plug and play printer next choose use the following port, select file. In the properties window go to the data export tab. It is not clear from your explanations wether you expect the datawindow to be empty prior to this action. Saveas pdf cannot support the colheading argument, for example, the. For how to use this method, refer to the section called export. In a script the properties you set in the datawindow painter are saved with the datawindow object and are used by default when your application runs, but for more control, specify the properties in a script before saving the datawindow object. This program will install the sybase datawindow ps printer which is used by the datawindow saveas pdf.
Important features for powerbuilder projects page 4. Download an existing pdf file from the appeon file server to the. But i found out that the excel format merely joins the data of all the nested reports and used the saveas facility of the datawindow. Are either of the other rendering methods distill using ghostscript or saving using xslfo faster than using nativepdf. Save the datawindow object, then select file save rows as, select pdf as the save as type, specify a file name, and click save. For example, if the date type specified in a datawindow is string, when you import a file.
You can export the data in a web datawindow in xml or xhtml to a string using the describe or getproperty method and the data. Creating the template data window child class gui application. Powerbuilder cloud app development simplified appeon. Our powerbuilder application generates a report by printing a datawindow as pdf file. The child datawindow expects a region value as a retrieval argument. Saving screen shot of our application windowform gui application download. Currently i suggest you work it around via using ghostscript to save pdf. Datawindow save as pdf problem solutions experts exchange. I can do it in pb 9 using ghostscript but the requirement is we do it in pb 6. I have just reused the codes in pdf exporting as it only creates a pdf file of the printout. Saving as pdf if you want your application to save a datawindow object in pdf format, the web server not the client must satisfy the requirements for ghostscript and postscript drivers described in saving data in pdf format. There are some validation that will happen as it is populated into teh database, so i need a process that will literally open the excel sheet in powerbuilder. I cant open it as an ole as it wont make it back into the sybase db that way.
Powerbuilder datawindow sql changes made easy, powerbuilder more datawindow mouseover effects. You might as well check if the datawindowchild has any rows in it and if it doesnt, redo the getchild and then repopulate the datawindowchild retrieve, rowscopy, etc. After you install pdf creator it will install a printer, use that printer to save the datawindow with the print function. I would really appreciate if someone could help me with step by step procedure with code to solve this issue.
For syntax to save the contents of graphs in datawindows and datastores, see saveas. Half of datawindow columns are displayed on page 1 of pdf and remaining columns are displayed on page 2. Sep 24, 2014 the report allows exporting to 2 formats. The datawindowchild object is used for accessing datawindow objects independently from datawindow functionality, and it inherits from the system structure object because it needs storage and autoinstantiation. Powerbuilder datawindow saveas easter egg debugging aid. Besides the functionality provided through the gateway module, aashtoware bridge management aashtoware bridge management is a bridge management system bms which incorporates dynamic, probabilistic models, and a detailed bridge database to predict maintenance and improvement needs, recommend optimal policies, and plan projects within budget. Getting and modifying the dataobject of a powerbuilders. How to save to pdf using ghostscript in powerbuilder. I have a grid datawindow with a picture in its background with dimensions of an a4 page and i would like to export both data and the picture as a single page pdf file. Another cause ive seen is mismatched powerbuilder dlls and pbds. What would you suggest as the best way to loop through all the columns. The distill method provides a robust solution that can save all types of datawindow objects on the windows platform.
We have been testing the nativepdf method using pdflib in pb 2019. Datawindow printing supported pb features for powerserver web. It copies rows 2 through 30 and columns 3 through 8 on the clipboard to the datawindow beginning in column 5. Method in datawindow reference and the section called saving as pdf using pdflib in users guide. I tried all the suggestions and code examples on the internet but nothing worked. For syntax to save objects in ole controls and ole storage, see saveas in powerscript reference. Regards, ken hi tobias, sorry but currently we still dont have a plan to fix it in pb 2019 ga. Hi everyone, can i convert a datawindow to pdf in pb 6. Save or restore source text verify and encrypt source text replacing object definitions compliance to ansi standards federal information processing standards fips flagger chained transactions and isolation levels identifier compliance to ansi standards sql standardstyle comments.
I used several combinations of the following commands but at most i got a 0sized pdf. The security setting under printer folder is not for setting pdf document. We have pb application which generates pdf files of datawindow via print functionality and with the help of acrobat pdf writer. Datawindow save as to pdf is a new feature of pb 9. Winapiregistry insert the adobe acrobat activex control ole control on the window. You can use it in a window to present an interactive display of data. In the save as window as shown in the following figure that displays at runtime, the end user sets the save as type to nativepdf. Ive looked every where but still i cant find how to set the pdf security directly. Datawindow saveas pdf i am using powerbuilder version 9.
Apr 02, 2004 datawindow saveas pdf fail i tried to save a datawindow as a pdf file for more than 3 days, but failed. The powerbuilder datawindow control is a container for datawindow objects in a powerbuilder application. Powerbuilder gotcha modify parent datawindow after a. Powerbuilder datawindow save as save datawindow data in different formats. I am able to save a file as a pdf when i do it on my own pc. Now that we planned to remove any dependency of external application printer like applications pdf writers, we are interested to generate pdf file with help of any plugable libraries and using the library api. But the pdf does not get created on other systems where i installed the compiled application. I am using the following command appi can save the datawindow in pdf file but i cannot be done in another new machine windows 8. For syntax to save objects in ole controls and ole storage, see saveas in the powerscript reference. Before printing a datawindow into a pdf, you must open the dataobject. Powerbuilder datawindow save as save datawindow data in. This document presents you with the necessary steps to do it. The result is a repeating value of every header column for.
Insertrow0 inserts a new row at the end appends the row and returns the number of the new inserted row. My approach on the entry form is switching the dataobject of the form datawindow and then sharing my main datawindow with it. Because you populate the child datawindow first, specifying a value for its retrieval argument, there is no need for powerbuilder to display the retrieval argument dialog box. In my pb code i tried using the following function. If you use saveas function, the pdf will not have the format that the datawindow shows. How to share the datawindow to inner datawindow of nested datawindow. The module which saves datawindow as pdf has been install on both xp as well as windows 7 64 bit. The distill method is used by default when you select save rows as from the file menu in the datawindow painter and select pdf as the file type, or when you use the saveas method with pdf. I want the entire datawindow to be fitted into single pdf width wise. For more about the deployment notes on pdflib, refer to the section called using the pdflib generator in application techniques. It is intended as a tutorial on the power builder, and commonly asked qestions in all interviews.
Functions for datawindowchild supported pb features for. It adds 29 rows to the datawindow with data in columns 5 through 10. How do i create a pdf in powerbuilder 2017 on my pc so it. But the problem with this is you still need to open the datawindow first before you can turn it off.
Find answers to saving a powerbuilder datawindow as pdf from the expert community at experts exchange saving a powerbuilder datawindow as pdf solutions experts exchange need. Exporting multiple datawindows to different sheets in excel. Save as pdf powerbuilder 11 saving a datawindow as pdf in pb 10. Datawindowchild object properties of datawindowchild object functions for datawindowchild. Call the saveas function of the datawindow or child datawindow. If the datawindowchild without any data is saved as an html file or xml file. This interview section questions contains a brief introduction to the power builder. Saves the pdf file into a blob variable when you use the pdflib method to save data from a datawindow object to a pdf file. Show pdf file using internet explorer activex gui application download.
Besides the functionality provided through the gateway module, aashtoware bridge management aashtoware bridge management is a bridge management system bms which incorporates dynamic, probabilistic models, and a detailed bridge database to predict maintenance and improvement needs, recommend optimal policies, and plan projects within budget and policy constraints. How to generate a pdf file and send it via email workarounds. Getting and modifying the dataobject of a powerbuilders nested report datawindow im currently developing a form module which switches template depending on the type indicated by the user. However, if we have a plan to fix this issue in the future, i will tell you in here as soon as possible. Saves the contents of a datawindow or datastore in the format you specify. Administrative privileges are required to install the printer. In each datawindow you want to generate a pdf you have to configure the following. I currently am trying to print a datawindow to a pdf file in powerbuilder 12. If you omit filename or specify an empty string, the user is prompted for a. Find answers to how to retrieve data from the selected row from a dropdown datawindow from the expert community at experts exchange.
Mar 29, 2004 how to share the datawindow to inner datawindow of nested datawindow. The xslfo method uses a platformindependent java process, and is particularly useful for printing datawindow objects in easerver on a unix operating system. So my question is, how do i create and save a file as a pdf so it works on other systems. Is there a pb utility third party or otherwise to allow the user save a datawindow in some sort of wysiwyg format. Powerbuilder lets you generate pdf from a datawindow using a ghostscript driver. A string whose value is the name of the graph in the datawindow control. Export powerbuilder datawindow for excel is a powerbuilder library designed for exporting data from datawindow and datastore formats in powerbuilder to excel spreadsheets with cell formatting intact. You have to do some changes to datawindows and code so this can be done. Thanks for that, although i was led to beleave that a datawindow child had the same available functionality as a datawindow, oh well.
How to retrieve data from the selected row from a dropdown. Provides a reference to a child datawindow or to a report in a composite datawindow, which you can use in datawindow functions to manipulate that datawindow or report. Disable 93disallow installation of printers using kernelmode drivers. Print datawindow to pdf file without using ghostscript. If i understand you correct, you are interested in the new inserted row only. Dear all, a general question about a common request from our clients. Print datawindow to pdf file without using ghostscript posted on may 23, 20 at 04. Nov 11, 2009 hello gw, good day, yes the purpose of converting pdf is, we have a mail sending option from powerbuilder when the user clicks on the send mail button we will saving datawindow as pdf and send as an attachment with the mail. How do i get a datawindow to save correctly to pdf.
It does a nice job of rendering datawindow visual content, but performance is relatively slow as well as cpuintensive. The user can view and change data and send changes to the database. If you want to save to pdf using the distill method, you do not need to change any properties. For example, a datawindow object that populates a column having the dropdowndatawindow edit style is a datawindowchild object.
Filesave rows as with the file type pdf in the datawindow painter. Now we would like to modify the pb such that an excel is generated instead of pdf. Sep 19, 2014 getting and modifying the dataobject of a powerbuilders nested report datawindow im currently developing a form module which switches template depending on the type indicated by the user. For syntax to save objects in ole controls and ole storage, see saveas in powerscript reference applies to. Download free powerbuilder 10 saveas pdf masterbackup. I am able to export to pdf, but the datawindow has too many columns due to which they are not fitting on single page in pdf. The distill method is used by default when you select save rows as from the file menu in the datawindow editor and select pdf as the file type, or when you use the saveas method with pdf. For licensing reasons, ghostscript is not installed with powerbuilder. I need to be able to open the excel file within a datawindow and save it back into our sybase environment. A reference to the datawindow control containing the graph. Find answers to datawindowchild arguments dependant on retrieval result in same datawindow from the expert community at experts exchange.
78 1577 1521 320 1038 461 1607 536 612 309 751 1433 188 800 346 1061 1446 462 216 595 1498 435 293 1564 841 1632 135 462 1645 590 1239 1373 28 331 861 847 1264 1408 25 856 527