How to run Crystal Report using Crystal Report Viewer in VS.NET 2005?

hi madam, how can I show a result of sql query in a crystal report.

but how i get the selected data in the crystal report with the selection formula..

you halp me a lot.. thanks for your code i run the crystal report very well thanks again..

Article seamed stright forward, still I am seeing a blank report. I want to pass in to the report all of the data as parameters. In the debugger when I step out of frmReport_Load the blank report is displayed. Since this is new to me I assume that there should be buttons on the report and there are not, the body is white. Below is part of my code. Option Strict Off Option Explicit On Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Friend Class frmReport Inherits System.Windows.Forms.Form ' g_bTempLabel ' frmPackaging.lblRM ' frmPackaging.lblReleaseWO 'UPGRADE_ISSUE: BoxLabel object was not upgraded. Click for more: 'ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?keyword="6B85A2A7-FE9F-4FBE-AA0C-CF11AC86A305"' Dim report8x11 As New BoxLabel ' 8.5" x 11" 'UPGRADE_ISSUE: BoxLabel4x6 object was not upgraded. Click for more: 'ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?keyword="6B85A2A7-FE9F-4FBE-AA0C-CF11AC86A305"' Dim report4x6 As New BoxLabel4x6 ' 4" x 6" Dim report As Object Friend WithEvents crViewer2 As New CrystalDecisions.Windows.Forms.CrystalReportViewer Private Sub frmReport_Load(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles MyBase.Load Dim S As String 'Dim crViewer1 As New CrystalDecisions.Windows.Forms.CrystalReportViewer '= New CrystalDecisions.Windows.Forms.CrystalReportViewer Dim crDoc1 As New CrystalDecisions.CrystalReports.Engine.ReportDocument 'Dim crDoc1 As New ReportDocument Dim pvCollection As New CrystalDecisions.Shared.ParameterValues() Dim crParName As New CrystalDecisions.Shared.ParameterValues Dim crParValue As New CrystalDecisions.Shared.ParameterDiscreteValue 'UPGRADE_WARNING: Screen property Screen.MousePointer has a new behavior. Click for more: 'ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?keyword="6BA9B8D2-2A32-4B6E-8D36-44949974A5B4"' System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor S = "C:\Documents and Settings\bmurphy\Desktop\UpGrades\Packing\packingVB8\BoxLabel4x6.rpt" crDoc1.Load(S) Debug.Print(crDoc1.DataDefinition.ParameterFields.Count) S = "fldBoxNumber_barcode" crParValue.Value = "BoXnUmBeR_BC" crParName = crDoc1.DataDefinition.ParameterFields(S).CurrentValues crParName.Add(crParValue) crDoc1.DataDefinition.ParameterFields(S).ApplyCurrentValues(crParName) S = "fldBoxNumber_formated" crParValue.Value = "BoXnUmBeR_fmt" crParName = crDoc1.DataDefinition.ParameterFields(S).CurrentValues crParName.Add(crParValue) crDoc1.DataDefinition.ParameterFields(S).ApplyCurrentValues(crParName) S = "fldCustomerPN_barcode" crParValue.Value = "CuStOmErPN_BC" crParName = crDoc1.DataDefinition.ParameterFields(S).CurrentValues crParName.Add(crParValue) crDoc1.DataDefinition.ParameterFields(S).ApplyCurrentValues(crParName) S = "fldCustomerPN" crParValue.Value = "CuStOmErPN" crParName = crDoc1.DataDefinition.ParameterFields(S).CurrentValues crParName.Add(crParValue) crDoc1.DataDefinition.ParameterFields(S).ApplyCurrentValues(crParName) S = "fldCustomerRev" crParValue.Value = "cUsToMeRREV" crParName = crDoc1.DataDefinition.ParameterFields(S).CurrentValues crParName.Add(crParValue) crDoc1.DataDefinition.ParameterFields(S).ApplyCurrentValues(crParName) 'S = "fldCustomerRev_barcode" 'crParValue.Value = "cUsToMeRREV_barcode" 'crParName = crDoc1.DataDefinition.ParameterFields(S).CurrentValues 'crParName.Add(crParValue) 'crDoc1.DataDefinition.ParameterFields(S).ApplyCurrentValues(crParName) S = "fldBoxQty" crParValue.Value = "fldBoxQty" crParName = crDoc1.DataDefinition.ParameterFields(S).CurrentValues crParName.Add(crParValue) crDoc1.DataDefinition.ParameterFields(S).ApplyCurrentValues(crParName) S = "fldMeterRev" crParValue.Value = "MR" crParName = crDoc1.DataDefinition.ParameterFields(S).CurrentValues crParName.Add(crParValue) crDoc1.DataDefinition.ParameterFields(S).ApplyCurrentValues(crParName) S = "fldRadioRev" crParValue.Value = "RR" crParName = crDoc1.DataDefinition.ParameterFields(S).CurrentValues crParName.Add(crParValue) crDoc1.DataDefinition.ParameterFields(S).ApplyCurrentValues(crParName) S = "fldDatePacked" crParValue.Value = "1/1/1900" crParName = crDoc1.DataDefinition.ParameterFields(S).CurrentValues crParName.Add(crParValue) crDoc1.DataDefinition.ParameterFields(S).ApplyCurrentValues(crParName) S = "fldDescription" crParValue.Value = "fldDescription" crParName = crDoc1.DataDefinition.ParameterFields(S).CurrentValues crParName.Add(crParValue) crDoc1.DataDefinition.ParameterFields(S).ApplyCurrentValues(crParName) S = "fldFreeForm" crParValue.Value = "fldFreeForm" crParName = crDoc1.DataDefinition.ParameterFields(S).CurrentValues crParName.Add(crParValue) crDoc1.DataDefinition.ParameterFields(S).ApplyCurrentValues(crParName) crViewer2.ReportSource = crDoc1 crViewer2.Show() crViewer2.Zoom(50) End Sub 'UPGRADE_WARNING: Event frmReport.Resize may fire when form is initialized. Click for more: 'ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?keyword="88B12AE1-6DE0-48A0-86F1-60C0686C026A"' Private Sub frmReport_Resize(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles MyBase.Resize 'CRViewer1.Top = 0 'CRViewer1.Left = 0 'CRViewer1.Height = ClientRectangle.Height 'CRViewer1.Width = ClientRectangle.Width End Sub End Class

