Answer / sourabh gosain

i have created many complex reports in Business Objects as
well as Crystal Reports. Here are few examples of them.

BO
I have made a report which give activated and deactivated
user for all application of client. for that i created sys
security Universe . Later on i created Free hand sql which
required many derived tables to achieve the functionality.
Finally after getting data on report i created another sub
reports. which were linked to main report. I did this in
webi by passing parameters to reports. That way i created
one main report which had hyperlinks for another reports.
In main report I put one graph which represented final
figures in Pie.

Crystal.
I created a complex report which gave opening and closing
balances for Business. I made formula for defining data in
custom manner. I introduced on demand sub reports for each
business units. I inserted Xcelsius flash object. That
object used feature of drill down. I made pie chart which
gave variances between opening / closing balance and
transactions. For each legal entity When user wanted to see
opening and closing , all he needed is to click the pie
section and an adjacent graph would show data for opening /
closing balance for selected legal entity.

I have many examples with me but due to constraint of
writing much in forums I am mentioning few only .

Answer / thogari

thanks Sourabh Gosain thats helpful. could u please give an example how to explain for complex report on a retail project.
Thanks in advance.

Answer / maryam

Hi Bouser,

I need some examples of reports in SSRS for insurance company. May I have some of your reports?

Thanks

Answer / fayaz

Thanks sourabh, I need some examples of complex reports which you have created...can you please share it to me.

Answer / priti

Hi same question has been asked by me:
I have given ans: I have developed report which gives me all the employee data in the organisation. If I have given employee name it will show me all the data of employee including there in and out time ans average time they spend in the office for a month.
Pls rate my answer.

Answer / bouser

In my senario i have create a complex report for
insurances is in my product create a report for client
details basically one persons having n number of policyies
i will find out the persons partiular report

Answer / sreenivas27

Hi,

complex reports:

I have created many reports using VB macro like

I had created one control report which is defined many Sales
ares, Plants, Sales repcode..... like i have created control
reports and based these refer to created another report
which is refer to control report and run the each area or ,
sales repcode.... like that i have created and these reports
will be published individually on webi.

I thought that these type of reports are called Complex reports

I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)

3 Answers  

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

0 Answers  

WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?

2 Answers  

Please anybody tell me Is Data integration And ETL programming is same..? Thanks in advance....

3 Answers  

how can u find the granularity in fact table

1 Answers   iGate,

how to restrict up to three levels in hierarchy when u do drill mode?

3 Answers   iGate,

Explain is there any other repository domains rather than universe, security, document?

0 Answers  

How can you check the universe?

3 Answers  

what are slowly changing dimensions, confirm dimensions?

1 Answers   Wipro,

How to create predefined filters in B.O.

2 Answers   TCS,

. User wants to modify a report and wants to add additional data. How will you approach.

2 Answers  

what is difference between WEBi Report and Crystal Report?

3 Answers   Cognos, Nucleus Software, Red Cross,