Introductions to Crystal Reports in .NET

Great take on the topic, thanks Mahesh for sharing. While obviously very popular, there seems to be very little development on CR recently. Updates to the latest Visual Studio version also take very long. Maybe I'll write an article with an introduction to a couple of CR competitors - it could be helpful for anyone looking for more modern alternatives.

A good one...

Nice

Need to preview existing report using c#. please share...

I created crystal report but when i creating crystal report viewer in windows form in that crystal report viewer is not showing in tool box.why sir please give suggestion and your answer sir

sir you give proper information about creating report throgh crystal reports.please tell me sir what is crystal report ? You can mail me on [email protected] Thanks in advance

plz how do i add multiple parameters in vb.net

hi i have downloaded your IntroCr.zp i got an error crystal decision could not found are you missing assembly reference.i have tried for addind reference crystal Desicion but its not available please tell me the solution

how to print a person details in c# windows form using crystal reports

is there a way to use crystal reports in vs express edition?

Hello Guys, How are u all,, i have a problem in field expolrer that appear when i add crystal report page, i want to add mdf file. its all ready connected to the project but its not connected to crystalreport page report.prt,,when i choose OlE DB -->microsoft OLE DB provider for SQL server ,,my server shown,but the particular data base that i add (database1.mdf)not appear in database dropdownlist with science that i am using integrated security.i need assistant ,,any one? Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Users\hani.abdalrhman\Documents\Visual Studio 2008\Projects\WebApplication1\WebApplication1\App_Data\Database1.mdf";Integrated Security=True;User Instance=True

hello, my question is how can I have my crystal report on a shared network drive for other users to print reports?

Hi.. This introductory article on crystal reports is very much clear and understandable.

Would you create a short talk on creating CR from a blank document. Please include setting up the datasources and tables with the columns to be intered into the form. Thank you.

Hello Mahesh Chand ! I write a app with crystalreport. I build file .exe and copy to other computer but Crystalreportviewer show not correct. please help. Thank you verry much.

A nice understanding is given overhere. Any one can understand who are in this field. Thanks Mahesh.

Hi, I made report using crystal report and viewer but whenever i am gng to compile the code it is asking for DB user name and password every time. so what can i do to avoid this?

This is my first time doing anything with crystal reports. Actually, I just took over a job half way done and I had to add and delete a lot of forms and hence the previous .docx file was not working and I had no idea how the developer do that. Here I come to CR for Help. In this application whenever you click on a link in then a zip file gets downloaded and this file has docx files already populated with the user whose file was opened. So, I ask for your help so that I can do this easily. Thank you..

hai i want to know more about the crystal report custmizing the main screen customization. About the date file options and how to edit the screen.

I followed all the steps you said.. but in figure 5 i can't connect to server it says "SQL Server doesn't exist or access denied" but i have my database in my localhost server

i have made a crystal report using sql database.but at the time of execution.asking for username and password.what i have to do to avoid this

can you able to post the article on Web Based Crystal Report.....

it was good.. but i'm new to the crystal report i want it in more details with,why should we use crystal report,advantage and disadvantage... hope you will implement this..

how to bind drop down list to crystal report////..... For Eg if we want to create report according to month or year how can we do it ????????

how to create crystal reports in ASP.net

How To sum in formula field in crystalreport in c sharp give me the example of that

How can i install crystal report template in the pre installed asp.net framework..??

Hi Mahesh, do you have an idea of why my SQL Server does not appear in the servers list when I have to specify a data source for the crystal report using the wizard (Figure 5)? Any help would be gladly received, thanks

I wanna create a Crystal Report where there is field where I'll put a link button by which i wanna nevigate the page to certain page with some value that is collected from Crystal Reports....is it possible???

Hello. I have problem, in my Visual Studio there is no Crystal Report file. How can I fix my problem?

r/s thx for providing various coding on this site....

Muy bueno , pero tengo un problema. Yo estoy desarrollando sobre vb.net 2005 y lo tengo subido a un hosting alquilado, luego de errores diversos por que no tenian subidas las dll del crystal (y ponerlas en el bin) me encuento con el siguiente error: “An error has occurred while attempting to load the Crystal Reports runtime.” “Either the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.” “Please install the appropriate Crystal Reports redistributable (CRRedist*.msi) containing the correct version of the Crystal Reports runtime (x86, x64, or Itanium) required. Please go to http://www.businessobjects.com/support for more information. ” Y segun lo que lei en los foros, hay que instalar el *.msi en el servidor (dado que esta alquilado, no me dan esa autorizacion). Es asi?. Hay alguna solucion para poder usar el CR?. Yo lo implemente con el VB4/5/6 y ahora estoy probando con el report viewer y no es lo mismo. Gracias.

