Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: sir_jeroen on 25 Oct 2005 04:07:43 PM

Title: [Tutorial] List item with custom sorting
Post by: sir_jeroen on 25 Oct 2005 04:07:43 PM
A new tutorial has been released:
How to create a list item with custom sorting

This is my answer to the folowing topic:
http://cognoise.com/community/index.php?topic=548.0

Have fun... And... let me know if you like it :D
Title: Re: [Tutorial] List item with custom sorting
Post by: CoginAustin on 25 Oct 2005 09:30:01 PM
 I have actually never thought about having the sort order changed with a dropdown .. very cool ..  :o


thanks
Title: Re: [Tutorial] List item with custom sorting
Post by: jolly on 26 Oct 2005 12:58:41 AM
Pretty cool ,Ã,  particularly for those they have not the access to execute HTML-Items.
I will show today still another possibility to sort Columns with Javascript. You will find this example in the [[Script] Some javascripts in actions] Section.

Cu Jolly
Title: Re: [Tutorial] List item with custom sorting
Post by: UPS on 26 Oct 2005 02:04:27 AM
Hi,

Very good tutorial. 

Thanks
Title: Re: [Tutorial] List item with custom sorting
Post by: jolly on 26 Oct 2005 06:03:27 AM
The Video is at http://cognoise.com/community/index.php?topic=406.msg2440#msg2440
Title: Re: [Tutorial] List item with custom sorting
Post by: otsizh on 26 Oct 2005 07:16:40 AM
WOW !

You are the Best! It is exactly what I need. Thank you so much!
Title: Re: [Tutorial] List item with custom sorting
Post by: sir_jeroen on 26 Oct 2005 07:21:28 AM
otsizh... Are is that for me ( :D ) or for jolly ( :'( ) or for the both of us ( :D )
Title: Re: [Tutorial] List item with custom sorting
Post by: otsizh on 26 Oct 2005 07:47:53 AM
Quoteotsizh... Are is that for me
Of course it is for you - ReportNet Addict - you created report..... or you still need money($$ ;))
thank you very much!
Title: Re: [Tutorial] List item with custom sorting
Post by: sir_jeroen on 26 Oct 2005 08:08:56 AM
I always need money... You know what... when there's a month that you don't need money... send it to me :D

But you must thank Jolly too... he's showing me offÃ,   >:(
Title: Re: [Tutorial] List item with custom sorting
Post by: otsizh on 26 Oct 2005 08:27:53 AM
Well thank you both,

but know I have a new problem.....
when I tryied to do the case statemnt :
case when (?Sort By?=1) then ([Project Id])
when (?Sort By?=2) then ([Project Name])
when (?Sort By?=3) then ([Project State])
when (?Sort By?=4) then ([Project Type])
else ([Project Id]) end

I have this mistake:
QE-DEF -0405 Incompatible data types in case statment

I believe than it because Project ID is number and Project Name is string type
Any suggestions??
thanks, olha
Title: Re: [Tutorial] List item with custom sorting
Post by: jolly on 26 Oct 2005 08:44:11 AM
QuoteBut you must thank Jolly too... he's showing me off   Ã, 

That is however not my intention. You gave us your Tutorials. Now I can give you also a little back by showing what Kind of Reports IÃ,´ve build.
Title: Re: [Tutorial] List item with custom sorting
Post by: sir_jeroen on 26 Oct 2005 09:25:14 AM
It's alright jolly... I'm impressed by the reports that you are building and it's hard for me to keep up with you. But enough complementing eachother :D

Otsizh you're right you must cast project id as a string...
Text only | Text with Images