Skip to main content

Common crystal report code for asp.net program

Image
By 

 Imports System.Data.SqlClient  
 Imports CrystalDecisions.CrystalReports.Engine  
 Imports CrystalDecisions.Shared  
 Imports System.data  
 Public Class CrysReport  
 ‘Variables Declaration  
 Private obj As New Class1  
 Dim crParameterDiscreteValue As ParameterDiscreteValue  
 Dim crconnectionInfo As New ConnectionInfo  
 Dim crParameterFieldDefinitions As ParameterFieldDefinitions  
 Dim crParameterFieldLocation As ParameterFieldDefinition  
 Dim thisFormulaField As CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinition  
 Dim crParameterValues As ParameterValues  
 Dim crtableLogoninfos As New TableLogOnInfos()  
 Dim crtableLogoninfo As New TableLogOnInfo()  
 Dim CrTables As Tables  
 Dim CrTable As Table  
 ‘This function is to shows value through formula text  
 Public Sub report_date_formula(ByVal crReportDocument As CrystalDecisions.CrystalReports.Engine.ReportDocument, ByVal from_date As String, ByVal to_date As String)  
 Try  
 For Each thisFormulaField In crReportDocument.DataDefinition.FormulaFields  
 If thisFormulaField.FormulaName = "{@From_Date}" Then  
 thisFormulaField.Text = from_date '"#" & dt1.Value.Date.ToString("dd/MMM/yyyy") & "#"  
 ElseIf thisFormulaField.FormulaName = "{@To_Date}" Then  
 thisFormulaField.Text = to_date '"#" & dt2.Value.Date.ToString("dd/MMM/yyyy") & "#"  
 End If  
 Next  
 Catch  
 End Try  
 End Sub  
 ‘This function is to call report parameter  
 Public Sub report_parameter(ByVal crReportDocument As CrystalDecisions.CrystalReports.Engine.ReportDocument, ByVal name As String, ByVal value As String)  
 Try  
 crParameterFieldDefinitions = crReportDocument.DataDefinition.ParameterFields  
 crParameterFieldLocation = crParameterFieldDefinitions.Item(name)  
 crParameterValues = crParameterFieldLocation.CurrentValues  
 crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue()  
 crParameterDiscreteValue.Value = value  
 crParameterValues.Add(crParameterDiscreteValue)  
 crParameterFieldLocation.ApplyCurrentValues(crParameterValues)  
 Catch  
 End Try  
 End Sub  
 ‘ This function to make connection to database for report  
 Public Sub report_connection(ByVal crReportDocument As CrystalDecisions.CrystalReports.Engine.ReportDocument)  
 Try  
 With crConnectionInfo  
 .ServerName = "xyz"  
 .DatabaseName = "abc"  
 .UserID = "sa"  
 .Password = ""  
 End With  
 CrTables = crReportDocument.Database.Tables  
 For Each CrTable In CrTables  
 crtableLogoninfo = CrTable.LogOnInfo  
 crtableLogoninfo.ConnectionInfo = crConnectionInfo  
 CrTable.ApplyLogOnInfo(crtableLogoninfo)  
 Next  
 Catch  
 End Try  
 End Sub  
 End Class
Labels:

Popular posts from this blog

Song Aankhen Khuli Ho lyrics notation

By
Song : Aankhen Khuli Ho Movie: Mohabbatein Notes used : W=>Western - C D E F G- A- B-/ H=>Hindustani - S R G M P- D- N- ( Here for western, G=G-, A=A-, & B=B- ) ( For hindustani, P=P-, D=D-, & N=N- ) Song I : Aankhen Khuli...Ho Ya.. Ho Bandh W=> A.... C... B..C.. E.. E...... A... A.... H=> D... S... N..S.. G G....... D... D.... Deedaar Un Ka Ho.o.taa Hai.. W=> A...B....A....D.BAG....ADB... H=> D...N...D.....R.NDP...DRN... Kaise Kahoon Main O..Yaaraa W=> B..D.. D....E.... D.....C..C..C... H=> N..R.. R....G... R.....S..S..S..... Ye Pyaar Kaise Hota Hai W=> E...B.....DB...AG...B..AA H=> G...N....RN...DP...N...DD (Tururu ru ru, ru ru rururu ru......) W=> AA...GA...BCE..., B...DB..GA H=> DD...PD...NSG..., N..RN.. PD Song II: Aa.aj He Kisi..par Yaa.ro.on..., Marke De..Khe..gein Hum W=> E....FEDCBABC.D.. D D......., G A B C.... E.......D...D..... H=> G....MGRSNDNS.R. R R......., P D N S.....G........R...R.... Pyaar Ho...
1 comment
Read more

All songs notation and chords at one place

By
Song : O Saathi Re Film : Mukhathar Ka Sikkandhar Uses : C D D# E G A Note : The numbers at the end of the lines indicate line numbers. Pallavi: O saathi re, tere binaa bhi kya jina, tere binaa bhi kya jina A- C D D#....,D D C DD E...C..CA-...,D D C DD E...CC.......1 Play line 1 again phulon men khaliyon men sapnom ki galiyon men GGG...GAGE.. GGG G A G E.................................................2 tere bina kuchh kahin naa E A G E D C D D#.......................................................................3 tere binaa bhi kya jina, tere binaa bhi kya jina D D C DD E....C..CA-..., D D C DDE....CC.............................4 Charanam: har dhadkan men, pyaas hai teri, sanson men teri khushboo hai CCC C D C A-, CCC C D C A-, DDD DED CD EE.. CCCC......................5 is dharthi se, us ambar tak, meri nazar men tu hi tu hai CCC C D C A-, CCC C D C A-, DDD DED CD EE.. CCCC......................6 pyaar yeh tute naa GGG... GAG D#......E............................
Read more

PHP Tips-Getting the nodes list of xml doument with responseXml in ajax ,call image save in database,time difference etc

By
Getting the nodes list of xml doument with responseXml in ajax var obj = ""; function callAjaxObj() { try { obj = new XMLHttpRequest(); } catch(e) { try { obj = new ActiveXObject("Msxml2.XMLHTTP"); } catch(e) { try { obj = ActiveXObject("Microsoft.XMLHTTP"); } catch(e) { alert("your browser doesn't support ajax"); return false; } } } } function testResponseXml() { callAjaxObj(); obj.open("get","sample.xml",true); obj.onreadystatechange=function() { if(obj.readyState==4) { var doc = obj.responseXML.documentElement; //var doc = obj.responseXML; alert(doc.getElementsByTagName('user').length); } } obj.send(null); } Example of calender script in PHP calender script in PHP echo " $title $year "; echo "SMTWTFS"; $day_count = 1; echo ""; while ( ...
Read more