Use Existing Report Template with New Data

Running Crystal Report for updated excel data updated with new data!!

So if you want to Run the Report with Existing Template with the Updated Excel or the data Connection

Ref. check Data Connections.

You might notice there are not exact calculations or the exact format or the font.

You may want to check the Data of the field  -> Go To Field Explorer right click on the Data field and browse data.

So might delete fields and map the same again . so the new data gets in.

Ma be some fields MAY contain the previous data , even though you made all your connections correct.

Crystal Reports Display Only one Record Per page

Working on Crystal Report is cool!!
Every  thing i write on my blog is actual issues/problems or discovers worked out in real time scenarios.

So

My requirement was to Display 1 record on one page or to Suppressing the blank page .

1. Open Crystal  Reports -> Blank Report-> Get the data either from BW or excel or any other source.
2. Drag and drop the required fields onto the page to view the Report.
3. To view 1 record per page : Go to Section Expert from the menu or right click on the required section.
4. Section Expert in the Group Footer. select the check box for suppress blank pages & New Page After. 
5. Beside them we have X+2 formula tab. 

           PageNumber=TotalPageCount

           save and close.

           Now Run the report..

           Every page is displayed with Record No and Record Details.

Access Crystal Report Using Excel Data

Using Crystal Report with Excel Data !!!

1. Name the Excel Sheet and Set the Headers with the Field Names highlighted , Bold Letters .
2. Make sure you format field i.e Currency, date, Text, General, etc.
3. Now open Crystal Reports , It opens up Database expert or you can click Database expert on the menu bar.
   
4. In the DataSources , open a Create a New Connection ->  select Access/Excel (DAO).
5. You can see a new window to input excel file. Database Name is your file path and Database Type is Excel 8.0 or other (version try it to be latest versions  to eliminate bugs) & click finish
6. Here on the right side of the window you can see Path Name and the Excel Sheet Name.
7. Note: If you dont find your Excel Sheet , you may want to check right click on the file name in the database expert -> select option and make sure Table name or owner like is empty. As you are creating a new report .
8. once you see you table in the field browser, then you have table data which is ready to use.
9. And Imp is to check the Database -> Log on or off server. -> create a new connection and add in file .

Vertical or Horizontal Axis Labels, Number Format

Well ,
Everyone Likes to see data in common terminology, not dragging eyes to count how many series of Zeros in that Number .

Here is an Example of the Year to Date Totals for Budget and Actual.

You Could Just fix this :

1. Inset a Column Chart or Any Other Chart you wish to use.
2. Go to Behavior Tab-> Scale 
3. Now you can find Fixed Label Scale-> click on the Check box   

By Checking this Field you can instantly see the result on you Dashboard..