Explore topic-wise InterviewSolutions in .

To edit crystal REPORTS LAYOUT in the SAP business one

GO to the main menu of the SAP business one -> choose administration ->set up -> General -> Report & Layout Manager

In Report & Layout Manager window, in the navigation panel on the left, scroll down to the DOCUMENT type of the layout you need to edit

In the work space on the right, select the crystal reports layout you need to edit and select edit.

To edit crystal reports layout in the SAP business one

Go to the main menu of the SAP business one -> choose administration ->set up -> General -> Report & Layout Manager

In Report & Layout Manager window, in the navigation panel on the left, scroll down to the document type of the layout you need to edit

In the work space on the right, select the crystal reports layout you need to edit and select edit.

To CREATE SAP BUSINESS token the general syntax includes
<Parameter Name>@ SELECT….FROM…..WHERE, the SELECT COMMAND is not NECESSARY for all tables.

To create SAP business token the general syntax includes
<Parameter Name>@ SELECT….FROM…..WHERE, the SELECT command is not necessary for all tables.

• SSRS has table BASE design pattern while in CR you can place objects anywhere
• Export to Excel in SSRS is easy than Crystal Report
• To manage your data crystal report have several options while SSRS does not have any
• Crystal report has client side report creation API, that allows the client to modify and CREATE new reports
• SSRS uses expressions while Crystal Report uses formula in C and basic
• SSRS is compatible with Share-point list and can generate reports based on LISTS
• Both of them support OLAP CONNECTIONS

For crystal reports the data-source that SAP BUSINESS one SUPPORTS are 

1. SAP Business One
2. OLE DB (ADO)

For crystal reports the data-source that SAP business one supports are 

In SAP Crystal, you have following FEATURES:

• Streamlines REPORT design
• Improvement to DATA sources
• Mobile and viewer support
• OEM and developer features

In SAP Crystal, you have following features:

0-256

0-256

CALLING crystalreportcontrolname.reset (by SELECTING Report menu under Refresh the report menu item at design TIME) will refresh the report[crystalreport1.DiscardSavedData=True]

calling crystalreportcontrolname.reset (by selecting Report menu under Refresh the report menu item at design time) will refresh the report[crystalreport1.DiscardSavedData=True]

1. Select the FIELD
2. Click FORMAT
3. Click FORMAT FIELD
4. Select the FONT TAB
5. Click the FORMULA BUTTON to the RIGHT of FONTif ({YourField} = Value) then “Arial”else “Times New Roman
6. Click SAVE Icon
7. Close the formula editor
8. Click OK on the FORMAT screen

Crystal in its evolution has changed the REPORT file FORMAT several times. In most cases the file format is FORWARD-compatible. By this I mean a file CREATED in Crystal 6 can be opened in Crystal 6 or higher. When the file format changes were major the format is not BACKWARD compatible. By this I mean a file created in CR 9 cannot be opened in CR 8 or before. Crystal changed the report file format with CR 8 and CR 9. The CR 9 change was because of the introduction of Unicode SUPPORT. CR 8 has the ability to save a file in CR 7 format. Because of the support for Unicode CR 9, 10, and XI cannot save the file in PREVIOUS formats.

Crystal in its evolution has changed the report file format several times. In most cases the file format is FORWARD-compatible. By this I mean a file created in Crystal 6 can be opened in Crystal 6 or higher. When the file format changes were major the format is not BACKWARD compatible. By this I mean a file created in CR 9 cannot be opened in CR 8 or before. Crystal changed the report file format with CR 8 and CR 9. The CR 9 change was because of the introduction of Unicode support. CR 8 has the ability to save a file in CR 7 format. Because of the support for Unicode CR 9, 10, and XI cannot save the file in previous formats.

YEAH we can do that USING CRYSTAL REPORT.

Yeah we can do that using crystal report.

Select the field –>Click FORMAT–>Click FORMAT FIELD–>Select the COMMON tab–>Click the FORMULA BUTTON to the right of SUPPRESS (Don’t click the suppress check BOX)To suppress a field on odd numbered pages PageNumber MOD 2 = 1To suppress a field on even numebred pages PageNumber MOD 2 = 0 –>Click SAVE Icon–>Close the formula editor–>Click OK on the FORMAT SCREEN

Select the field –>Click FORMAT–>Click FORMAT FIELD–>Select the COMMON tab–>Click the FORMULA BUTTON to the right of SUPPRESS (Don’t click the suppress check box)To suppress a field on odd numbered pages PageNumber MOD 2 = 1To suppress a field on even numebred pages PageNumber MOD 2 = 0 –>Click SAVE Icon–>Close the formula editor–>Click OK on the FORMAT screen