in windows application with vb.net for using crystal reprt i hve following queries 1) i need to set custom paper size for my report. how do i set the same . i had tried externally from server properties/ create new form in printer settings i had set the name as newrpt with custom size but i am not able to get that name in the printer options 2)instead of setting data & link thr' design i need to bind the report controls for getting the data displayed using SQL queries as i can make joins & getthe dsired output where do i write the queriy & bind it , do i need to use XSD??

crtstal report viewer

hii, I want to learn how to use Olap in Crystal Reports,So can you send me any link are any suggestions in this issue to my id [email protected]

code is very easy to implement for a starter........ grt work....

code is very easy to implement for a starter........ grt work....

I am wanting to be habing a freindly with self myself. Good Day

I love your thinking

Dear Sushmita, i am working with c#.net 2.0 Professional edition for creating c#.net application(simple & easy),finally i got strucked with the thing-"how to add report viewer in c#.net express edition? ", there is no option available in toolbox in c#.net 2.0 Pof. edition IDE,but for visual web developer . so please find me a solutions and give some live demos & presentations to design and develop reortviewer in c#.net 2005 Professional edition. Awaiting for reply.

Hello Your presentation is helpful for all developers and students. Can I convert my project written in VB.6.0?

hello Ms. Sushmita can u help on my report. Im using VB.Net 2005 and Crystal 9. When Im going to print the individual order payment, sometime it was empty. This is my code: Dim m_Application As CRAXDRT.Application Dim m_Report As New CRAXDRT.Report m_Application = Nothing m_Report = Nothing m_Application = New CRAXDRT.Application m_Report = m_Application.OpenReport("c:\$Pharmacy_Multi$\report\report2.rpt") With m_Report .DiscardSavedData() .EnableParameterPrompting = False .ParameterFields(1).ClearCurrentValueAndRange() .ParameterFields(1).AddCurrentValue(Me.lblOPid.Text) End With With FrmCrystal_OPayment.CrysNameDennis ‘this is the form containing the crystal viewer’ .ReportSource = m_Report .refresh .ViewReport() Refresh() End With FrmCrystal_OPayment.Show()

