Below Crosstab shows the result set of Regulatory Compliance Days until expired at a Summary level for each Qualification Code. This data comes through a Summary Query.

pic1.GIF

Days until expired are segregated into range buckets i.e Over 90, 90-61, 60-31, 30-16, 15-6, 5-1 and Expired, which are all defined as keyfigures in the backend.

So now, when the business wants to get into the details from the summary level, we have enabled them to click on the desried days range and it takes them to a details crosstab with a filter on Qualification Code.


I have developed two separate detail queries in the backend which have the deatail level information of the days until expired from Over 90 bucket through 5-1 bucket and for the expired bucket we have a sperate detail query.


The application will jump the user to the respective detail screen based on the selection made i.e click on respective bucket.


Inorder to achieve this interaction, I have created two querys Q1 and Q2 and for Q1, I have set a condtition in the query based on the Key Figure ZFORDAYS. The condition is defined as ZFORDAYS between ZVAR_DAYS_LOW and ZVAR_DAYS_HIGH which are nothing but manual entry formula variables created to serve the purpose.

Pic2.GIF

Pic3.GIF

pic4.GIF

Now, in the design studio for the Summary Crosstab’s “on click” event, we have to write the script as shown below

pic5.GIF

pic6.GIF

Query 1 and Query 2 are set up as Pages of a PageBook component in design studio.

Output:

Screen 1:

pic7.GIF

pic8.GIF

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply