@script for a Universe-Report

sdk development
1

Hi

I have developed a special one-product-report. This report schould run
for about 80 products whith the DAS. That meens that there schould be no
user entering the product-number with a prompt ! And I don’t want to
save this report 80 times !! I want to give the product number with a
paramter to the report. Is this possible ?

By the way: I know that theres the @script variable, but this feature
only works with Free-Hand-SQL, but I need my Universe.

regards

Mit freundlichen Gruessen
DSB, Daten-Service Beck GmbH
Alexander Zipf

Tel. (07132)385-263
Fax (07132)385-243

Listserv Archives (BOB member since 2002-06-25)

2

May be you can do this with the help of BO Script.

Create a script (I’ve attached the skeleton of script) and attach
it to your report when scheduling in DAS.

Sub Main

ProdName(1)=“Product 1”
ProdName(2)=“Product 2”
ProdName(3)=“Product 3”
ProdName(4)=“Product 4”
.
.
.
ProdName(80)=“Product 80”

Dim boDoc as BODocument
Set boDoc=Application.ActiveDocument()

For I=1 to 80
boDoc.Dataproviders(1).RemoveFilters
boDoc.AddComplexFilter(“ProdClass/ProductName”, “Equal To”,
ProdName(I))
boDoc.Refresh
boDoc.Print
NextI

End Sub

This is not working version of Script, just a skeleton. Check the syntax for
the commands.
If you need help you can mail me.

– Vasan

-----Original Message-----
From: Zipf, Alexander, DSB [SMTP:zipf@DSB.NET]
Sent: Thursday, January 14, 1999 10:13 AM

Hi

I have developed a special one-product-report. This report schould run
for about 80 products whith the DAS. That meens that there schould be no
user entering the product-number with a prompt ! And I don’t want to
save this report 80 times !! I want to give the product number with a
paramter to the report. Is this possible ?

By the way: I know that theres the @script variable, but this feature
only works with Free-Hand-SQL, but I need my Universe.

regards

Mit freundlichen Gruessen

Listserv Archives (BOB member since 2002-06-25)