i found this post very useful.............. But i have make one project in vs 2011 and when i create new item and select crystal report i found different as in vs 2008 i know how to do it ...... so can u please tell me how to create crystal report in visual studio 2010

How to show only one record in crystal report instead all record based on query with set parameter in vb.net

Hi, This article is really very helpful. But I still have a query that can crystal reports be hosted on a 3rd party server along with my asp.net web application.

Hello , bhai I couldn't find crystal report viewer in toolbox. There is only pointer, text object, line object and box object but no crystal report viewer ...

hii sir, this is firne but i need this article plz help me Crystal Report with dataset using crystal reports 2008

Hello sir, By this article I am clear about creating crystal reports. I have 10 columns in page .At present I am giving the Total count of each column at the last of the page . I want each columnn total at the end of each page.please suggest me what to do Thanx

Hello sir, By this article I am clear about creating crystal reports. I have 10 columns in page .At present I am giving the Total count of each column at the last of the page . I want each columnn total at the end of each page.

it was quiet good but please provide some details to take value from text box and like making a performa invoice or something like this.

Hi Thanks for this article , like your other articles this is really helpful too. whenever i search for some help, your articles come up and assures that you would have explained well and your article would definitely help. My question is that i have created crystal reports in Visual Studio 2008 and i have connected to Oledb SQL server 2008 database using crystal report wizard as expalined above. My reports are generated fine on my local machine , but when i run the exe on my clients machine , it comes up with an error that 'mylocalmachine\SQL EXPRESS' does not exist. Now i only provide exe file to my customers and going to different clients and changing connection their is not the right way , and customers machines would not have visual studio installed on them so please help me with what i should do to avoid in this scenario Regards Sarah <!--Session data-->

Thanks My Dear I found this tutorial very effective for me in understanding crystal reports thanks again.......

i have connected my ms-access database through program. it is working. now i have connected crystal report to my design page.. now whatever fields i have selected while designing the crystal report is coming on my page but it is displying all the row values of the particular column. instead i need a selected rows to display.. all the SQL queries are correct.. please give me the steps tat i must make with code snippet..

I searched for crystal reports more, but not found in past days now i got with understandable explanation a special thank you to the author and this site

error: reportviewer does not exists in this context . reportsource property is not available for reportviewer. I am using visual studio 2005 and Access database please help me out thanks in advance!

Hi Mahesh, <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CJohnS%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <![endif]--> Is there a way to place random markers on a report?<o:p> </o:p>Here’s the problem….customer places an order, later makes some changes. <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CJohnS%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <![endif]-->Can you think of any way to dynamically print icon-like symbols like this in multiple places on the Reports. Please help me out. Cheers, Niyaz Ahmad

how do i attach crystal reports to my database so that i can preview the reports when necessary? my database is vb.net. i also have crystal report installed in my machine but i cant register the dlls..why?

How can we populate Crystal Reports in VS 2005 by using a DataSet? The query i gave in DataSet is not accepted by the Crystal Report tool....Please reply

I forfot to write , that I am using .NET C#

I am new to Crystal Reports. I have saved my data in a .mdf file, which has worked fine til now. How can I connect to my .mdf file?

hi, i am working on windows application VB.NET and using VS2005 but i can't able to find Cryatal Report Viewer in toolbox what could be the reason.

i read this article . it is really helpful. Thanks

thank's to Mahesh Chand from me, because to help me how to use crystal report with C# and DB SQL Server along day i'm find in many book and site, but difficult to understand after to look this site and registration, i'm understand how to make report with crystal report, C# and DB SQL Server. good bless

hi, i am using crystal reports in asp.net websete but when i access the report there is an error "The report you requested requires further informathin" and textboxes requirng servername, database name, user id and password. plz tell me how to solve this proablem

This article of crystal report is very helpful but i have one problem that is whenever i run the crystal report asks for password to connect to the server (MSSQL 2005) ,though i've given it in connection information.can you please help me to sort it.

Can anyone tell me a way out to change column header text in a crystal report viewer at runtime when i choose a particular value from a dropdown

i want to make a form for a report in which one date parameter is used and a button to submit . how i use this button to view report to user directly on click to this button

i want to make a form for a report in which one date parameter is used and a button to submit . how i use this button to view report to user directly on click to this button

Kindly give me guidance about reporting in web Application with example or link Thanx

