Doubt on crystal report,webi

[former_member184582]

Hi All,

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.

😎 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)

[amitrathi239]

Hi,

1) How can i use dynamic prompt in crystal reports likewise in WebI. Can you explain with step by step process.

Please go through by below link.

http://www.infosol.com/buildpage.aspx?k=cr_tt02

2) How can i hide a complete column in webi (richclient/infoview)

Unchecked the auto height and width box.Set the column width 4px.Change the border color as white or remove border.

And if you are hiding column in middle of table then adjust border accordingly.

3) In crystal reports Can we create report using more than one database?

Yes you can use multiple database in the one report.

Thanks,

Amit

[former_member184582]

Thank you very much amit.

[former_member184582]

can anyone answer my questions.

[Former Member]

Hi,

Please follow the below link which illustrates step by step, how to hide a column in WebI Report:

http://bi.stieper.dk/tip-hide-coloumn-in-web-intelligence-webi-145/

Regards,

Sridevi