Recent content by vadnagra

I have a crystal reports which has a group header. When I export the report to excel, I don't want to export the group header/s. I want only the header and details. It works if I suppress the group header, but then it doesn't show on the report on the screen as well. Any help will be...

Yes I tried several random things - display, show, activate - they don't seem to work!

I am trying to open a Lotus Notes (V8.0) email from within an excel workbook (VB Script). I want to set the subject line and body of the email via the code, but then have the email open up so that I can manually enter the Receipient list of names. This is how the current implementation works...

I want to be able to take a particular action when the user presses an "F" key from anywhere within the application. Where should I be coding for this. I tried to create a keydown event in the application object but that won't work. Any ideas?

I have a datawindow which has 2 groups already defined. I want to add another group but I need this to be the 1st group on the dw. How can I do this (if at all possible), without deleting and recreating the 2 existing groups?

I'm seeing a lot of documentation on "Set the ExtendedSelect or Multiselect property to true" for a drop down listbox, but I can't see that property in the control. I tried setting it through code as well "This.ExtendedSelect = TRUE" - even this does not work. Has anyone ever used it? Do you...

Actually I figured it out just after I posted this :) My mle had a horizontal scroll bar, which is why it was displaying it in a single line. When I removed the H. Scrollbar - the text automatically wrapped over !!!

I have a text type database field. I am reading it into an event in Powerbuilder, into a BLOB datatype and displaying it in the MLE as String(blob variable). The issue I have is that the entire data shows in one line - how do I get to wrap the text based on the width of the mle ?

First hardcode the sql with the variable values in the datastore and run and see if it works. It could be a problem with the arguements being passed to it.

How do you find the sqlsyntax for a nested datawindow ? The sqlpreview event shows only the sqlsyntax for the main datawindow ?

How do you find the sqlsyntax of a nested datawindow in debug mode ? The sqlsyntax in the sqlpreview event shows only the sql for the main datawindow ?

It just initializes a variable

I have a client and a server component in PB. I put a breakpoint in the server application - some of the breakpoints on the server side show up when I run the application, but one particular break point does not show up. The application seems to be hanging, but when I continue it seems to be...

I have a computed field in my header whose value gets set in the retrieveend even with the dot notation. However when the report goes into the second page, those values don't show. The values show only on the 1st page header. The dot notation used is...

I found the answer to this...in case you want to know. Add the pbm_syscommand event to the datawindow and check for commandtype message = 61536 (datawindow close). There are other commandtype values you can check for various other things.