Total number of rows in the webi & deski report

system · August 25, 2008, 9:32am

Hi,

How can I get the total number of rows in each webi & deski reports at one time.
I have 500+ reports (300 webi & 200 deski). I need the total rows in each report.

It will be grate if I will get information like Report_Name, Total_Rows in the report.

My BO repository is on ORACLE, any workaround at backend level ?

Awaiting your favorable reply.

assist (BOB member since 2006-04-17)

system · August 25, 2008, 11:23am

For DeskI reports you can check this utility , though you may have to enhance it to get number of rows
For webI reports do a search in SDK forum with keywords as number of rows/records

.

haider (BOB member since 2005-07-18)

system · August 26, 2008, 4:18am

Hi,

All my reports are scheduled reports.
I am not getting the report name & total rows in the each deski & webi reports.

assist (BOB member since 2006-04-17)

system · August 26, 2008, 5:43am

You need to be clear in what you are asking.
Are you looking for that information to be displayed in each report or is it something else said initially as ‘at one time’

.

haider (BOB member since 2005-07-18)

system · August 26, 2008, 6:06am

assist,
can u explain clarly.

do you want to count raw data ( SQL returned row count)
or table row count ( report displayed row count)
For DeskI reports you can check this utility - which is display the list out the variable that used in reports. it is working on local copy of report not in repository report.

Tx

Nags (BOB member since 2007-02-07)

system · August 26, 2008, 6:32am

I think he/she is need of those details to be displayed in all the reports by doing an instant work.

Jansi (BOB member since 2008-05-12)

system · August 26, 2008, 9:01am

Hi,

I need the report displayed row count.
Can I get information like Report_Name & Total_Number_of_Rows in the report ?
All these webi & deski reports are scheduled reports.

Is there any SDK code to get this report name & total rows in the report.

In deski I get the toal rows, but it is a mannual work.

assist (BOB member since 2006-04-17)

system · August 26, 2008, 9:09am

This is only for full client reports

The attaced macro is displayed the following information
1.Report Name
2.Data Provider Name
3. Macro [y/N]
4. king of Data provider
4.1. Free hand SQL
4.2 Stored Procedure
4.3 Universe
4.5 Other DP - excel, plat file

Pls ref the attached excel

you can enhance it, hope this will helps you
DP.xls (14.0 KB)
Report_DP_Macro.rep (108.0 KB)

Nags (BOB member since 2007-02-07)