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

Show separate Summary of the Report from that Report

Started by mohsin2010, 12 Jan 2011 03:35:20 AM

Previous topic - Next topic

mohsin2010

Hi
  i want to show the summary of the report along any where in the report means not at the end n middle of the report like i have done in the report  attached !
   i want to show the no of employees along with the country in the side of the report separately

Help me out ????

Best Regards,

Syed Mohsin Raza


MFGF

I don't understand your post, my friend.  What exactly do you want to do?  Your attached image appears to be a grouped list report with a count of employees per country in each country group footer.  Is this what you are trying to achieve, or do you already have this and want something different?

MF.
Meep!

mohsin2010

MFGF,
   
        in the attachment i have counted the employees group wise according to the country but i want to do the same thing in the report separately means that in the report above the table separately showing no of employees according to the country as shown below,
  Canada=4 employees
  United States of America= 5 employees
  .
  .
  .
  No of total Employee=106

and under this summary there will be the remaining report as i shown in the previous attachment without having no of employees per country.
       i tried it to drag the counted object in the separate table as well but on my every experiment it give error "this object can only be inserted in the data container" in spite of that table is a data container. 

Best Regards,

Syed Mohsin Raza




mohsin2010

MF,

    what ever i wrote in the previous post i tried to do that and get a little bit success as i mentioned in this attachment "Summary" but i want to show the same data that is in the small table but not in the table format.. . i m not getting that  :(

Best Regards,

Syed Mohsin Raza

Gnani

Hi Mahamood,
As per i understand u need a summary report with country and no of employees above/ below the detail report.
If this is the case then

  • take another list(query2)
  • drag country and employee name in the query2 (list query)
  • create a data item with expr: count ([employee name] for [country])
  • now add country and new data item in to the list
  • place the list wherever u want in the report layout
  • run the report

I think u will be satisfied with my ans. Let me know.

Thanks,
Gnani

mohsin2010

MF,

    what ever i wrote in the previous post i tried to do that and get a little bit success as i mentioned in this attachment "Summary" but i want to show the same data that is in the small table but not in the table format.. . i m not getting that   :(

Best Regards,

Syed Mohsin Raza

mohsin2010

Gnani,

   Its Mohsin not Mahmood ... .n thanx for telling me i did as you mentioned but question is still there i do not want to show in the "Table" format and as i did in that report as shown in the attachment "Summary" a cannot freely move the small table according to my need. . ..

Best Regards

Syed Mohsin Raza
   

mohsin2010



Now its Some thing like that .. .(Summarize Report) but how to move the small report freely if i align the page left align both reports go to the left side and i want only the small report to left align  ???

Thanks in Advance,

Syed Mohsin Raza

Gnani

Mohsin,
Sorry to call mohamood..
U can take table with 1colx2rows and place summary list in the first row detail list in the second row.
adjust the alignment to only for the first row to left then second row won't be effected.
set the border color of the list to white then u can't see the list it looks as it is some text in structured format.


Cheers,
Gnani

mohsin2010

Now its Some thing like that .. .(Summarize Report) but how to move the small report freely if i align the page left align both reports go to the left side and i want only the small report to left align   ???

(Sorry for posting the same Post twice actually i forgot to Attach file with that.. .post )

Thanks in Advance,

Syed Mohsin Raza

Gnani

Mohsin,
U can see sol in my latest reply.


Thanks,
Gnani

mohsin2010

Gnani,
 
        thanks for your solution but it will not meet my requirement first of all 1col*2rows do not work properly because summary is giving error and i cannot count employee group wise country and the second thing is that my requirement is that when once we have created report then its summery will created through data provided for that report we do not have to use any other query for the summery

   but in our case we are creating another table and query which is not the case .. .  :(

   do you have any other idea then help me out ??

Thanks,

Syed Mohsin Raza

MFGF

Sorry to muppet you again, but I think the above solution should work. Just to clarify a little further, you now have two separate lists in the page body, but they are located directly within the page body itself and you cannot align them independently, is this correct?

If so, drag a 1 column 2 row Table from the toolbox directly onto the page body. Select the entire first list object (hint, click on any item in the first list then use the 'select ancestor' arrow at the top of the properties area and select 'List' from the menu of ancestors) then drag and drop the selected list so it sits inside the upper table cell. Repeat the process for the second list, but drag it into the lower table cell. You should then be able to align the contents of the two table cells (ie the two lists) independently.

Regards,

MF.
Meep!

mohsin2010

Hi MF,
         
         As my thinking is concern your reply helps me to drag the column of table easily and helped me a lot  but i am getting confuse for dragging any object of the list to any where in the PAGE BODY ??
   as you told me in the previous post i get it but how do i get the summarized
data as i want as shown in attachment "REQUIRED" ??

          because i can not let me to drag particular object like (object of summarized employee according to country) and when i create another list to drag these object to that list it will ask for "Query 2" while it should get data from the previous query "QUERY 1"  ???

Regards,

Syed Mohsin Raza
   

   

mohsin2010

MF,

     like in .Net crystal reports we can apply any aggregate function like max,min etc on any list or do some  some calculation and the object get after that will be drag easily any where i want to summarized my data in such a manner is it not possible???   and with the same query i want to do this because on dragging another table it creates another query??

MFGF

Quote from: mohsin2010 on 13 Jan 2011 11:49:05 PM
Hi MF,
         
         As my thinking is concern your reply helps me to drag the column of table easily and helped me a lot  but i am getting confuse for dragging any object of the list to any where in the PAGE BODY ??
   as you told me in the previous post i get it but how do i get the summarized
data as i want as shown in attachment "REQUIRED" ??

          because i can not let me to drag particular object like (object of summarized employee according to country) and when i create another list to drag these object to that list it will ask for "Query 2" while it should get data from the previous query "QUERY 1"  ???

Regards,

Syed Mohsin Raza

Hi,

Your REQUIRED attachment shows the summary footer values alongside each other at the top of the page, and left-justified.  To get this kind of side-by-side layout, you will need to use a Repeater object rather than a List.

So - as with the previous suggestion, bring in a table, and move your List object inside the lower table cell.  Then drag a Repeater from the toolbox into the upper cell.  Once you have done this, click on the repeater to select it, and in the Properties pane on the left, change the Query property of the Repeater to use Query1 (the same query as the list).
From the Data Items tab, drag your Country item from the query into your repeater.  Then from the toolbox, drag a text item into the repeater following the Country item, and type in a colon ( : ) and a space as the text.  Next, go back to the toolbox and drag a Query Calculation into the repeater after the Text item - call it StaffCount, and define the expression as count([your employee item from the query] for [your country item from the query])   Finally, drag another text item into the repeater after the query calculation and type in a couple of spaces.

You can then left-justify the top table cell containing the repeater, and middle-justify the lower table cell as required.  You may also want to add some formatting to the values in the repeater to match your group footers in the list, but that should be very straightforward for a man of your talents! :)

Regards,

MF.
Meep!

mohsin2010

MF,

     It goes with out saying ... . it works.

Thanks,

Syed Mohsin Raza