Doubt on crystal report,webi
First of all thank you verymuch for solving my earlier doubts.
Can you pls answer the following as i am facing these questions while attending interviews. I would appreciate you all.
1) How can i use dynamic prompt in crystal reports likewise in WebI. Can you explain with step by step process.
2) How can i hide a complete column in webi (richclient/infoview)
3) In crystal reports Can we create report using more than one database?
4) In crystal reports Can we use our own SQL for creating a report instead of dragging and dropping the objects. can you please explain with an example
5) Is there a way to export the report formulas, like totals to excel? in crystal reports.
6) How can i use stored procedures in crystal reports.
7) In oracle i have a table with some duplicate records what is the query to fetch only the records which are not dupleicated.
8) In crystal reports how can i create prompts static and dynamic prompts (I tried to use parameter fields but i am not getting the data source fields under options)