Quick 'Go To' link within a report 1

[sitadba]

I have an Oracle Report that is displayed on our web page. 1 particular report is sorted by customer and it is a long report because it shows all customers.

Is it possible to ad an alphabetical listing on the bottom of the report, so that the end user can click on the letter and go directly to all customers starting with that letter, instead of scrolling through the report?

For example: Click on the letter 'S' and it brings you to all customers where name begins with 'S'.

Any help would be greatly appreciated.

Brgds,
Denise

 

[nagornyi]

If customer list added at the end of report, users will have to go to the last page to reach that list, which may take long.
I would recomment having two reports. The frirst one would display only customer names hyperlinked to second report displaying details for the selected customer. One of the lines on the first report could be "SHOW ALL CUSTOMERS", and that one would display report for all the customers as you have it now.
If this scenario looks good for you and you need further assistance with its realization, please feel free to ask.

 

[sitadba]

Hello Nagornyi,

Thank you for your quick response and good suggestion. I will give it a try and see how it goes.

Thanks again.

Brgds,
Denise

 

[sitadba]

Hello Nagornyi,

I was thinking.... would it be possible to have the alphabet listing on the bottom of each report page instead of just the last page?

I mentioned the suggestion that you gave me and they want to try it first and then they will decide. For some reason they really want the alphabet listing on the bottom of the screen so they can jump around.

Thank you for your help. I really appreciate it.

Brgds,
Denise

 

[nagornyi]

Of course you can have customer list repeated on each page, but... how long is the list? I understand the list is pretty long, wouldn't it eat up a significant portion of each page (if not entire page?)

 

[sitadba]

Hello Nagornyi,

It would be the 26 letters of the alphabet on the bottom of each page.

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

with each letter being a link to that report with only the customers beginning with that letter.

Would I have to do a link for each letter separately or is there an easy way to accomplish this?

Thank you & Brgds,
Denise

 

[nagornyi]

Add the following SQL query to your data model:

select 'A' letter from dual union
select 'B' from dual union
select 'C' from dual union
select 'D' from dual union
select 'E' from dual union
select 'F' from dual union
select 'G' from dual union
select 'H' from dual union
select 'I' from dual union
select 'J' from dual union
select 'K' from dual union
select 'L' from dual union
select 'M' from dual union
select 'N' from dual union
select 'O' from dual union
select 'P' from dual union
select 'Q' from dual union
select 'R' from dual union
select 'S' from dual union
select 'T' from dual union
select 'U' from dual union
select 'V' from dual union
select 'W' from dual union
select 'X' from dual union
select 'Y' from dual union
select 'Z' from dual

That would create a query with single group and single field 'letter'. Create repeating frame for this group that would run "across" and put the letter field in. Then you will have to create the hyperlink only once for that field and use the field value as parameter.

 

[sitadba]

Thank you Nagornyi. I really appreciate your help and your quick replies.

Brgds,
Denise

 

[sitadba]

Hello Nagornyi,

I added the above query in the datamodel. I created a repeating frame for this group and had it run across. Before creating the hyperlink I wanted to run the report to check if the alphabet list will run across the top of the pages. The only thing that is showing on the top of all the pages is the letter A. I can't get it to show all of the letters. I'm not sure what I am doing wrong. Any suggestions?

Thanks again.

Brgds,
Denise

 

[nagornyi]

You probably drew the repeating frame a page wide, instead of doing it small so that its width times 26 could fit into the page.

 

[sitadba]

Hello Nagorny,

I just wanted to say Thank You! It was exactly what you said. It is working perfect.
Brgds,
Denise