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

What is a universe?

8 Answers   TCS,

HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?

1 Answers  

u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources

4 Answers   IBM,

Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?

2 Answers   Wipro,

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

0 Answers   Infosys,

Hi , iam beginer in the Boxi . I am getting errors when i applying the @promtps and functions. I want alredy created universe and i absorve the things how those were applied . is it possible to get it throug internet? if it is possible could u plz help me? anandh1110@gmail.com

2 Answers  

How to link one location universe to other location universe

3 Answers   Cap Gemini, TCS,

WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?

4 Answers   Ericsson, Nokia,

How do u Receive requiremnts from the client?

3 Answers  

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

0 Answers   Arkema pte Ltd,

how can i add two different reports in the same document?

5 Answers   TCS,

CAN A REPOSITORY CONTAINS REPORTS?

7 Answers   AG Technologies,