Sunday, 3 April 2016

What is difference of Eval and Bind functions in ASP.Net?

Eval function is Read-Only binding.
It takes the name of data field and return  a string for the value for that field.
…………….
<tr>
<td>Full Name </td>
<td><%# Eval(“FullName”) %></td>
</tr>

Bind function is Updateable binding. Therefore, data can be modified.  This method is used with input controls such as TextBox.

…………………
<tr>
<td>Full Name </td>
<td>
<asp:TextBox id=”txtname” runat=”Server” Text = ‘<%# Bind(“FullName”) %>’>
</td>
</tr>

Both functions are used within delimiters <%# and %>

Tuesday, 8 March 2016

How to add Serial Numbers into Crystal Report?

1. Open a crystal report.
2. In Field explore, right click on "Running Total Fields". Then click "New"
3. In Edit Running Total Fields Dialogue box, 
     - Give a name for running total name.
     - Select a report field and add it to "fields to summarize"
     - In Type of Summary, select Count.
    - In evaluate part, select  "For each record"
    - In Reset part, you may chose "Never" or "On Change of group"
   - Then, click Ok
4. Finally, drag the field to the report which you want.

Tuesday, 2 February 2016

How different Use Expert and Use Editor in Formula workshop in Crystal Report?

The difference between Expert and Editor is the the formulas created in the Editor are saved with the report which are created in and can only be used in that report.
Formulas created in the Expert can be saved as a Custom function and can be used in any report.

If you have to use the same formula in several reports, copy it to the Formula Expert and save it as a custom function.

Tuesday, 12 January 2016

How to add Formula Field in Crystal Report

1. Right Click on Formula Fields which is in Field Explorer
2. Click New
3. Then, you will get the Formula Name dialog box.
4. You should type Name for formula and Click Use Expert or Use Editor.
5. For this post, I will use Use Editor.
6. You will see the Formula Workshop.
7. Based on your requirements, You may double click on table fields or Report fields and Operators.
8. Then you many check the Check the Error using Alt+C or click Check button which is located on the top left side.
9.If you find No Error, you can click Save and Close button.
10. Finally, you can drag that formula field into your report.