TeamSpace
Quality vs. quantity Microphone
Home Who We Are What We Do What We've Done Why Work For Us Blog Contact Us

Using XPages to develop complex reports - Part 3

Roy Rumaner - March 12 2013 11:00:00 AM


Continuing on from Part 1 and Part 2 in this series, I once again will explore the intricacies of advanced reporting with XPages. Furthering my example from previous posts, once again the client asked for something else to be added to the XPage. They now want to be able to see the data that these calculations were created from.  It was decided that the easiest way to do this was to add a view panel (Figure 10) which contained all the fields they required.

Figure 10: Overview panel
Image:Using XPages to develop complex reports - Part 3

The next thing that was needed was a way to determine which data they wanted to look at. The obvious answer was to show it by the row of the report so I created a panel with four buttons, one for each row. (Figure 11)

Figure 11: View selection buttons

Image:Using XPages to develop complex reports - Part 3

The code behind each of these buttons was a single line of code (Code Sample 15) that corresponded to each row in the report.

Code Sample 15: View selection button code

viewScope.put("Program", "Program 2")

A Partial Update forced the refresh of the view (Figure 12), which in turn forced the view to refresh and display the data based on the filter. (Figure 13)

Figure 12: Partial refresh

Image:Using XPages to develop complex reports - Part 3

Figure 13: View data source

Image:Using XPages to develop complex reports - Part 3

The computed value is a set to use the viewScope that was set when the button was clicked. (Figure 14)

Figure 14: Filter by column value

viewScope.Program

I also added a checkbox to toggle the view panel on and off. The number of rows was set to 999 at the client’s request to eliminate the need for a pager.

Figure 15: View panel
Image:Using XPages to develop complex reports - Part 3

Add in some CSS to clean up the tables and the final result after putting all the pieces together is very useful. (Figure 16)

Figure 16: Final result
Image:Using XPages to develop complex reports - Part 3

Surprisingly the time to refresh the data each time the date is changed is less than a second in a database with over 10K documents.

I hope you got some value over these series of posts. The real salient point here is that XPages is a powerful tool for so many aspects of business if employed correctly. Please feel free to comment here about any specific questions or drop us a line via the Contact Us page above.

Comments

1pharmacy  9/14/2016 6:38:44 AM  onlie pharmacy cialis

{ Link } ,

2pharmacy  9/14/2016 6:39:09 AM  onlie pharmacy cialis

{ Link } ,

3pharmacy  9/14/2016 6:39:35 AM  onlie pharmacy cialis

{ Link } ,

4pharmacy  9/14/2016 6:40:04 AM  onlie pharmacy cialis

Usually I do not read writeup on blogs, nevertheless I wish to say that this writeup extremely forced me to take a look at and do so! Your writing taste has been amazed me. Thanks, really wonderful post.

5pharmacy  9/14/2016 6:40:29 AM  onlie pharmacy cia_lis

Usually I do not read writeup on blogs, nevertheless I wish to say that this writeup extremely forced me to take a look at and do so! Your writing taste has been amazed me. Thanks, really wonderful post.

6pharmacy  9/14/2016 6:40:55 AM  onlie pharmacy cialis

{ Link } ,

7purchase_viagra  9/20/2016 7:19:20 AM  purchase viagra

{ Link } ,

8purchase_viagra  9/20/2016 7:19:37 AM  purchase viagra

{ Link } ,

9purchase_viagra  9/20/2016 7:19:54 AM  purchase viagra

{ Link } ,

10purchase_viagra  9/20/2016 7:20:13 AM  purchase viagra

Very well written article. It will be helpful to anyone who usess it, as well as yours truly

11purchase_via_gra  9/20/2016 7:20:31 AM  purchase via_gra

Very well written article. It will be helpful to anyone who usess it, as well as yours truly

12purchase_viagra  9/20/2016 7:20:47 AM  purchase viagra

{ Link } ,

13Daniel  9/21/2016 6:50:57 AM  Daniel

Its actually a nice and helpful piece of information. Im glad that you shared this useful information with us. Please keep us up to date like this. Thanks for sharing.

14online  9/21/2016 2:36:29 PM  viagra online pharmacy

{ Link } ,

15Daniel  9/21/2016 2:36:55 PM  Daniel

I do consider all the ideas you've presented on your post. They're really convincing and can certainly work. Still, the posts are very brief for novices. May just you please extend them a little from next time? Thanks for the post.

16Daniel  9/21/2016 2:37:25 PM  Daniel

I do consider all the ideas you've presented on your post. They're really convincing and can certainly work. Still, the posts are very brief for novices. May just you please extend them a little from next time? Thanks for the post.

17generic  9/26/2016 9:26:55 AM  cialis generic price

I've been in the banking industry for well over a decade, spe{ Link } , ing in mortgage lending.

18generic  9/26/2016 9:27:14 AM  cialis generic price

