Crystal Report Generation for Data Manipulation

[Reckon]

Hello,

Can anyone provide me details regarding how could we generate Crystal reports to check the records for reference,I am just aware about the crystal reports are basically used for report generation,please help...

Regards

[Khushal]

Here i will suggest how to create crystal reports but this would be in .NET, crystal report viewer that will be docked or normal view in any form.

You have to create object of created report and form that contain report viewer.

dim crp_MyReport= new crp_ReportTest
Dim frm_Viewer=new frm_ViewerTest

If u want to pass parameter
dim parameter system.crystaldecision.shared.parameter
dim parameters system.crystaldecision.shared.parameters
dim parameters=crp_myreport.parameters
for each parameter in parameters
select .parameterfieldname
case "parametername1"
.currentvalue.addvalue(value)
end case
next
frm_viewer.crv_viewer.refresh()
frm_viewer.crv_viewer.reportsource=crp_Myreport
frm_viewer.show()

[X-Ray]

From the Report generation option select all the columns, which are having ISCII data. From Report select Insert Formula, specify any name and select OK. Now it will show a Formula Editor window with title as <formula name>.

Select the Functions Tab and scroll down till you see Additional Functions: section. Here you will find some additional functions provided by GIST SDK. Select one of then and click on select button. The function will appear in the formula text. Select the column name, which you want to convert to ISFOC. Provide the script-mnemonics ("DV" / "DVB".. and so on). Click on Check button to see whether the formula text is correct. Click on Accept button. Apply the font to this formula field. Preview the report.

Syntax for Crystal Report functions:

* Iscii2Isfoc(String, String)
* PcIscii2Isfoc( String, String)
* Iscii7ToIsfoc(String, String)

Since all this three functions are very specific to Crystal Reports, the first parameter is the column name and the second is the script Mnemonic . Before running Crystal Report please ensure the 'Crufliscii32.dll' is in your Windows\Crystal directory.

[Ackley]

You should have to follow these Step 1 :-To open the crystal report document, Right Click on your project.Select Add -> Add New Item. New window will appear as below. Give Name to your selecting second option i.e. As a Blank Report.Now your Crystal Report Document will get opened. On the left hand side there you will see Field Explorer from where you can interact with database.

[greenblue]

Mabybe you can try RAQ Report. I'm using it now. It's a free excel-like reporting tool. RAQ Report Free Edition provides reliable Doc, Demo, Forum, Email support without any costs.