Hi There. I am using visual Basic 2005 Express Edition and i do not have Crystal Reports Add ins. I do have Crystal Reports 8, 8.5 and 9 Installed. how do i add it as an addin

hi, sushmita , i am using first time crystal report ,well i understand all tht u provide in this article but ihave a query tht shld we connect sql server or bind directly without using oledb ,it is possible ,plz revert back to me . harikesh dubey

the rptViewer is not decleared in your example and i have set the code to a button that should kick off the report. am i correct in this? i am using vb.net 2005

Can I change Export Options in Crystal Report Viewer?

Can I change Export Options in Crystal Report Viewer?

Hai Mam, Your article is good.. about crystal report I need to pass parameter from coding to report to filter the report data. I pass the datatable as same pattern, I want to filter records by passing parameter from coding while passing data table to reports viewr. And how display a query of sql in crystalreport at run time? So,Pls sending code in C#,net to my mail id ie. [email protected] thanx in advance

This is to send my great appreciation to Madam Sushmita kumari. Even though it is 2 years back that you posted this, it is still crucial to the new comers to have this a best resource with graphical demo. Thanks.

Dear Madam, I am again posting you the query.In my application,after generating the crystal reports ,I need to pass the parameter at runtime and I have an dropdown list and for the selected month , i need to generate the report .I am using asp.net 2.0 with vb.net coding.Any help from you would be appreciated .Thanks in Advance.

Hi! I need to pass parameter from coding to report to filter the report data. However when I pass the datatable as same pattern, you have used but report shows all data by inner joining two selected tables of my database While I want to filter these records by passing parameter from coding while passing data table to reports viewr. thanx in advance

Hi, Thanks for your kind words. SAJID KHAN

hello madem, 'Get the Report Location Dim strReportPath As String = Application.StartupPath & "\" & strReportName & ".rpt" i apply above code in ASP.NET 2003 but display the error in Application.StartupPath. plz guide me error is('StartupPath' is Not member of 'System.Web.HttpApplicationState') thank you

I like this article, but it only works in Windows Application. What i need is like this but would work in a WEB APPLICATION. Thanks.

Dear Sushmita, i am working with VS 2005 standard edition for creating .net application(simple & easy),finally i got strucked with the thing-"how to add reportviewer in VS 2005 standard edition? ", there is no option available in toolbox in VS 2005 stan. edition IDE,but for visual web developer , i got reportviewer adds-ins from www.gotreportviewer.com site, so please find me a solutions and give some live demos & presentations to design and develop reortviewer in VS2005 standard edition. Awaiting for reply.

Hello Sushmita After a lot of searching in Internet i found u r the right person to contact for this issue of mine.... i hope u reply asap I was using Crystal Reports.NET in my project which used Visual Studio.NET 2003. I was using multiple subreports in my report files..Also i had control over the subreport object...showing/hiding it dynamically whenever required using ----------------------------------------------- subreportobject.ObjectFormat.EnableSuppress = True/False property ----------------------------------------------- Now since my project is now upgraded to Visual Studio.NET 2005, i have to use the Crystal Report.NET that ships alongwith the VS.NET 2005...After upgrading my reports project in .NET 2005 i'm getting many problems..... outta this main problem seems to be this Now i no longer have control over the subreport objects. i.e i cant hide/show the subreports dynamically using..... ---------------------------------------------- subreportobject.ObjectFormat.EnableSuppress = True/False property ...since this property has been made readonly ....!!!!!! ---------------------------------------------- Is there anyother way to suppress/show the subreports dynamically ??? Please help as it is very urgent Thanks in advance Srivatsa

