Understanding Crystal Report Viewers

Hello brother I want to make printersetup at crystal report viewer in VB.Net for change size the paper, can you help me..? thanks

Hi, I have a question about crystal report in visual studio 2008. I use object crystal report viewer for show my report: crystalReportViewer.ReportSource = reportDocument; crystalReportViewer.ParameterFieldInfo = report.ParameterFields; crystalReportViewer.Refresh(); When I change parameter of report on user interface , memory of program is increase about 3-5 MB. How can I clean old data before change parameter ? I don't know where is data of report. Thanks so much!

Hai Mahesh! I want to show data in crystal report using checkbox with respective table columns. when I run my project and want to show crystal report only respective column name is shown in crystal report but respective data is not show. plz help me regarding this. Thanks.!

hello, I have a question, I keep getting an error on crystal reports. Error load report failed - invalid report file path? How can i fix this error

Hi Mahesh, I have a web application (asp.net) that generate report using Crystalreportviewer. I have a viewreport button for load event. It successfully displayed the first page of the report but after clicking on the next button of the crystal report toolbar, it send me an error "Load report failed". Hope you can help on this. Thank you.

Hi Mahesh. Is it possible to display the toolbar items in the CrystalReportViewer application in French (i.e. ZoomFactor in french)?

How do I get my report to open in pdf by default rather than exporting to pdf from the viewer?

Please help me how can i access the closeview button in crystalreportviewer. It has been disabled everytime the data has been viewed.. I want that everytime i search data to view in reportviewer, I want to the crystalreporviewer to close the opened report and back to nothing.. please help me.

Hi chand: How to display the total records and affected records in the tool bar ? ex : 60 / 5000 60 records has been selected out of 5000 records.

hi I want to have a report in my web site, but i can't bind crystalreportviewer, i wrote this code: SqlConnection connection = new SqlConnection ("server=localhost;initial catalog=viewofplists;user id=test;password=123456"); SqlDataAdapter DataAdapter = new SqlDataAdapter("select family,title,facultyfamily,studentno from Query",connection); DataSet Mydataset = new DataSet(); DataAdapter.Fill(Mydataset,"Query"); CrystalReport CrystalReport = new CrystalReport(); CrystalReport.SetDataSource(Mydataset); CrystalReportViewer1.ReportSource = CrystalReport; but debugger said in this line U miss a using directory or reference: CrystalReport CrystalReport = new CrystalReport(); please write for me complete code.

Dear Mahesh, Clicking on the group tree is creating the following exception. "Get page number for group failed. " !!!

actually i have generated a crystal a reoprt and and i want view it on run time in windows form aplication

i am geting this eror when i m using crystal report viewer this is the actual code which i am using ReportDocument doc = new ReportDocument(); doc.Load(@"F:\talal folder\project\Dgwaiter(FINAL)\WindowsApplication2\WindowsApplication2\CrystalReport1.rpt"); CrystalReportViewer1.ReportSource = doc;

Hi Mahesh, my report showing fine but when i click on next button on report viewer toolbar Error Load report failed found. Please HELP me.

Hi Mahesh, Please help me. Im creating a crystal reports and it works fine. But the problem is, when I click the next button, it only go to 2nd page, then it does not go to the remaining page. Here's my code: Protected Sub ButtonNext_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ButtonNext.Click me.LORcrViewer.ReportSource = LORReports Me.LORcrViewer.ShowNextPage() End Sub

How we could place the icon on the different places on the crystal reports through VB.Net 2003 dynamically. Please provide a solution of this particular problem because am facing a lot. Thanks Niyaz Ahmad Email: [email protected] [email protected]

Can anyone provide input on how I may be able to add a new button (to provide custom functionality) to the CR toolbar? I know crystalReportViewer exists, which makes it easy to disable the existing buttons, but I am having difficulty figuring out how to add a new button. Any help appreciated! Thanks...

Hi Mahesh, I have a trial version of crystal report 11. I am trying to find an export to Microsoft word(doc) option from its Export format drop down list but can't find one. I only have Microsoft word(rtf) and Microsoft word editable(rtf). Since I find there are many methods of the Reports Viewer Control missing in the trial version, such as "ExportReport", I am wondering if the normal version has this option for (*.doc) or not. Thanks a lot. Jessica

Hi mahesh, i have developed a asp.net(2.0) web application which has several crystal reports in it. Everything works fine in my local system. But the problem arise when i deploy my website on the iis server in a window server 2003 machine. Can you please describe step by step procedure for deploying a .net webapplication with crystal reports on iis. Please mention even the minute things in detail(Eg- how and from where to get the msi required).

Hi mahesh,

Hello sir I want to ask about creating crystal report in asp.net. We create the crystal report using Data Source Name(DSN). We create data table and pass it according to user selection. Only the problem in crystal report viewer when loaded records in data table has been repeated in .rpt file. Please provide suggestion regards this..