{ Link } , is not indicated for women or children.

19cialis  9/27/2016 7:36:59 AM  purchase cialis cheap

{ Link } , Gets FDA Green Light For Enlarged Prostate Treatment.

20George  9/27/2016 7:37:28 AM  George

I like what you guys are up too. Such clever work and reporting! Carry on the excellent works guys I have incorporated you guys to my blogroll. I think it will improve the value of my website

21George  9/27/2016 7:37:48 AM  George

I like what you guys are up too. Such clever work and reporting! Carry on the excellent works guys I have incorporated you guys to my blogroll. I think it will improve the value of my website

22cheap  10/7/2016 7:23:49 AM  buy cheap cialis softtabsbuy cialis delived fed ex

FDA Announces Revisions to Labels for { Link } , , Levitra and Viagra ».

23cheap  10/7/2016 7:24:15 AM  buy cheap cialis softtabsbuy cialis delived fed ex

Buy { Link } , vs Viagra and Levitra can occur naturally as one that works well for men.

24cheap_cialis  10/11/2016 7:52:16 PM  cheap cialis

Many to { Link } , tadalafil bestellen the eating helpful for the can said.

25viagra  10/19/2016 12:40:01 PM  buy viagra online

Liquid { Link } , Drink For Women in Odessa .

26viagra  10/19/2016 12:40:18 PM  buy viagra online

Prescription Online For { Link } , Your browser does not support our Online Store.

27viagra  10/20/2016 6:09:54 PM  buy viagra online

The size, shape words best place for { Link } , wish buy tadalafil tablets online no prescription .

28Paul  10/20/2016 6:10:22 PM  Paul

It is also possible that Zynga's chosen advertising network is to blame if we consider the case of the New York Times' website

29Paul  10/20/2016 6:10:41 PM  Paul

It is also possible that Zynga's chosen advertising network is to blame if we consider the case of the New York Times' website

30cheap_viagra  11/11/2016 7:18:57 AM  cheap viagra

Have a fake legal buy { Link } , online ireland tan for a must say that would be.

31cheap_viagra  11/11/2016 7:19:14 AM  cheap viagra

{ Link } , Tablets For Sale Uk in Missouri City .

32free_viagra  11/12/2016 6:03:08 AM  free viagra

Therefore, it is best to resist alcohol while taking { Link } , for erectile dysfunction.

33Donald  11/12/2016 6:03:35 AM  Donald

I loved your post.Much thanks again.

34Donald  11/12/2016 6:03:59 AM  Donald

I loved your post.Much thanks again.

35for  12/1/2016 6:08:43 AM  viagra for sale without a prescription

{ Link } , For Sale In Usa Stores With Next Day Delivery in Mission Bend .

36for  12/1/2016 6:09:00 AM  viagra for sale without a prescription

Those men, who seek medical treatment for ED, often opt for { Link } , medication.

37vagra_sale  12/2/2016 7:10:04 AM  vagra sale

Ian Read CEO Charles Pfizer { Link } , for sale.

38David  12/2/2016 7:10:28 AM  David

There are some attentiongrabbing points in time in this article but I dont know if I see all of them heart to heart. There may be some validity however I will take maintain opinion until I look into it further. Good article , thanks and we would like extra! Added to FeedBurner as properly

39David  12/2/2016 7:10:46 AM  David

There are some attentiongrabbing points in time in this article but I dont know if I see all of them heart to heart. There may be some validity however I will take maintain opinion until I look into it further. Good article , thanks and we would like extra! Added to FeedBurner as properly

40discount_cialis  12/28/2016 4:39:29 AM  discount cialis

Cheap { Link } , could well as brief history of instrumental delivery as for crossmatching.

41discount_cialis  12/28/2016 4:39:46 AM  discount cialis

We also provide a consultation service for men who want to buy { Link } , Written by Frances Cerulean .

42discount_cialis  12/29/2016 9:32:35 AM  discount cialis

At this time, only brand-name { Link } , is available for sale.

43order_cialis  2/9/2017 11:00:05 AM  order cialis

Before you split up for a work, you should system the alfuzosin und { Link } , ' website.

44order_cialis  2/9/2017 11:00:24 AM  order cialis

For ED, the two main methods to take { Link } , - either for use as needed And use once daily.

45cheap_cialis  2/10/2017 3:55:08 AM  cheap cialis

Fast Access Finance / Gold Coast Funds Centre spe{ Link } , e in funding for bond and rent.

46cheap_cialis  3/3/2017 8:00:32 AM  cheap cialis

Job for side { Link } , effects opportunities are inexpensive ACE inhibitors.

47cheap_cialis  3/3/2017 8:00:52 AM  cheap cialis

All number for college premises was brought to salaya, { Link } , gel.

48cialis  3/9/2017 9:18:04 PM  generic cialis 20x20

Brand { Link } , is indicated for the other experienced symptomatic hypotension as Terra Networks.