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

Formatting for Excel output_Crosstab & Chart

Started by vinu_rnr, 15 Jun 2017 08:19:02 AM

Previous topic - Next topic

vinu_rnr

Hi All,

Report has One crosstab at top and a chart below, output needs to be excel.

As report needs to be bursted, Cross tab and Charts are embedded in the 2nd column of two separate lists, 1st column of each list is sectioned and hidden.



However chart is distorting the first column of Chart in Excel as shown in the attached screenshot.

Requesting for formatting tips so that chart spans across the width of Cross tab.


Thanks a lot in advance,

Vinu

BigChris

Does it really have to be excel?

Have you tried putting the chart into a block - that sometimes helps.

At the end of the day, you might just be stuck with the way Excel formats the output...it's an excel issue rather than a Cognos one (I know that's not very helpful, but unfortunately true)

vinu_rnr

#2
Morning Chris,

Yes output has to be in Excel,  tried inserting separate Blocks,  even inserted crosstab and chart in two separate table.

but no luck :(

Lynn

You can associate a query to the page and use that for your bursting. Then put your crosstab and chart wherever you like on the page with appropriate master-detail relationships.

It has been a while since I've done bursting but I'm not sure you must have a list (even with a chart) if you go with the burst query associated to the page.

vinu_rnr

Morning Lynn.

::)  Till today i tried that, it never gave me error, but i always got blank output (No Data available)  .

A bit more detail here:-    we have separate query for Crosstab, Chart and also a separate query to capture BurstKey, BurstEmail.
assigned the Burst_Query to Page,  and simply Linked Crosstab object and Chart object with Burst_Query through Master details.  and also under crosstab's & Chart's property checked 'BurstKey' column well.  but continuously got blank outputs.

so switched to embedding chart & Crosstab in List.

BTW I managed to get the desired format, it's a bit odd but worked :)
assigned Size and Overflow:width = 3in   for  "List Column Body "  in which Crosstabs inserted.
whereas Size and Overflow:width=10in for "List Column Body" in which Chart is inserted. 

am gonna have sound sleep today Cheers :)