report writer?

jndcu...@gmail.com

unread,

Jan 15, 2013, 11:35:08 AM1/15/13

to

hi all,

is anyone aware of a simple report writer which i could use to produce some simple row & column reports? i would like to be able to have simple headers on page breaks. my model would be a homogenous collection.

john

bruno.b...@gmail.com

unread,

Jan 17, 2013, 4:19:06 PM1/17/13

to

Hi,

Take a look at:

IDispatch class and the method example4.
IDispatch>>example4

You can do the same for an Excel report.

Regards,
Bruno

john c

unread,

Jan 17, 2013, 6:52:47 PM1/17/13

to

hi bruno,

thanks for your info.

john

Bruno

unread,

Jan 18, 2013, 7:13:03 AM1/18/13

to

Hi,

I have one simple package with MS Office classes.

You can do a simple Excel report very easilly.

I can send it to you.

Regards,
Bruno

john c

unread,

Jan 18, 2013, 10:00:30 AM1/18/13

to

bruno,

plz send the classes to jnd...@gmail.com.

thanks

john

Sanjay Minni

unread,

Jan 19, 2013, 11:06:36 AM1/19/13

to

Hi Bruno

Could you share the same with s...@planage.com

Thanks
Sanjay

fjern

unread,

Jan 19, 2013, 11:54:34 AM1/19/13

to

Would like to get a copy too

mail:skogsta...@gmail.com

regards
Soren

bruno.b...@gmail.com

unread,

Jan 19, 2013, 4:50:55 PM1/19/13

to

Hi,

Anyone has any "Smalltalk site" to upload the package ?

In the package there are 2 classes for an Excel report.
* BBMSExcelReport (use the automatically generated Excel package of the ActiveX Component Wizard)
* MSExcel (use the IDispatch)

In order to install the package, first you have to generate an Excel package using ActiveX Component Wizard.

It is very basic but new functionality can be easilly added.

Regards,
Bruno

jndcu...@gmail.com

unread,

Jan 20, 2013, 10:13:04 AM1/20/13

to

hi bruno,

i would like to add setPrintArea. where would i go to find the underlying list of excel commands which are exposed?

john

bruno.b...@gmail.com

unread,

Jan 20, 2013, 10:59:03 AM1/20/13

to

Add the following method to BBMSExcelReport.

setPrintArea: stringRange
"Set the property <PrintArea> for the <ActiveSheet> of the receiver.
stringRange = '$B$1:$D$3' "

^(excel activeSheet getProperty: 'PageSetup') setProperty: 'printArea' value: stringRange

Regards,
Bruno

bruno.b...@gmail.com

unread,

Jan 20, 2013, 11:13:48 AM1/20/13

to

> setPrintArea: stringRange
> "Set the property <PrintArea> for the <ActiveSheet> of the receiver.
> stringRange = '$B$1:$D$3' "
> ^(excel activeSheet getProperty: 'PageSetup') setProperty: 'printArea' value: stringRange

BBMSExcelReport

setPrintArea: stringRange
"Set the property <PrintArea> for the <ActiveSheet> of the receiver.
stringRange = '$B$1:$D$3' "

^self propertyPageSetup setProperty: 'PrintArea' value: stringRange

propertyPageSetup
^self activeSheet getProperty: 'PageSetup'

activeSheet
^excel activeSheet

Andreas Wacknitz

unread,

Jan 20, 2013, 12:49:37 PM1/20/13

to

Hi Bruno,

Maybe I am a little bit late, but I would also like to have your report classes.
Would you be so kind to sent them to me, too?

Best regards,
Andreas

bruno.b...@gmail.com

unread,

Jan 21, 2013, 8:24:53 AM1/21/13

to

> Maybe I am a little bit late, but I would also like to have your report classes.
>
> Would you be so kind to sent them to me, too?

Hi,

I have no problem to send the package to all.

But it will be better to upload the package to any Smalltalk site.

Anyone knows any Smalltalk site ?

Regards,
Bruno

Andreas Wacknitz

unread,

Jan 22, 2013, 1:40:10 AM1/22/13

to

I don't know of such a special Smalltalk site. But I am still waiting for the Dolphin 6.1 (6.2 or was it 6.3?) release with exactly what we would need in this situation: a public STS repository. Almost one year ago we were very close to a release (and then postponed to "the end of the summer") as far as I remember. Sigh.

Regards,
Andreas

bruno.b...@gmail.com

unread,

Jan 22, 2013, 6:37:46 AM1/22/13

to

> Andreas

Hi Andreas,

I can not get your mail from this forum, send it to me an i will send a mail to all of you with the package.

Regards,
Bruno