Hi Mahesh, I created a report using crystal reports X1. I then created an aspx page which just calls the report. But when I view the report on the web page, I am not able to edit the group tree of the crystal reports that appears on the left hand side. and hence not able to view the group name. Is there any way by which I can correct this problem? Thanks, Paul

hi, i have a windows application.. is there any way to close only the report in the report viewer? can u help me please.. :) thanks so much! -joyce

Hi, Could you help me? I need to view reports that have more than one page. The problem is, when I select the "Next" button on the CrystalReportViewer control, an error appears stating "Access Denied". Underneath that message is another message stating.... "An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below." and...then the stack trace bit appears below that. Could you help me get it so that when I click the "Next" and "Previous" button on the CrystalReportViewer control that I am able to view these pages without an error? Would be most grateful. Thank you in advance...

hi Mahesh i am a new guy in crystal report i try to desgin a crystal report use the vs2005 and a got the data but the forms didn't show the grouptree how can i do (i try CrystalReportViewer1.ShowGroupTree() and set displayGroupTree=true) but also can't show the grouptree please give me a hand thanks kevin

I'm using VS .Net 2005 built-in crystal report to create a report in C#. Using stored procedure as the data source. Setting the parameters using SetParameterValue(). Parameters are being set well. But when i run the report the message 'Parameter was not supplied' pops up. Can u please help on this? Thanks

I'm using VS .Net 2005 built-in crystal report to create a report in C#. Using stored procedure as the data source. Setting the parameters using SetParameterValue(). Parameters are being set well. But when i run the report the message 'Parameter was not supplied' pops up. Can u please help on this? Thanks

