Help needed with formatting

[actcognosuser]

All,
      I have a report with a crosstab.I applied a border to the crosstab.If the report is executed in excel 2002 the border is not showing up but it displays border in pdf format.Same is the case with chart.

I also tried inserting the crosstab in a table and applying a border to the table.
Did not help.

Please advise?

[blom0344]

Transfering formatting to Excel output is a big compromise. PDF is nearly faultless, but Excel just does not cut it. Remember, it is basically a calculation tool, not really meant to present data..

[actcognosuser]

Thanks blom344.

It definitely is a challenge when you have an excel output.

I have another issue for which I have tried different options.Still does'nt work.
Could you please suggest how this could work?I am trying to calculate counts of people
who applied online during  regular working  hours and extended working hours based on
time interval.

Can we compare a date time value with a string?example
if ([Dataitem1] = 'Business hours')
then( [cast_time(Date/Time field] between '9:00:00' and 3:00:00)
else
if ([Dataitem1] = 'Extended Hours')
then( [cast_time(Date/Time field] between '9:00:00' and 5:30:00)
else()

To achieve this should I cast it to char?
Thanks in advance!

[blom0344]

AFAIK you cannot concatenate a time with a string expression. The time part will need to be cast to a string in order to combine them.

Another way would be to use the extract function which I believe will also work for hours,minutes and seconds and then cast the resulting outcome to a char(2) and concatenate all resulting string expressions..

[actcognosuser]

Hi Bloom ,
                   I am not trying to concatenate string and time.I do not know how to
do a comparison!

[blom0344]

Hi Bloom ,
                   I am not trying to concatenate string and time.I do not know how to
do a comparison!

The outcome of a then or else part of the  if.. then.. else.. is either a value  or another logical  if.. then.. else..
You cannot define an equition there. 
Frankly I am at a loss what you want to achieve..

[actcognosuser]

Hi Blom,

I Hope I can explain my situation better with this example.

--------------------------------------------------------           
Date/Time                                Working/Extended
--------------------------------------------------------
2010-01-3 8:00:00 AM                 Working
2010-01-3 1:00:00 AM                 Extended
2010-01-3  4:00:00 PM                 Working

In my query I need to fetch only those  rows which fall between time 8 am and 4.pm,based on column 2(i.e working/extended).If column 2 is working then fetch only row 1 and 2.

[blom0344]

If column 2 is working then fetch only row 1 and 2.

I think the catch is in this Phrase. You can evaluate each individual row for the value of column 2, but you cannot apply a range as you can with a date / time component. I do not see how you can solve this by set-based logic. You will probably need a procedure to process the data, looping through the rows..

[pratyush]

All,
      I have a report with a crosstab.I applied a border to the crosstab.If the report is executed in excel 2002 the border is not showing up but it displays border in pdf format.Same is the case with chart.

I also tried inserting the crosstab in a table and applying a border to the table.
Did not help.

Please advise?

Hi

Cognos 8.3 and Cognos 8.4 works on Office 2003 with SP3 pack, if you are having a formatting issue (You can check out the PMR's on the IBM Cognos site for the same) ... in terms of border but if you are facing in the format of a date time stamp then change the property of that dataitem to text, it will work out ...

Cheers ....