i have to develop report or Oracle 11g.
so i want to install Report Designer stand alone. not BI Server Or data Integration.
is it possible to install report designer only for Oracle or SQL Server?
Short Answer: Yes, you can install just PRD along with the appropriate jar files to create reports for MS-SQL or Oracle.
Creating the reports themselves is somewhat limited usefulness, as you cannot schedule the execution, cannot allow user-driven execution, etc. These are the features that BIServer provides.
Sometimes, there are complex pieces of calculation that you will want to do. These calculations (for example joining data from multiple databases) would be best completed with PDI. As such, there is a version of PDI embedded in PRD.
In the end, it all depends on what you want to accomplish.
Retrieving data ...