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

Sign in to leave a comment.

• MA

  mohammed abdullah15y agoPosted Jul 5, 2011, 4:43 PM

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

  abhishek sharma15y agoPosted Mar 11, 2011, 3:01 AM

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

  abhishek sharma15y agoPosted Mar 11, 2011, 3:00 AM

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

  Bob Murphy16y agoPosted Nov 18, 2010, 12:57 PM

  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
• SV

  S VK16y agoPosted Nov 10, 2010, 1:46 AM

  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??
• J

  jutatip16y agoPosted Oct 29, 2010, 6:39 AM

  crtstal report viewer
• SG

  suresh ganji16y agoPosted Sep 24, 2010, 8:42 AM

  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]
• IS

  Imran Salam16y agoPosted Jun 16, 2010, 3:18 AM

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

  Imran Salam16y agoPosted Jun 16, 2010, 3:18 AM

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

  Sushta Guthnar16y agoPosted Mar 22, 2010, 3:49 PM

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

    Sushta Guthnar16y agoPosted Mar 22, 2010, 4:07 PM

    all done. had happy crystal friendly session in my self
• S

  shailendra17y agoPosted Mar 13, 2009, 12:23 PM

  I love your thinking
• BB

  Boochi BB17y agoPosted Mar 4, 2009, 2:30 AM

  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.
