Crosstab Datawindow part 2

I have to make a crosstab report like this :
Model		Jan 	Feb	Mar ....... Nov	Dec
A		1	10	0	   0	4
B		4	0	1	   4	7
C		3	1	0	   0	3

But, if I only have data until Oct, the Nov and Dec will not appear in
Like this :
Model		Jan 	Feb	Mar ....... Oct	
A		1	10	0	   5	
B		4	0	1	   4	
C		3	1	0	   0

What can I do to show Nov and Dec in my crosstab, even they have no data
and I want to show the zero number in Nov and Dec???
Thank you

Eka Putra
Jakarta - Indonesia.		
2/3/1999 2:06:21 AM
sybase.powerbuilder.datawindow 28057 articles. 4 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 1

First create a select statement that will retrieve all months (jan to dec).
Then make your crosstab static and retrieve the data.  Now go back and
chance your select to what it really should be.  You will always have all
months displayed, even if there is no data.

Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.
Eka Putra wrote in message
>I have to make a crosstab report like this :
>Model Jan Feb Mar ....... Nov Dec
>A 1 10 0    0 4
>B 4 0 1    4 7
>C 3 1 0    0 3
>But, if I only have data until Oct, the Nov and Dec will not appear in
>Like this :
>Model Jan Feb Mar ....... Oct
>A 1 10 0    5
>B 4 0 1    4
>C 3 1 0    0
>What can I do to show Nov and Dec in my crosstab, even they have no data
>and I want to show the zero number in Nov and Dec???
>Thank you
>Eka Putra
>Jakarta - Indonesia.

2/3/1999 3:21:09 AM

Similar Artilces:

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...

CrossTab Datawindow and Datawindow plugin
Does anyone know of any problems using the Datawindow plug-in and a crosstab presentation sytle. I'm using web.pb to call my distributed PB server and save the crosstab as a psr file and then return the html pointing to the psr file. The computed fields are getting overlaid but doing it from PowerBuilder works fine. I'm using PB 6.5 Thanks, Bill Anderson ...

Is DataWindow 2.5 in Dw.Net is same as DataWindow in PB11.2
Hi there , Can anybody confirm the said subject is a valid statement ? Dw.Net2.5 = PB11.2.DataWindow ???? How about the future enhancements which are planned for PB11.5 and future releases of PB... Will it not always be in the same codestreamline ? Regards , Van I mean how will be co-relate the three products from Sybase 1) DataWindow.Net 2.5 for Visual Studio 2008 2) PocketPowerBuilder Datawindows 3) PowerBuilder11.2 and Powerbuilder1x.x Datawindows All everthing is remain the same in all the above three products as far as Datawindow properties / events /...

Treeview datawindow as part of composite datawindow
Hi I have a question about a Treeview datawindow in a composite datawindow. I created a treeview datawindow with 2 levels, but I have set my default expand level = 1. Running this datawindow on it's own, the user can expand the treeview to level 2. However, as soon as this datawindow becomes part of a composite datawindow, I cannot interact with it at all to expand my levels. Is this normal behaviour in a composite datawindow, or is there a way to expand the levels. I am developing in Powerbuilder 12.Net Thank you in advance, Annelize Composite datawindows are ...

1 Xml -> 2 DataWindows; 2 DataWindows -> 1 Xml
Hi Is it possible to import an Xml file like <data> <dataX>...</dataX> <dataV>...</dataV> <dataV>...</dataV> <dataV>...</dataV> ... <dataV>...</dataV> </data> to one Datawindow ? On the other hand is it easily possible to assemble data from two Datawindows in one XML file ? thanks Thomas Kovasits Thomas Kovasits wrote: > Hi > Is it possible to import an Xml file like > <data> > <dataX>...</dataX> > <dataV>...</dataV> > &l...

How can I count number of rows in each datawindow in composit datawindow then access and set item in each row in each datawindow! #2
This is a multi-part message in MIME format. ------=_NextPart_000_0043_01C308EA.0E4861E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi friends, I created a composite datawindow includes three datawindow. How can I count the number of rows in each datawindow? (Rowcount() function can = not works). Also, I need access in each row then reset the value that I want = in each row in each datawindow. I use the property to access to get data in each row in each datawindow, but the right value only happens in the = fi...

