Warning message when row returns os greater than 100000

building reports webintelligence
1

Hey Guy,

What is teh best approach here, i am looking at creating a cell in a webi report that will write a warning message on the report if the row returns is larger than 100 000 …

how can i do that?

Cheers

C

Intelligentsia :australia: (BOB member since 2005-06-07)

2

hi there!

try this:

=If NumberOfRows([Query 1]) >= 1000 Then “Warning Message”

Query 1 is your data provider name.

regards,
r.A. :mrgreen:

R.A. :philippines: (BOB member since 2008-10-28)

3

Yep working fine : .

=If(NumberOfRows(DataProvider([Object name]))>100000;"Warning - This report may content partial Results ")

[Moderator Edit: Added code formatting - Jansi]

Intelligentsia :australia: (BOB member since 2005-06-07)

4

I don’t how they do things “down under,” but here in the States we would usually say “may contain partial results.”

Just a friendly tip!

:mrgreen:

Lugh (BOB member since 2009-07-16)

5

I know it was a typo picked up on testiong, but cheers for the reminder

Intelligentsia :australia: (BOB member since 2005-06-07)