I have a C# application with a Crystal Report in it. When some users try to execute the application, they get the error 'Exception has been thrown by the target of an invocation'. I'm thinking that they might be missing some DLLs. Any suggestions?

I have a C# application with a Crystal Report in it. When some users try to execute the application, they get the error 'Exception has been thrown by the target of an invocation'. I'm thinking that they might be missing some DLLs. Any suggestions?

I have a C# application with a Crystal Report in it. When some users try to execute the application, they get the error 'Exception has been thrown by the target of an invocation'. I'm thinking that they might be missing some DLLs. Any suggestions?

How to integrate a crystal report 8.0 with sharepoint 2003

How to integrate a crystal report 8.0 with sharepoint 2003

Hi, I am new to Crystal report. I have a crystal report which has a chart displays data from Database based on the date seleted from the form. How can I give an sqlquery, so that I get my chart in desired format. Could some one please help me in this. Thanks in Advance, Sreejith Manjalavil

Hi, i have a cross tab in my report.The first column, which shows the checknames from the database.I need to show a heading for that column.Usually in cross tab there is no heading for the first column.I need immediate help.

Explain About ADO,RDO& DAO I m confused abt this let me know the difference Thanks

Hi;i read your mail its very helpful but sir still i am unable to geneate report.please help me hoe i code,which class or namespaces should i add.if you send me some piece of code that will be very help ful for me; Anees..!

I have a report created in Crystal 8 and a C# project. I open the report in Crystal 11 and save it. Then add it to my .net project. When I try to run it I get "Namespace "Report" can not be found. If I leave the report in Version 8 the report at least tries to open but I get a connection error. Can you help please?

Dear Mahesh, I am glad to see your helping atitutde. My email is [email protected] I am using Crystal Report 8.0 with my Single user Windowa Application witth VB.NET 2005 Microsoft Access/SQL 2005 Database. At Design Time I am getting View Report with some unknown data. My Dataset is ok. My Data connection is Ok. My data varification is OK. At Run Time I am detting only column heading which is Text. I am not getting any Data at all. Pl. guide me. Waiting for your response. Regards from Jagdish Patel Mobile - 0091 98256 25965

My VC++ app. developed in .NET2003 works well with crystal reports version 8.0. After I migrated to ver 11, the application does not run properly. It totally fails to create the reports. Is there compatibility issue with using .NET2003 & crystal reports 11 ? What is the least painful workaround ?

i did a crystal report how can i edit it?

I'm migrating my application from VB6 to VB.Net 2005 during which Crystal reports is being upgraded to CRX!-R2 with in VS2005. I have suppress the Parameter Prompt as the application manages the parameters and is not transparent to users. This was done by setting the property oReport.EnableParameterPrompting = False '(In VB6) I'm trying to achieve equivalent in CR.Net I could not figure out how to Achieve this. Some one please help me. thanks in advance.

How do i pass the Data need to run a crystal report from another web page?

I am trying to do this : paramField.set_ParameterFieldName("test"); But I get the following error : 'CrystalDecisions.Shared.ParameterField.ParameterFieldName.set': cannot explicitly call operator or accessor Please let me know what is the meaning of this and how can i rectify.

I am trying to do this : paramField.set_ParameterFieldName("test"); But I get the following error : 'CrystalDecisions.Shared.ParameterField.ParameterFieldName.set': cannot explicitly call operator or accessor Please let me know what is the meaning of this and how can i rectify.

Please discuus elaborately about supressing the columns in report in accordance with the need

Hi ive made a report using Crystal report viewer and crystal report tool and my Database is Oracle 9i but the problem is that before it shows the report it asks the Database login first and i dont want my users to know the Oracle password .wat can i do? Please Help me

Hi ive made a report using Crystal report viewer and crystal report tool and my Database is Oracle 9i but the problem is that before it shows the report it asks the Database login first and i dont want my users to know the Oracle password .wat can i do? Please Help me

I have a XML file specified as Database File for a Crystal report. The problem is, the XML is having only 2 columns. But i want a report wherein the columns might get added or deleted based on the condition(selection of some attrbiutes). Please let me know how I can go about this. Also kindly tel me whether my approch of using the XML file is correct or not.

I have a XML file specified as Database File for a Crystal report. The problem is, the XML is having only 2 columns. But i want a report wherein the columns might get added or deleted based on the condition(selection of some attrbiutes). Please let me know how I can go about this. Also kindly tel me whether my approch of using the XML file is correct or not.

By this article iam clear about creating crystal reports

How to create customized crystal reports in C#