Hi Mahesh, I'm new to Visual Studio 2005 and using the VS2005_Walkthroughs to help me learn through examples. So, I opened the above example available in TutorialSampleCodesProjects through VS 2005_Walkthroughs hit CTRL-F5 and it worked, however when I entered some criteria and then clicked the 'redisplay report' button it did not refresh the report with the entered criteria. It retrieved all data. It's like the selectionformula is not being 'activated' ??? I am using Win XP Pro and I think IIS is configured correctly. Below is the code directly out of the example (Default.aspx.vb). This is giving me all sort of grief. Thanking you in advance Mahesh. Theodore Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Partial Class _Default Inherits System.Web.UI.Page Private Sub ConfigureCrystalReports() selectOperatorList.DataSource = System.Enum.GetValues(GetType(CeComparisonOperator)) selectOperatorList.DataBind() selectOperatorList.DataSource = System.Enum.GetValues(GetType(CeComparisonOperator)) If Not IsPostBack Then selectOperatorList.DataSource = System.Enum.GetValues(GetType(CeComparisonOperator)) Dim mySelectFormula As String = "{Customer.Last Year's Sales} > 11000.00 " _ & "AND Mid({Customer.Customer Name}, 1, 1) = ""A"" " myCrystalReportViewer.SelectionFormula = mySelectFormula selectOperatorList.DataBind() End If Dim reportPath As String = Server.MapPath("CustomersBySalesName.rpt") myCrystalReportViewer.ReportSource = reportPath End Sub Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init ConfigureCrystalReports() End Sub Protected Sub redisplay_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles redisplay.Click Dim mySelectedOperator As String = GetSelectedCompareOperator() Dim mySelectFormula As String = "{Customer.Last Year's Sales} > " & lastYearsSales.Text _ & " AND Mid({Customer.Customer Name}, 1) " & mySelectedOperator & " """ & customerName.Text & """" myCrystalReportViewer.SelectionFormula = mySelectFormula myCrystalReportViewer.ReportSource = Server.MapPath("CustomersBySalesName.rpt") End Sub Private Function GetSelectedCompareOperator() As String Select Case selectOperatorList.SelectedIndex Case CeComparisonOperator.EqualTo Return "=" Case CeComparisonOperator.LessThan Return "<" Case CeComparisonOperator.GreaterThan Return ">" Case CeComparisonOperator.LessThan_or_EqualTo Return "<=" Case CeComparisonOperator.GreaterThan_or_EqualTo Return ">=" Case CeComparisonOperator.Not_EqualTo Return "<>" Case Else Return "=" End Select End Function End Class

i'm open a ReportDocument so set ReportSource of ReportViewer then i close ReportDocument that is export not execute

Hi Do you know how i can stop the Reportprocess? Some Reports with many Data goes 2-3minutes. In earlier Crystal Report Version was a Button to stop Reports with many Data

Hi, i'm using vs.net 2003 (vb.net). is it possible for the crystal report, when click on print button, it automatically print the report without showing the printer dialog? if it is possible, pls help me.. how to do it? thx.

Hi, i'm using vs.net 2003 (vb.net). is it possible for the crystal report, when click on print button, it automatically print the report without showing the printer dialog? if it is possible, pls help me.. how to do it? thx.

Hello Sir I have designed report outside application in Seagate crystal report 7.0 and attached report to C# application using Report viewer. Plz tell me how to pass values to formulas created in crystal report from C# application ,an my database is having passward.

I have a Windows app and am using Crystal XI. I cannot find the correct way to close a report in the report viewer without disposing of the report viewer control itself. ??

Hi I have migrate my asp.net application to 2005 from 2003, but still i am using crystal report assemblies of version 9. I have a report web page where i load my report files dynamically. This page is working fine but the Zoom control is not working i am not able to understand why? thank you.. sandeep...

This example demonstrates how to use to set some of the properties of the MicrosoftMailDestinationOptions class. [Visual Basic] Public Sub ExportToMSMail(ByVal toList As String, ByVal subject As String, ByVal message As String, _ ByVal ccList As String, ByVal user As String, ByVal password As String) ' Declare variables and retrieve the export options. Dim pdfOpts As PdfRtfWordFormatOptions = _ ExportOptions.CreatePdfRtfWordFormatOptions() Dim mailOpts As MicrosoftMailDestinationOptions = _ ExportOptions.CreateMicrosoftMailDestinationOptions() Dim exportOpts As ExportOptions = New ExportOptions ' Set the PDF format options. pdfOpts.UsePageRange = False exportOpts.ExportFormatOptions = pdfOpts ' Set the mail options. mailOpts.MailCCList = ccList mailOpts.MailMessage = message mailOpts.MailSubject = subject mailOpts.MailToList = toList mailOpts.Password = password mailOpts.UserName = user exportOpts.ExportDestinationOptions = mailOpts ' Export the report. exportOpts.ExportDestinationType = _ ExportDestinationType.MicrosoftMail exportOpts.ExportFormatType = _ ExportFormatType.PortableDocFormat Report.Export(exportOpts) End Sub

This example demonstrates how to use to set some of the properties of the MicrosoftMailDestinationOptions class. [Visual Basic] Public Sub ExportToMSMail(ByVal toList As String, ByVal subject As String, ByVal message As String, _ ByVal ccList As String, ByVal user As String, ByVal password As String) ' Declare variables and retrieve the export options. Dim pdfOpts As PdfRtfWordFormatOptions = _ ExportOptions.CreatePdfRtfWordFormatOptions() Dim mailOpts As MicrosoftMailDestinationOptions = _ ExportOptions.CreateMicrosoftMailDestinationOptions() Dim exportOpts As ExportOptions = New ExportOptions ' Set the PDF format options. pdfOpts.UsePageRange = False exportOpts.ExportFormatOptions = pdfOpts ' Set the mail options. mailOpts.MailCCList = ccList mailOpts.MailMessage = message mailOpts.MailSubject = subject mailOpts.MailToList = toList mailOpts.Password = password mailOpts.UserName = user exportOpts.ExportDestinationOptions = mailOpts ' Export the report. exportOpts.ExportDestinationType = _ ExportDestinationType.MicrosoftMail exportOpts.ExportFormatType = _ ExportFormatType.PortableDocFormat Report.Export(exportOpts) End Sub

I am using Visual Studion 2005 specifically VB.net. I am using crystal reports and launching them to the crystal viewer supplied with visual studio. This is working great. How do I export to email? All the other export capapbilities I can find, but I haven't been able to find the answer to this question. Any suggestions? Carrie

Hi Friends I have 2 problem in Crystal Reports. 1] Can i trap the goto event button in .Net because supose my reports containg 5 pages , now i am on 1 st page and pressing goto button and then enter the page number 15 then viewer show me the last page but i want to put a message box that reports contains only 5 pages. 2]In My report viewer "Total page No :1+ " why its not showing the exact page number like "Total page No :5"

Dear Mr.Mahesh, I would like to know the print button click event of CrystalReportViewer1. I have to change status in some user table under that button click event. My software need to change status in some user table after printing report. I use vb.net 2003. Thanks, Nu.

hi mahesh I m kavita,A S/W developer in Delhi. Currently I m Working On A ERP Project(C# With ASP.NET). My Problem Is I don't want to use toolbar in crystal report because it display when I run My Web Application & Also Print with my report. Is there any way to short out this problem if I m using the Nextpage property then (suppose my report filter 3 pages from 10 total pages) the report show all the 10 pages. please help me. also is it possible if I click a record in crystal report it goes to another webForm or Report

Hi Mahesh, I am using VS.NET 2002 for windows application. I used the Crystal Report Viewer and enabled its print button. When click on print button, I realised that the "number of copies" does not work at all. It always prints out 1 copy. Is there a way I can override this setting in coding? Pls advise. Thanks.

Hello Mahesh, It may be very strange but my application is giving this error for some time on some machines and working fine on some other.I'm using VS 2002 with crystal reports. When i debug on the machine the error was thrown while initializing the report viewer.

i need clear description about mobile technology in .net .and the need of sotwares for mobiletechnology.. thanking u ur Well wisher D.Prasad JSoftware Factory

Hai Mahesh! I have to develop crystal reports in ASP.NET.I have generated a report using the wizard, and given it as the datasource to the crystalreportViewer, the data is loaded on to the page(design time) but i can view the page when i run it it gives an error as LOGIN Failed. Can u plz help me Thanks josree