COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: mohsin2010 on 17 Jan 2011 01:25:58 AM

Title: Rows Per Page Result On same Page
Post by: mohsin2010 on 17 Jan 2011 01:25:58 AM
HI,

   i m using Repeater Control and want to show the result on the same page  after setting the "Rows per Page property" that is ,

After setting the property Rows Per Page=2,
on one page :
Canada=2
Australia=3

and on another page

America=5
Pakistan=7


now how do i display the result on the same page??

that is,

Canada=2      America=5
Australia=3    Pakistan=7


Thanx in Advance,

Syed Mohsin Raza
Title: Re: Rows Per Page Result On same Page
Post by: PRIT AMRIT on 17 Jan 2011 01:49:27 AM
pls find attached XML... let me know if helps?
Title: Re: Rows Per Page Result On same Page
Post by: mohsin2010 on 17 Jan 2011 02:25:05 AM
i am not getting from XML .. . if you know the technique then let me know about it .. .

Thanks,

Mohsin
Title: Re: Rows Per Page Result On same Page
Post by: PRIT AMRIT on 17 Jan 2011 02:38:05 AM
It's just straight forward...

1.Open a new blank report template.
2.From the tool box drag and drop Repeater Table.
3.Select the Repeater Table, from Menu Bar- Table, Insert Table. Say Columns:2
Row: 1
4.Drag and Drop your items into the Columns from the Package
5. Run

Hope works for u?

Thanks
P
Title: Re: Rows Per Page Result On same Page
Post by: mohsin2010 on 17 Jan 2011 02:58:07 AM
PRIT AMRIT,

                i m doing exactly what ever you have told me but the question remain the same how do i restrict the page to show data on the same report  as i mentioned the same report ????

Best Regards,

Syed Mohsin Raza
Title: Re: Rows Per Page Result On same Page
Post by: PRIT AMRIT on 17 Jan 2011 03:09:31 AM
Pls see the attached screenshot.

Select the Repeater Table - can see an option in the property as shown in the attached screenshot.

Define, across: 1000
           Down: 1


Hope this should do.

Thanks
P
Title: Re: Rows Per Page Result On same Page
Post by: mohsin2010 on 17 Jan 2011 03:34:52 AM
PRIT,

it is giving he same result till now i have been doing experiment for 3 hrs but haven't done this  :'(

thanks,

Mohsin
Title: Re: Rows Per Page Result On same Page
Post by: PRIT AMRIT on 17 Jan 2011 03:48:06 AM
Is it working fine now?
Title: Re: Rows Per Page Result On same Page
Post by: mohsin2010 on 17 Jan 2011 03:49:58 AM
no its not working fine it is giving result but not according to my requirement i mentioned in my first post  ???

Mohsin
Title: Re: Rows Per Page Result On same Page
Post by: PRIT AMRIT on 17 Jan 2011 03:57:05 AM
can change the property and see if it helps?

Across: 2
Down: 2

Let's say if you have 10 countries and u want to display on 2 rows, then set

Across: 5
Down: 2

Thanks
P
Title: Re: Rows Per Page Result On same Page
Post by: mohsin2010 on 17 Jan 2011 04:16:11 AM
yup i have changed the property ... actually i have 4 countries and want to show them in 2*2 format i put ,

Across=2
down=2

but its not f9  :(

Thanks,
MOhsin
Title: Re: Rows Per Page Result On same Page
Post by: PRIT AMRIT on 17 Jan 2011 10:18:54 PM
Hmmmmm...

Can you send me the XML? It should work.

Thanks
P
Title: Re: Rows Per Page Result On same Page
Post by: mohsin2010 on 17 Jan 2011 10:54:33 PM
PRIT,

       Dude i don't know what i was doing yesterday i  got sicken tired to this but not getting that today when i did this having fresh mind i have succeeded  :)
   i think yesterday i was doing the same think.. . any ways

thanx,

Mohsin   
Title: Re: Rows Per Page Result On same Page
Post by: PRIT AMRIT on 18 Jan 2011 12:19:14 AM
Ha ha ha... All is Well...  ;)
Title: Re: Rows Per Page Result On same Page
Post by: mohsin2010 on 18 Jan 2011 12:49:17 AM
PRIT,

   i have some problem regarding creating reports using simple query
             if you know then will you kindly let me know about that i have posted the link is under,

http://www.cognoise.com/community/index.php/topic,12899.0.html

Best Regards,

Mohsin