can i hide some of exports option from dropdown . like if i want to enable only PDF export option is dropdown list.

Hi Sushmita On ASP.Net 2005 I've successfully created a report wth your code. Thanks. But I was unable to print it. I've read that the best way is to export this report at PDF format thirst and then print it. With your code, can you please show me how to export that report at PDF format? Goni Eric

One of the best cod eI have ever seen to populate Crysta viewer. I have become fan of your's.

How to insert an image in Crystal Report? using crystal Report wizard. From the Field Explrer, i hav drag n droped the image.It displays in design , but in run time , it doesn't shows the image? Thanx in advance for ur solution Rgds, Suji

Hello,Sushmita This Artical Is Useful For crating dynamic row. but i want to add dynamic column to crystal report at runtime in asp.net. and whatever data into dataset just import whole data into crystal repoprt. how can i get this? My Emai Id is [email protected]. Plz Send soln to this Thanks In Adcvance Ripal Patel

Thank U Mam, Your coding of crystal report is very nice but i need coding for sub reports of crystal reports in ASP.NET 2.0 if possible please send me the code in my email id [email protected] Thanks in advance Regards Manoj.

how can i make a report from access the data from 2,3 different data tables.

Hai Sushmita, This is Leojhose... I want ur help in regarding the following issue... I am currently working in ASP . NET with C# platform and i need to generate the crystal report dynamically in this.... say for example a customer buys some items in a shop and the sales person is ready to generate an invoice and when he enters all the item descriptions, rate and so on... and at the last when he clicks the generate invoice button the invoice should be generated as a report dynamically. plz help me in this issue.... Awaiting for ur earliest reply.... Regards... LeoJhose.A

Sushmita, I am currently using VS.NET 2005. I have created a main report which displays Lead Information. I have created a second report which displays Lead Note Information. I have added the second report to the Main report as a Subreport. I linked the two reports using the Subreport Interface and linked them by the Lead_ID key field. However, when I run the report, the subreport is not filtering data based on the Lead_ID of the main report. I have done this numerous times in VS.NET 2003 and have had no problems. Is there anything special in VS.NET 2005 to link a subreport to a Main report? Thanks, Josh

Hi Sushmitha, i am using Visual Studio 2003,i am unable to see Crystal Report Viewer control in toolbox,i have added all the references,but still i am unable to view it. i can copy the html code from other page where Crystal Report Viewer is used,it's visible now on the page,but while i am deploying it's giving me error. so please give me the solution for this

hi am using .net 2005, after installing(windows application), it shows error when taking the report. the error is "it shows a form to enter user anme and passwrd". can u help me.. sreejith p krishnan

Hi Sushmita, I am Rajesh Ruhil. I have a problem in using crystal report with vs.net 2005. Whenever we add a Crystalreportviewer in the aspx page, it creates some assemblies in the web.config file, and when I deploy the application on the client machine it shows me an error, the error is because client is using Crystal Enterprise 9. So please tell me the solution how can I resolve the issue if we are using Crystly Report 10 at the development time and when we deploy it at client end it has Crystal enterprise 9.

Hi Susmita, Is it possible to open the reports designed in Crystal report 9 in Visual studio 2005? The reports was not open .Plz tell the resion and how to open these reports. Kamal...

hello how display a query of sql in crystalreport at run time?

Hi sushmita I'm kamal.I have doubt in crystal report version 9.The crystal report version 9 is standalone version.I have some reports in crystal report 9. Is it possible to open the crystal report version 9 report files in Visual studio 2005? Please help me. Regards. Kamal.

