If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

dynamic sorting problem....in report studio cross tab

Started by srinivaschukka, 02 Nov 2007 04:23:39 AM

Previous topic - Next topic

srinivaschukka

Hi,

I have one cross tab report.
----------------------------------------------------------------------
   ( measure= revenue)         |product      | customer    | new customer |
---------------------------------------------------------------------
Location                             |    1000      |     -1000    |(1000)           |
----------------------------------------------------------------------
Time                                   |   2000       |     -2000   |(2000)            |
-----------------------------------------------------------------------
Employee                             |    3000      |     -3000   |(3000)           
-----------------------------------------------------------------------


Assume that the above is the cross tab..

And customer and new customer values are the same..I mean instead of the negatime values(-), the user want to display the values with in brakets'()'.. that means [ (1000) =-1000  ].

Now the requirment is that I would liketo sort the customer and new customer values dynamically....

I am using the script to dynamically sort the product, and customer and new customer...

ther is no problem in sorting the product column...and when come to the customer its sorting perfectly a the values are in -ve.
the problem with the new customer is that ...values are sorting normally
but my requirment is the values should be in -ve instead of ()..


assuem that (1000)= -1000
                  (2000) = -2000
                  (3000)= - 3000
when I sort it dynamically...( ascending order)

I want to display the values as ...
            ( ascending order)
                      -3000
                      -2000
                      -1000
but the display is in reverse manner..( as it is not considering the -ve values)
                    1000
                     2000
                     3000
-------------------------

Note: the sourse of the  package is from Transformer cube)


considering the above description.....

please let me know how to solve the problem...





goose

is customer a string...? if it is sorting is working properly. if it is a string you will have substring customer and convert to a numeric value and multiply by -1 then sort