Crystal Reports for Visual Studio 2010 and 2012

Crystal Reports is a popular Windows-based report writer (report generation program) that allows a programmer to create reports from a variety of data sources with a minimum of written code. Developed by Seagate Software, Crystal Reports can access data from most widely-used databases and can integrate data from multiple databases within one report using Open Database Connectivity ( ODBC ). Crystal Reports uses an ActiveX control called CrystalReport to establish a connection with another program. A programmer can set properties of the CrystalReport control during design time or at run time. The programmer can use automation tools called Experts to be guided through common tasks, such as linking and embedding reports. Crystal Reports treats all text, graphics, and database fields as object s that a programmer can place, arrange, and format on forms. The program also generates a recordset object and code needed to perform programming tasks such as loop s or mathematical calculations. Crystal Reports can create a report on the fly from user-defined variables and can convert it to HTML and publish it to the Web automatically. 

Source : http://whatis.techtarget.com/definition/Crystal-Reports

Crystal report for Visual Studio Download By MITGuru-lk

Crystal Report for Visual Studio 2010 and Visual Studio 2012 Download

Support integration with Visual Studio 2012 and 4.5 .NET Framework runtime. Added support for following platforms:

a.        OS:  Windows 7 SP1, Windows 8, Windows 2012

b.       Database: SQL Server 2012, HANA SP5

c.        Web Browser:  Firefox 16, IE10 (limited support; more information forthcoming soon)

d.       Other technology: IIS 8, Flash 11

• SAP Crystal Reports, developer version for Microsoft Visual Studio SP5 - MSI (32bit)
• SAP Crystal Reports, developer version for Microsoft Visual Studio SP5 - MSI (64bit)

Crystal Report Run time Engine Download

• SAP Crystal Reports, developer version for Microsoft Visual Studio SP5 - built-in Visual Studio ClickOnce “Homesite” location (32 bit)
• SAP Crystal Reports, developer version for Microsoft Visual Studio SP5 - built-in Visual Studio ClickOnce “Homesite” location (64 bit)

More Details : http://scn.sap.com/docs/DOC-7824

1 comment

Posted at 8:16 PM |  by Mit Guru

PHP with MS Access 2010 Database Connection

This tutorial is show how to connect ms access database using PHP and how to retrive data of its table now i have ms access 2010 database in following table

Table name : result

Field names :

• indexNo
• subjectName
• subjectCode
• subjectMark

for this if you using xampp or wampp or something please change this file for suppot .net framework

Find php.ini File

Ex: in xampp environment

C:\xampp\php

Open php.ini file using notepad

Copy and Paste following code and save

[COM_DOT_NET]
     extension=php_com_dotnet.dll

then refresh the xampp

PHP and Ms Access database connection and retrive data

<?php

//Create Connection
$con = new COM("ADODB.Connection") or die("Cannot start ADODB Connection from 'database_conn.php'");

   $con->Open("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" . realpath("dbf/Student.accdb"));

//Retrive Data

echo " <table width='95%' border='1' align='center' cellpadding='0' cellspacing='0' bordercolor='#550055'>    <tr>
    <td width='20%' height='35' bgcolor='#550055'><p class='facTBLHeader facDean'>Subject Code</p></td>
    <td width='59%' bgcolor='#550055'><p class='facTBLHeader facDean'>Subject Name</p></td>
    <td width='21%' bgcolor='#550055'><p class='facTBLHeader facDean'>Mark</p></td>    </tr>";

//retrive result table data (specific Index No)

$index=001;
$sql3=$con->Execute("Select * from Result where( IndexNo='".$index."')");

     while(!$sql3->EOF)
     {
       $subCode=$sql3 ->Fields[2]->value;
       $subName=$sql3 ->Fields[3]->value;
       $subMark=$sql3 ->Fields[4]->value;
       echo "<tr>";
     echo "<td  height='26' style='padding-left:10px'>".$subCode."</td>";
     echo "<td height='26' style='padding-left:10px'>".$subName."</td>";
     echo "<td height='26' align='center'>".$subMark."</td>";

      echo" </tr>";
      $sql3->MoveNext();

     }
     $sql3->Close();


//retrieve all subject name, code and mark details of index no 001

If you want to get all details change SQL query Like this.

$sql3=$con->Execute("Select * from Result");

No comments

Posted at 10:49 PM |  by Mit Guru