• AP

  arvind parashar17y agoPosted Feb 21, 2009, 4:47 AM

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

  DENNIS MANALO18y agoeditedPosted Nov 15, 2008, 10:26 PMEdited Nov 15, 2008, 10:47 PM

  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()
  • 

    mihir soni17y agoPosted Dec 14, 2008, 4:30 AM

    I cannot download your attchement :(
• RF

  Ruchith Fernando18y agoPosted Aug 13, 2008, 12:20 PM

  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
• HD

  harikesh dubey18y agoPosted Mar 26, 2008, 4:08 AM

  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
• BO

  Bruce Olson18y agoPosted Mar 10, 2008, 11:38 PM

  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
• VS

  Viajy Soni18y agoPosted Feb 25, 2008, 12:10 AM

  Can I change Export Options in Crystal Report Viewer?
• VS

  Viajy Soni18y agoPosted Feb 25, 2008, 12:10 AM

  Can I change Export Options in Crystal Report Viewer?
• VK

  vegaiah kodamgundla18y agoPosted Feb 13, 2008, 12:07 AM

  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
• WW

  wegderes wegderes18y agoPosted Jan 8, 2008, 3:14 AM

  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.
• VK

  vijay kumar19y agoPosted Dec 10, 2007, 2:27 AM

  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.
• TA

  Tafheem Alam19y agoPosted Nov 28, 2007, 11:12 PM

  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
• SA

  sajid ali19y agoPosted Nov 22, 2007, 8:03 AM

  Hi, Thanks for your kind words. SAJID KHAN
• SK

  sahadevan karthikeyan19y agoPosted Aug 17, 2007, 2:27 PM

  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
• C

  chanix19y agoPosted Jun 20, 2007, 11:24 PM

  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.
• SS

  saru sai19y agoPosted Jun 12, 2007, 7:00 AM

  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.
• SH

  Srivatsa Haridas19y agoPosted May 30, 2007, 1:56 AM

  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
• PC

  Prashant Choudhary19y agoPosted May 22, 2007, 8:49 AM

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

  Eric Goni19y agoPosted May 17, 2007, 2:22 PM

  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
• VT

  Vijay Tule19y agoPosted May 14, 2007, 5:39 AM

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

  sujanitha N19y agoPosted Apr 26, 2007, 2:34 AM

  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
• RP

  Ripal Patel19y agoPosted Apr 20, 2007, 8:09 AM

  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
• MA

  Manoj Azad19y agoPosted Apr 18, 2007, 9:37 AM

  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.
• MJ

  Megha Jain19y agoPosted Apr 7, 2007, 8:54 AM

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

  LeoJhose19y agoPosted Mar 27, 2007, 8:36 AM

  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
• J

  Josh19y agoPosted Mar 5, 2007, 10:49 AM

  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
• JN

  Jayanth Nadig19y agoPosted Mar 5, 2007, 1:54 AM

  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
• SS

  sree sree19y agoPosted Feb 28, 2007, 12:14 AM

  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
• RR

  rajesh ruhil19y agoPosted Jan 31, 2007, 5:34 AM

  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.
• KK

  kamal kannan19y agoeditedPosted Dec 27, 2006, 9:49 AMEdited Dec 27, 2006, 9:56 AM

  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...
• ME

  masoume eji19y agoPosted Dec 24, 2006, 12:08 AM

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

  kamal kannan19y agoPosted Dec 23, 2006, 10:26 AM

  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.
• SB

  sandeep bhawsar20y agoPosted Nov 23, 2006, 2:24 AM

  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
• QN

  Qutub Naharpura20y agoPosted Nov 21, 2006, 11:44 AM

  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
• QN

  Qutub Naharpura20y agoPosted Nov 21, 2006, 11:42 AM

  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
  • TN

    tajudeen noorudeen14y agoPosted Nov 28, 2011, 6:16 AM

    Hi Susmita Kumari, Good Evening, I have the same problem what Mr. Santhose quoted. That is I want to put the "Select Expert" in my crystal reports viewer control. So that my users can filter the records as they want. I am using Visual Studio 2005. Please suggest as possible as. Thanks in advance, Regards, Tajudeen.
• SJ

  Shubhit Jani20y agoPosted Nov 12, 2006, 11:57 AM

  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
• NN

  Ngoc Nguyen20y agoeditedPosted Sep 30, 2006, 5:27 AMEdited Sep 30, 2006, 5:29 AM

  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
• 

  Sushmita Kumari20y agoPosted Aug 29, 2006, 6:25 AM

  Do u want to edit the report?
• ML

  michel layyous20y agoeditedPosted Aug 1, 2006, 8:34 AMEdited Aug 1, 2006, 9:03 AM

  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
• ML

  michel layyous20y agoPosted Aug 1, 2006, 8:34 AM

  Dear miss sushmita.. i have a problem where
• ML

  michel layyous20y agoPosted Aug 1, 2006, 8:34 AM

  Dear miss sushmita.. i have a problem
• ML

  michel layyous20y agoPosted Aug 1, 2006, 8:34 AM

  Dear miss sushmita.. i have a
• SK

  santosh kumar20y agoPosted Jul 21, 2006, 9:08 AM

  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..........
• SS

  sudha sudhag20y agoeditedPosted Jul 12, 2006, 6:37 AMEdited Oct 26, 2006, 11:29 AM

  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
  • 

    Sushmita Kumari20y agoPosted Jul 13, 2006, 6:02 AM

    Create a parameterized query and populate the dataset and then design the report using the dataset.This way you can design the report as per your requirement. Any question let me know. Sushmita
• D

  Dean20y agoeditedPosted Jul 7, 2006, 2:50 PMEdited Jul 7, 2006, 2:55 PM

  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
  • 

    Sushmita Kumari20y agoPosted Jul 12, 2006, 6:06 AM

    Why uou want to use hard coded value.Can tell me your exact requirement? Sushmita
• SK

  santosh kumar20y agoPosted Jul 7, 2006, 10:46 AM

  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..............
  • 

    Sushmita Kumari20y agoPosted Jul 12, 2006, 6:04 AM

    With drag & drop whatever database you will use your report will take data from that database only.Second thing you can use the parameterized query to create a datasource and then based on that datasource you can design your report. Sushmita
• SK

  santosh kumar20y agoPosted Jul 6, 2006, 7:28 AM

  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
• SK

  santosh kumar20y agoPosted Jul 6, 2006, 7:28 AM

  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
• SK

  santosh kumar20y agoeditedPosted Jul 6, 2006, 7:28 AMEdited Jul 6, 2006, 7:34 AM

  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........
  • 

    Sushmita Kumari20y agoPosted Jul 7, 2006, 3:53 AM

    Can you tell me what you want to say? I haven't understood the below lines from your message. "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. " Sushmita
• SK

  santosh kumar20y agoPosted Jul 5, 2006, 3:38 AM

  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
  • 

    Sushmita Kumari20y agoPosted Jul 6, 2006, 6:34 AM

    Hi Problem is with your database connectivity.Try one thing.Create new project and follow the steps which is mentioned in the article to connect to the database and bind with grid.Then check whether are getting the same error or not ? If not ,then follow the other steps which is required for reports according to the article. Any query feel free to contact. Sushmita
• SV

  Srini vasan20y agoeditedPosted Jun 20, 2006, 2:41 PMEdited Aug 21, 2006, 4:17 AM

  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,
  • 

    Sushmita Kumari20y agoeditedPosted Jun 23, 2006, 5:23 AMEdited Aug 8, 2006, 5:34 AM

    rtyhrtyh Sushmita
• KS

  kannan s20y agoPosted Jun 15, 2006, 2:31 AM

  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
• JM

  Jello Marcelo20y agoPosted May 17, 2006, 11:55 PM

  Good day Sir, I found your
• JM

  Jello Marcelo20y agoPosted May 17, 2006, 11:55 PM

  Good day Sir, I found yout
• JM

  Jello Marcelo20y agoPosted May 17, 2006, 11:55 PM

  Good day Sir, I found
• SM

  saravanan mg20y agoPosted Feb 25, 2006, 12:32 AM

  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-
• F

  fems20y agoeditedPosted Feb 4, 2006, 3:57 AMEdited May 4, 2006, 12:18 AM

  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()
  • AM

    aditya malhotra18y agoPosted Jan 14, 2008, 11:51 PM

    Hi Sushmita Mam, I need to develop a tool using visual basic 6 where in the user has a list of reports(generated using crystal reports 10) displayed on the screen and he can open those files using the crystal report viewer xi. I a pretty new to programming so do not have much knowledge. Can you plesase help me how to develop and code this thing? I would be really obliged. Looking forward to hear from you soon. Regards, Aditya
  • 

    Sushmita Kumari20y agoPosted Feb 6, 2006, 9:02 AM

    Wait for my next upload...........i will provide the solution for your query. Thanks Sushmita
• RZ

  Rami Zaitoun20y agoPosted Jan 27, 2006, 11:26 AM

  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
  • 

    Sushmita Kumari20y agoPosted Jan 28, 2006, 11:11 AM

    Hi, Thanks for your kind words. sushmita
  • A

    asad16y agoPosted Feb 9, 2010, 12:45 PM

    Very thanks to your guide. Your article really helped me. i want to join a company of good developer like you. Can i make friendship with you????
  • 

    Sushmita Kumari16y agoPosted Jun 14, 2010, 4:43 PM

    send me the screen print of error you are getting.

  View 2 more replies