If you are getting such an error then CLICK the icon for ‘REPORT EXPERT’. It will give a warning saying that FORMATTING will be lost. Ignore this you will get ‘Standard Report Expert’ dialog box. Reverse the LINKS of access database table and it will work.

If you are getting such an error then click the icon for ‘Report Expert’. It will give a warning saying that formatting will be lost. Ignore this you will get ‘Standard Report Expert’ dialog box. Reverse the links of access database table and it will work.

There are CERTAIN limitations in crystal REPORTS. They are: –
If database is having field whose length is more than 255 characters, then you cannot make formula using that field.
While exporting data formatting is lost.
When you browse data just by right CLICKING on the field then it DISPLAYS that is there in the database not the data SELECTED by the query.

There are certain limitations in crystal reports. They are: –
If database is having field whose length is more than 255 characters, then you cannot make formula using that field.
While exporting data formatting is lost.
When you browse data just by right clicking on the field then it displays that is there in the database not the data selected by the query.

We cannot edit the SQL made by crystal REPORTS. However we can view the SQL. For that select ‘SHOW SQL Query’ in DATABASE menu item. LIMITATION is if you are using only one database. If you use two databases then you can’t even view the SQL prepared by crystal report.

We cannot edit the SQL made by crystal reports. However we can view the SQL. For that select ‘Show SQL Query’ in Database menu item. Limitation is if you are using only one database. If you use two databases then you can’t even view the SQL prepared by crystal report.

We can ALSO make our own query using ‘Crystal SQL Designer’ TOOL provided by SQL. Here you can INSERT your SQL statement as such. It will save this file as ‘.qry’ . And when you CREATE a report instead of using ‘Database’ button use ‘Crystal SQL Statement’ button.

We can also make our own query using ‘Crystal SQL Designer’ tool provided by SQL. Here you can insert your SQL statement as such. It will save this file as ‘.qry’ . And when you create a report instead of using ‘Database’ button use ‘Crystal SQL Statement’ button.

Generated data can be exported to word doc, or in rich TEXT format. Just click on ‘Export’ icon in the MENU. Export dialog box will be popped up. It will ask for the ‘Format’ like comma-separated value (csv) etc and the ‘Destination’ like disk, application etc. After that it will ask for the file name and save the data.
Only restriction is FORMATTING of data will be LOST, but crystal report will TRY to maintain as much formatting as it can.

Generated data can be exported to word doc, or in rich text format. Just click on ‘Export’ icon in the menu. Export dialog box will be popped up. It will ask for the ‘Format’ like comma-separated value (csv) etc and the ‘Destination’ like disk, application etc. After that it will ask for the file name and save the data.
Only restriction is formatting of data will be lost, but crystal report will try to maintain as much formatting as it can.

We can create our own formulas in reports. Select ‘Formula Field’ in INSERT menu item. Write the formula in ‘Formula EDITOR’. Here you will get ‘Field TREE’, ‘Function Tree’, and ‘Operator Tree’, which will display the report fields, functions that are supported by CRYSTAL reports (LIKE CDATE () etc.), operators (arithmetic, strings etc.) respectively.

We can create our own formulas in reports. Select ‘Formula Field’ in Insert menu item. Write the formula in ‘Formula Editor’. Here you will get ‘Field Tree’, ‘Function Tree’, and ‘Operator Tree’, which will display the report fields, functions that are supported by crystal reports (like CDATE () etc.), operators (arithmetic, strings etc.) respectively.

Answer :There are two ways of creating the report: – Use crystal report BUILT in query. Use the tool ‘ Crystal SQL Designer’ provided by crystal report. When you create report using crystal report built in query then it asks for the data SOURCE name that you have CREATED. When you run the report, then for the first time it will ask for the user id and password. After that it will store the same. When you create ‘.qry’ using ‘Crystal SQL’ Designer then at that time it will ask for the user id and password. When you run the report for the first time instead of asking for the user id and password it will ask for the ‘.qry’ file location. You can CHANGE the query location also. For that open the report, select ‘Set Location’ option in Database menu item, and set the location.

Answer :GENERALLY we use Crystal Reports with VB6. HOWEVER we can MAKE crystal REPORT stand-alone application also. But for that limitation is for viewing the report user should have crystal reports installed on his/her PC.

Crystal report is a report generation tool. GENERALLY have interface with VB6. Crystal report basically generates DYNAMIC data. You can FORMAT the data in WHICHEVER way you feel like.

Crystal report is a report generation tool. Generally have interface with VB6. Crystal report basically generates dynamic data. You can format the data in whichever way you feel like.