Percentage line "chart" in a Report Studio List

[Bark]

Hi,

I am developing a simple list report (or so I thought!  :-[):

I'm going to make a similar situation up for the sake of the question.

We have a set of elements that can be chosen from a list and we ask 1000 people distributed in 10 different countries to pick 3 of them.

Then you get a report with the summary of the choices of your country:

Item	You	Your Country	Overall
Pencil		10%	5%
Pen	X	30%	12%
Paper	X	20%	17%
Stapler		0%	7%
Keyboard		10%	8%
Laptop		75%	60%

Meaning that, for instance, You have chosen pen and so have 30% of the participants of your country and 12% of all participants.

So, with this kind of data set I need a simple chart next to each percentage. This line would have a min of zero and a max of 100 and the size based on the percentage of each cell.

I also need this line to be rendered in PDF so I cannot use javascript.

I have tried with a micro chart inside the list cell but it requires a master-detail relationship even when the query is the same. it doesn't allow me to use "Section the detail query" option; it errors asking for a master-detail relationship.

I created a dummy query with one data item [Value] (expression: ?pValue?). Then I send the percentage itself as part of the master detail relationship. This renders the line as I want it but it takes ages to run the report. A data set with 100 rows takes 2 seconds (in PDF) without the line and around 3 minutes with all the charts.

Another option I thought of was to create a block with a background color and change the size based on the value, but I don't see how to change the size dynamically.

Any ideas???

Thanks,

Bark

[MFGF]

I think a micro chart embedded within the list is exactly the right approach.

I'd suggest the micro chart query contains the "Item" query item and the desired percentage. You can then link this via master/detail to the List query based on Item.

Cheers!

MF.

[Bark]

Thanks MF; I agree with you, it seems the most sensible approach but my client will not accept the generation times.

I have been working on workarounds and I tried one last night. I used dummyimage.com (it generates a .jpg based on the URL) to generate a bar with the width based on the percentage number. After trying this, I realised that the problem is not in the Cognos Chart but in the PDF generation. It also took a long time to generate the report with the images.

I have been looking at the tuning settings but I don't seem to get my head around them. Anyone has played with those options before?

Thanks and regards,

Bark