when i use report in visual studio 2005 then i click on report then i click on field the dotted rectangular will appear , i want a clear image means don't show the dotted line it is possible then help me thanks sandeep

i want to allow my customer to define criteria by themself in crystal report 10 in vb 2005 as i was using it in vb 6 i use "enable select expert button " in the property of crviewer i want to do that same in crystal reports in vb.net 2005 but i cant see this "enable select expert button " property in the property of the cr control in vb.net so i wanna know hows that possible in .net. please reply as soon as possible or send my questions to the experts please my all work is pending without this please solve it as soon as possible thanking you with regards qutub if possible please mail me also on [email protected] so that if i hav any query next i can directly mail u

i want to allow my customer to define criteria by themself in crystal report 10 in vb 2005 as i was using it in vb 6 i use "enable select expert button " in the property of crviewer i want to do that same in crystal reports in vb.net 2005 but i cant see this "enable select expert button " property in the property of the cr control in vb.net so i wanna know hows that possible in .net. please reply as soon as possible or send my questions to the experts please my all work is pending without this please solve it as soon as possible thanking you with regards qutub if possible please mail me also on [email protected] so that if i hav any query next i can directly mail u

Hi, I just want to ask u that how to change the font style of a single column in the datagridviewer in vb.net. Ok Bye

I'm using Vb.Net 2003, I has a store proceduce which columns number changes in runtime. How can I create a report which can show all fields from this store proceduce ? Can you help me? Regard Ngoc

Do u want to edit the report?

Dear miss sushmita.. i have a problem where i am required to edit the columns that are previewed in a report (mainly remove columns that are avaiable and then shift the remaining columns) during run time, can you please send me code or a reference to subject any help whould be appreciated.. my email is [email protected] yours sincerly

Dear miss sushmita.. i have a problem where

Dear miss sushmita.. i have a problem

Dear miss sushmita.. i have a

hi sushmita.... As u know i am developing crystal reports XI in .net 2005. I am happy to say all reports are completed successfully. but, only one reports i facing an problem so this wasting my time plz help me in this... my problem is I WANT TO KNOW HOW TO USE LIKE OPERATOR IN REPORTS AND HOW TO CREATE OBJECT FOR AN REPORT... in Vs.Net2005 1. eg: an emp table with job field: manager, salesman, clerk........... now i hav to show an report in an order with group of job field. for example first i have to show all manager in emp table Report eno ename job dob 12 john manager - 13 raj manager - total manager=2 14 santhy clerk - 15 sunil clerk - total clerk=2 and so on............. for this i want to catch count(job like 'm%') and count(job like 'c%') but it arising some errors......... let me know the method to follow ....... Regards santosh..........

how to create and populate the crystal report in asp.net.2005.' i have designed a report , i place the field in report thru command ( sqlquery). but i wanna pass the parameter and i wanna excute my query from asp.net like tis select * from itmdetails where Custid=" & txtcustname.text & " as well as in top of the report i wanna display the custname, custaddresss ( parameter value) and in the report list i wanna display the item details Customer name: xxxxx Customer Address : xxxxx Itmcode ItmName Qty 001 pen 2 002 pencil 35 like this

Subject: Crystal Report with Visual Basic 2005 I tried to get the value of the sring from FieldObject by hard coding. How would I do? I appreciate for your help. Thanks, DEAN

hi sushmita, can we get data in crystal reports according to our requirement i.e., can we get data between two tables (or) for paticular entity (or) for particular location. And more over its becoming 'Hard Code' .the data is trew the database from which we r dragging the respective fields but not choosing from web.config. i think u get me for eg: if we have database in web.config is 'pubs' and if u drag the fields of tables for reports from different database something like 'master' then we r getting the data from 'master' but not from 'pubs' we reqd the data from 'pubs' and also we required between two dates. plz be quick, regards, santoshkumar..............

