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 am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data

2 Answers  

What is the drill up , drill down, drill by , drill trough ?

3 Answers   TCS,

generally how do we get information for creating universes and reports

1 Answers   Satyam,

How to change the order of prompts in universe?

3 Answers  

is it possible to export the webi reports to crystal reports?with out using businessview?

0 Answers   CTC, TCS,

What happens in BO when a user logs in to Infoview and a rich client like webi?

2 Answers   TCS,

HOw do u migrate from old version to the new version?

1 Answers   AOL,

how many micro cubes can a report can have

3 Answers  

Difference between Decode and Case?

8 Answers   Polaris, TCS, Wipro,

Explain what is the difference between slice and dice and cross tab report?

0 Answers  

HOW TO INSTALL BOXI

1 Answers  

1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?

2 Answers