Crosstab datawindow #2
On a Crosstab datawindow, I use an expression to set both the Background.color and the color property for a column. When I run the application from PowerBuilder (version 6.5) everything works fine. However when I build an exe, the expression setting the Background.color property fails and the background for this column always appears as black. The font color though is okay. Does anyone know why the exe behaves differently. The application runs on Winodws NT 4.0 When you program behaves differently when you create the Exes this for me has always meant that you have the wrong...

Crosstab DataWindows #2
I need to create a Crosstab DW that resumes the information from a table. This table contains the following columns: Quarter, Products and Quantity and I want to create a very simple Crosstab DW with this tree columns (Column, Row and data respectively). Besides I would like to create a computed field, that should go with each data field, that resumes the percentage of increment of each quarter compared with the last one. Do you know if it posible to create this computed field? Thanks ...

CrossTab DataWindow #2
CrossTab DataWindow : It 's very nice to build quickly this kind of report ! But, It starts to become a nightmare when you've to change something like : Add a column, modify the SQL... All the graphic is reset (Compute fields are deleted, properties are reset...All the work has to be done again !) I'm just wondering if i can cary on to use this type of DW... Is it a bug PB or is there something to do to fix this problem ? I'm using PB 6.5. Tanks a lot for any suggestions ! ...

PowerBuilder DataWindow #2
Hi all, I have a requirement to implement a master-detail sheet. That's ok. However, based on the user-logged-in credential, the user may OR may not be able to edit the details part. Now I can easily implement this by adding a constraint while updating the details' data. if user_can_edit then update end if The problem is this: If the user is not entitled to make changes, he is still able to put focus to the details' form data and modify (of course I am not updating it)...but the user can get a feeling "oh I am able to modify the data". Is it so...

CrossTab Datawindows #2
I need to export a crosstab datawindow to an excel spreadsheet, the saveas function does not bring the column headings into Excel or any Total values. Is there a way to get the column names from the crosstab datawindow from the code. Liam ...

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. <> wrote in message news:4c64c402-bac5-4ee0-83aa-4ac08ffe43e5@r66g2000hsg.go...

Datawindow refresh problem in a nested datawindow #2
I have a nested report with 5 datawindows. There second and fourth datawindows are being set by RowsCopy function after retrieving the main datawindow. The others are retrieved. THe problem here is that when printing/displaying the datawindow there are lot of blank pages. Pl. advise THanks ---== Posted via the PFCGuide Web Newsreader ==--- ...

Add datawindow control for master datawindow #2
Hi, I hope you dont't mind an newbie question here. I am following the tutorial of the Getting Started PB5 manual and I am stuck in chapter 8 "Building Ancestor Windows". Here are the steps: 1. I create a new window ( a master/detail window)and want to add a control to be the master DataWindow in the applic. 2. I select the UserObj button and choose TUTOR_PB.PBL 3. When I click OK the manual tells me to click in the upper left corner but nothing happens: there is already a blanc window visible, which I can't move with the mouse. 4. I select Properties. The name ...

Web resources about - Crosstab Datawindow part 2 - sybase.powerbuilder.datawindow

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Intelligent Versus Surrogate Keys
Should I use business columns as primary key fields for tables in thedatabase, or generate artificial primary key values? When business-related ...

chevy volt
ProEXR File Description =Attributes= channels (chlist) compression (compression): Zip dataWindow (box2i): [0, 0, 5119, 2475] displayWindow (box2i): ...

Enable - A comprehensive solution for the localization of PowerBuilder applications Untitled Document ...
Enable is localization/ translation tool used by PowerBuilder developers to make their applications multilingual.Enable is a powerful tool that ...

comp.lang.clipper.visual-objects - Google Groups
comp.lang.clipper.visual-objects 1-20 von 33006 Themen werden angezeigt Integrity of a file 09:35 Combobox value Lu 08:12 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
Developers can choose Win32 or newer style .Net development

PowerToTheBuilder - PowerBuilder UI Controls

Beautiful iPad Mini 3 Concept Reimagines Appleā€™s Tablet With iPhone 6 Design, Gold Color [Images]
The iPhone 6 may be grabbing all of the recent headlines due to its impending announcement, but spare a thought for those who prefer to stay ...

Java Networking - Real's HowTo
Real's HowTo Custom Search Java Language String and Number Applet AWT Swing Environment IO Javascript interaction JDBC Thread Networking JSP ...

Business Intelligence Products - Database Management, Data Warehousing & Mobility Software - Sybase Inc ...
Sybase offers a variety of Business Intelligence (BI) software like products for database management, data warehousing and mining, data integration ...

Resources last updated: 1/10/2016 7:26:33 PM