Looking for ways to export a complicated report with nested datawindows into Excel
Hi, I am using PB 7.02 on MSSQL 2000. Does anyone have any suggestion on ways to export a datawindow contain several layers of nested reports into Excel ? Thanks Jean This should work with every datawindow. Syntax integer dwcontrol.SaveAs ( { string filename, saveastype saveastype, boolean colheading } ) where the saveastype = Excel! or Excel5! Hope this helps you. Stefan Stefan, Will this save report format too or just dumping the raw data to the excel sheet ? My report contain 10 child datawindows. Is there anyways to open an Excel Worksheet write th...

PageCount() with Nested Datawindow in Composite Datawindow
Hi Everyone, I use PB 11.5.1 Build 4740 (last build). I have a problem when I am trying to print out a composite datawindow. I have a composite datawindow with 3 nested datawindow, when I try dw_composite.Retrieve() it works fine, but when I put dw_composite.Print(), I faced a problem with the second nested datawindow: the number of pages. For example, I have two pages and the print is "Page 2 of 2" to the first page and "Page 2 of 2" to the second one. I am using the function "page()". This just occurs to print option, when I am using retrieve op...

do not show nested datawindow on composite datawindow !!
I have developed using EAS 3.6.1 and PB 7.0.3 build 10047. i made composite datawindow within 3 nested datawindows and all dw have 2 retrieval arguments. and i retrieve result data using getfullstate. in Client webbrowser, main dw is displayed but nested datawindows is not displayed in main dw. why not display???.. How can I do? Thanks in advance. Kwang-gyu Nested DW's do not work. You will need to have multiple web datawindows or use a PDF writer like Adobe to print to a file and display this in the browser. "�̱���" wrote: > I have developed usi...

How to share the datawindow to inner datawindow of nested datawindow
How to share the datawindow to inner datawindow of nested datawindow. Ex -------- dw_1 is normal datawindow dw_nes is nested datawindow, both are placed one window dw_nes contain dw_child datawindow Question ---------------- i want to share dw_1 and dw_child. I have tried the below code, getting error dw_1.sharedata( dw_nes.object.dw_child) It's the dot notation. You will need to dw_nes.GetChild("dw_child", ldwc) where ldwc is a _local_ datawindowchild. <kzganesan@gmail.com> wrote in message news:4c64c402-bac5-4ee0-83aa-4ac08ffe43e5@r66g2000hsg.go...

Reference a datawindow object (nested report) in a datawindow
Is it possible to reference a datawindow object in a datawindow? My scenario : I have a datawindow (composite) which holds another datawindow (nested report). This child datawindow has a OLE ActiveX object which I am trying to access from the window which holds the composite datawindow. The reason for this is because I need to access the ActiveX properties/functions after the composite datawindow have been retrieved. I've tried to get a reference to the child datawindow : //DataWindowChild dwc_activex dw1.getchild("dw_activex", dwc_activex) But as datawi...

Re: Nested Datawindow Report (Datawindow Printing)
Does anyone know if this problem has been corrected in PB 8 or 9? Please advise. I am currently using PB 7. Problem: In case of large text fields, PowerBuilder not printing the Data correctly. Lines are cut in half and also not printing last few lines . This is happening on nested datawindow. Here is the link to the original documentation: http://info.sybase.com/resolution/detail.stm?id_number=10938800 Original documentation :-) states that this is not a bug but expected behaviour, so what kind of "correction" do you expect? pbm_thisusuallydoesnothelp:-)) Philip ...

Nested datawindow within a nested datawindow
I have a report, that contains a datawindow, which itself contains a datawindow. Everything is working fine until the number of retrieved lines get's over about 1100 primary and over about 3200 retrieved nested lines. Although the task manager (I'm using Powerbuilder 7.0.3 on Windows 2000) shows me, that there is still enough free memory, the data retrieval stops and Powerbuilder (or the application which called the Retrieve() method) ends itself without any error message. That allways happens when the datawindow has allocated about 70 MB of virtual memory. (About 99% of those ...

datawindows in composite datawindow used in datawindow.NET, are not sliding up
Hi, Problem: datawindows in composite datawindow used in "datawindow.NET", are not sliding up , if one dw is not visible or did not retrieve data. Resulting in unwanted spaces. The height of blank white space is equal to the height of the datawindow art design time. When I looked at the generated JavaScript, I noticed there is "div" for the datawindow with height 0.00in which is supposed to be not visible. Tried different options with html/xhtml/xml same result. But slides up ok when exported to pdf(using saveas) on web and in PB10.5 application. Also s...

datawindow with nested report trying to export
i have a datawindow with nested report in the detail band i try to use the fuction dw_1.saveas() but i didn't get the nested reprots how to do that pls. help me? You need to save reports separately using datawindowchild class. SaveAs() works against the data set, not the presentation layer, so it wouldn't pick up on presentation formatting, nesting of datawindows, etc.... Like Dmitriy says, to get nested, you'll have to grab the datawindowchild and SaveAs() on it. However, if you want the data to show as nested, you'll have to roll your own save routine....

nested datawindow within another nested datawindow?
I was trying to create a report which has a nested datawindow within another nested datawindow, and PB didn't seem to go for this... got memory errors. Is this even possible? I searched all of the usual resources and couldn't find anything about this... maybe they assumed nobody would be dumb enough to try. thanks, Pat It is perfectly legal to have multiple levels of nested reports. However, nesting isn't supported for certain DW types like grid and n-up. Try testing your DWs on their own to ensure that they work properly. Then nest them one at a time and try to i...

reports about composite or nested datawindow style
I create a multi-datawindow report, and place two reports in detail field. I want to show the second datawindow rows behind the first ones. But in preview when the first datawindow list all rows, the second datawindow rows change to a new page, left a field of blank, how can I keep them stick together? Thank for help. ...

DataWindow This, DataWindow That...
Blah blah blah You've heard it enough that you don't even want to comment on how many times... The DataWindow. ....but it can't be enough anymore...can it? This from one of our colleagues (and yes my apologies for taking it out of context)... "...PB covers all you need to do that in ONE Tool. This includes Windowprogramming ( meaning the interface to the user: Windows, Sheets, diallougeboxes, etc.), Database operability AND Reporting! Well, I see als well as many other PB users that some of the implementations and features PB offers are improvable. But thi...

How to Create nested report in composite datawindow
What I try to do is to create a nested datawindow in a composite datawindow, this nested datawindow is created dynamicly according to an Datawindow syntax string. My problem is: Since the nested datawindow is dynamicly generated,it isn't exist in one library, so there is no dataobject.When I retrieve data using the composite datawindow,it tell me:"Load of nested report failed" My initial idea: I want to develope a control enable user to easily insert objects Such as: Text,picture,datawindow(report) and so on.The user can move and resize the objects.They can also chan...