Create a Back Hyperlink if no of records are zero

building reports webintelligence
1

Hi To All

I have created a Hyperlink report where in it shows you in the first report
all the Facilities, And when you click on Facility Id it will Open another report and shows you all the records of Environmental Interest and so on… And If you want to go to previous report step by step then I have placed a “Back”, By clicking this “Back” you can go to previous report, this is working fine.

But I got stuck in one point. When there are no matching records, no records are displayed. Then I want to place another “back” button, If they press this “back” I want to point to first report(i.e. Facilities) where they started.

I have tried using the function
=If((NumberOfRows([Environmental Interest]))>0;Back;back).

Only if there are records displayed “Back” is getting displayed but if no records displayed in the report then it is not displaying “back”. It is empty.

Please help me how to display “back” Hyperlink(Opendocument syntax) if there are no records displayed in the report.

Thanks
Mohan

Mohanbo_us (BOB member since 2008-05-06)

2

hi

You must be placing your back button link in some table or a cell.
In the table proerties for that just check the check box “Show when empty”
That will display the table even when there a re no records fetched by the query.

Another way is that create a report level flag and set it to 1 when you have data returned by the data provider and set is to 0 when no data.

Along with your result tabel on the report add another cell that will have this Back link only.

Using the report level filter, display that cell based on the value of your flag filter you created above.

Hope this helps.

Thanks
Siddhartha

siddhartha.dubey :india: (BOB member since 2006-09-13)

3

Hi Mohan,

Did you get a chance to try the solution.
Did it work?

Thanks
Siddhartha

siddhartha.dubey :india: (BOB member since 2006-09-13)

4

Hi siddhartha.dubey

First I want to tell you sorry, I was having some production reports problem and some personal issues, so I could not reply you back.

I tried by checking the check box show when empty, that did not help.

I have got another workaround for the situation and it solved my problem.

I have placed two cells in the header and placed the “back” object in two cells and displayed it with conditions.

=If(NumberOfRows([Query 1])>=1;[Back])

=If(NumberOfRows([Query 1])=0;[Back1])

and made the background colour white and it solved my issue.

Thanks
Venu

Mohanbo_us (BOB member since 2008-05-06)