How to create a report(using Query or Report Studio)?

[Rohini Suryawanshi]

 Hi All,

Could you please help me, how to create a report (using report or query studio)? I need to create a report wherein on X-axis there are patching percentage count (like 10%, 20% etc) and on Y-axis there are  servers count (100,200 etc).

Note : I am using Bladelogic package.
I have used Join.I tried it in report studio where in Query1 I took IP Address, Missing Patch Count, Installed Patch Count, (Missing Patch Count + Installed Patch Count) , %(Installed Patch Count,(Missing Patch Count, Installed Patch Count)) and in Query2 I took IP Address, Server Attempted count, Server scanned out and joined them applied detail filter like Patch Status (dynamic column concept) on join and Query3 IP Address,Missing Patch Count, Installed Patch Count, (Missing Patch Count + Installed Patch Count) , %(Installed Patch Count,(Missing Patch Count, Installed Patch Count)), Server Attempted count, Server scanned out. And tried to make a graph by taking %(Installed Patch Count,(Missing Patch Count, Installed Patch Count)) on X-axis and Servers Attempted count on Y-axis but I am getting error for %(Installed Patch Count,(Missing Patch Count, Installed Patch Count))  but I could not drag this column on graph. Please suggest for the same.


I cannot attached any file. Please, share the procedure for the same.



Regards,
Rohini Suryawanshi.

[HalfBloodPrince]

could you please check which query is your chart using . I guess you have created calculation in some other query and chart is pointing to different query.

[Rohini Suryawanshi]

Hi,

Yes, it was helpful and I have changed the query where it was pointing to. But when I runned a graph in html it show no data or blank graph. I want to create a graph where on X-axis it must show patching percentage(like 10%, 20%, 30%, 40% etc) and on Y-axis it must show server count (like 50, 100, 150, 200 etc). Please suggest for the same. What I am trying to do is not helping me.

[HalfBloodPrince]

 First try to see that query which you using for chart is showing result using view tabular data. If yes then something wrong with adding columns on chart. Instead of adding all columns at a time , add only one calculation and any other simple text column from query on chart and check.
If query not showing any results then disable all the filter and try.

Let me know if it helps

[Rohini Suryawanshi]

Initially I tried for simple columns using join, where there were no calculations of addition or calculating percentage of columns, that report and graph are working properly. But when I am trying for complex report where there are calculations, it is displayed properly in tabular format and the graph for which I am looking for is not given the proper result like on X-axis server count(50, 100, 150 etc) and on Y-axis patching percentage count(like 10%, 20%, 30% etc).

Could you please help me, how to attached file or paste screenshot so that I can show you the result which I am getting here.

[HalfBloodPrince]

Please provide some details about the data , what calculations you are using so that we  can help.

[Michael75]

Could you please help me, how to attached file or paste screenshot so that I can show you the result which I am getting here.

Choose Attachments and other options below the box where you enter your message. You can add one attachment per post.

[Rohini Suryawanshi]

Hi Michael75,

Today I can the see option of Attach where we can attached a file. But that day I could'nt see this option to attach a file.

Thanks!

[Rohini Suryawanshi]

Hi,

As I am looking for the graph like on X-axis server count(50, 100, 150 etc) and on Y-axis patching percentage count(like 10%, 20%, 30% etc).

Calculations I have done is :
In Query1 the Data Items are, { IPAddress, Installed Patch Count, Missing Patch Count, (Installed Patch Count + Missing Patch Count) named as PatchAddition, %(Installed Patch Count, PatchAddition) named as PatchPercent }
In Query2 the Data Items are, { IPAddress, Server Attempted Count, Scanned Server Count, Not Scanned Server Count }
Joined them, IPAdress to IPAdress.
In Query3 the Data Items are, { IPAddress, Installed Patch Count, Missing Patch Count, PatchAddition, PatchPercent, Server Attempted Count, Scanned Server Count, Not Scanned Server Count }
In Report Pages, Page1 : Dragged List from Insertable Object and inserted the all columns from Query3 and inserted chart on X-axis I gave Server Attempted Count and on Y-axis I gave PatchPercent.
But I am not getting the expected result.

Please find the attached file.

[Rohini Suryawanshi]

Hi,

I have shown the calculations in which way I have done. Please, can I have an update on this.I unable to find the servers count and show in on a graph.

[BigChris]

Your graph is going to be showing the total of the Scanned Server Count column etc. which I'm guessing comes to a figure of something like 2,550. I can't see anything wrong with the graph that you've posted.

[Rohini Suryawanshi]

I have made a sample report using paint, I want the graph to be created in this way. Please find sample graph attached here. And suggest for the same.

[Rohini Suryawanshi]

Can I have an update on this please? I have attached sample report in this way I need to create it. Please suggest fot the same.

[BigChris]

Are you aware that this is not some sort of help desk? This is a forum populated by people doing their day jobs who try to give a little help and guidance as and when they can. Your emergency does not necessarily constitute a priority for the rest of us

[Rohini Suryawanshi]

Yes, I am aware of this. But since from few days I am doing that and stucked there only. So, looking for some help and guidance.

[bdbits]

You really have not provided the actual calculations, only a representation of them. It would be ideal if you could attach a copy of the report definition, but barring that pasting the actual expression you are using might be helpful to finding a solution. e.g. %(Installed Patch Count,(Missing Patch Count, Installed Patch Count)) is not a valid Cognos expression. It would also be helpful to indicate if this is a relational or dimensional source, since I am sure others like myself have little idea of what Bladelogic is giving you.

You may also want to review items 1 and 2 in http://www.cognoise.com/index.php/topic,24030.0.html.