Is it possible to use ReportScript to extract one or two fields from the results of a business objects query? Is it possible to extract from the data cube?
Do the BOResults or BOVariables class permit this?
Thanks in advance
-Michael
Listserv Archives (BOB member since 2002-06-25)
Michael wrote -
Is it possible to use ReportScript to extract one or two fields from the
results of a business objects query? Is it possible to extract from the data cube?
Michael,
I’m not sure if this is exactly what you’re after but it may help. The following script called get_dates extracts 2 values from the first data provider in a document. This particular data provider has only 1 row with 2 columns.
Sub Main
dim start_date as String
dim end_date as String
start_date =
ActiveDocument.DataProviders.Item(1).Columns.Item(1).Item(1) end_date = ActiveDocument.DataProviders.Item(1).Columns.Item(2).Item(1) Application.Variables.Item(“startdate”).Value = start_date Application.Variables.Item(“enddate”).Value = end_date End Sub
To access the values you can create objects defined as ‘@script(‘startdate’,‘A’,‘get_dates’)’ and @script(‘enddate’,‘A’,‘get_dates’)
I hope this is of some help.
Best Regards,
Ailie Forgie.
Listserv Archives (BOB member since 2002-06-25)
Hi Michael:
There is a script at my site at www.bobooks.com that creates labels from the contents of the Microcube. Have a look it may help you out.
Robert
Schmidt Interactive Software, Inc.
Michael wrote -
Is it possible to use ReportScript to extract one or two fields from the
results of a business objects query? Is it possible to extract from the data cube?
Listserv Archives (BOB member since 2002-06-25)