hi madam, This is again santosh, i have an small query i.e., can we run an application with crystal reports developed in vs.net2005 in an another system that only containing IIS and 2.0 framework without having any .net software( i.e., both vs.net2003 or vs.net2005) ? If not so how to do that. This is my present Problem. one thing i can say is i am able to run an application with out having crystal reports. in the above configure system. why not with crystal reports. If it work by adding any 'dll' ? If so what are the dll's i have to add waiting for

hi madam, This is again santosh, i have an small query i.e., can we run an application with crystal reports developed in vs.net2005 in an another system that only containing IIS and 2.0 framework without having any .net software( i.e., both vs.net2003 or vs.net2005) ? If not so how to do that. This is my present Problem. one thing i can say is i am able to run an application with out having crystal reports. in the above configure system. why not with crystal reports. If it work by adding any 'dll' ? If so what are the dll's i have to add waiting

hi madam, This is again santosh, i have an small query i.e., Can we run an application with crystal reports developed in vs.net2005 in an another system that containing only IIS and 2.0 framework without having any .net software( i.e., both vs.net2003 or vs.net2005) ? If not so how to do that? This is my present Problem. One thing i can say is i am able to run an application with out having crystal reports. in the above configure system. why not with crystal reports. Is it work by adding any 'dll' ? If so what are the dll's I have to add Waiting for your Glorious reply, santoshkumar........

Dear madam, This is santoshkumar, an software developer . we generated an crystal report in vs.net2005 by using your article. but after completly debuging our code it is asking integrated security displaying the name of server ,username,password,database. enter all and clicking logon its getting hanged. plz reply me as soon as possible please... thanks&regards santoshkumar

Dear Sushmita, i am working with visual basic 2005 express edition for creating VB.net application(simple & easy),finally i got strucked with the thing-"how to add reportviewer in Vb 2005 express edition? ", there is no option available in toolbox in vb 2005 exp. edition IDE,but for visual web developer , i got reportviewer adds-ins from www.gotreportviewer.com site, so please find me a solutions and give some live demos & presentations to design and develop reortviewer in both vb and vwd 2005 express edition. Awaiting for reply. Thank U. regards,

how to display the necessary columns only in crystal report at run time. In a table purchae (pid,pdate,rate,quan,total,expdate) How to display the pid,pdate,rate first time and how to display the other columns in then next time at the same report By s.kannan

Good day Sir, I found your

Good day Sir, I found yout

Good day Sir, I found

Hi,, This is saravan ur article is good.. about crystal report my question : how to use autocombobox in crystal report to reterieve the data from sql server or msaccess.. saravan-

I have used ur code to generate report. It works fine but whenever i change the query the crystal report doesnt changes. it shows all the records. I am posting the code also. Please help me regarding it. I also want to know how to print the report to dot matrix printer. qry = "select firstname , secondname , thirdname , firstage , secondage , thirdage , father_husband_name, address1 , address2 , city , pincode , telephone , pan1 , pan2 , pan3 , Nsdlname , nsdldpid , nsdlid , cdslname , cdsldpid , group1 , broker,start_date from client_master, ipo_master where clientid = " & TextBox3.Text & " and report_name = '" & ComboBox1.Text & "'" Dim adapter As New OleDbDataAdapter(qry, cn) Dim dataset As New DataSet Dim rptdocument As New CrystalDecisions.CrystalReports.Engine.ReportDocument adapter.Fill(dataset) rptdocument.Load(strReportPath) rptdocument.Refresh() rptdocument.SetDataSource(dataset.Tables(0)) rptviewer.ReportSource = rptdocument rptviewer.Refresh() rptviewer.ShowRefreshButton = False rptviewer.ShowCloseButton = False rptviewer.ShowGroupTreeButton = False rptviewer.PrintReport()

Hello I want to present a special thank for MS.Sushmita Kumari to this good article about how i can use a crystal report viewer in VS.Net 2005, and i hope she continue in publishig same type of these articles. Zaitoun Rami