About running crystal report on client side in c#

Question

2.40/5 (2 votes)

See more:

Hi All,

I have copied .mdf and .ldf files of database in bin/debug folder of my application and used the connection string as follows

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\hm.mdf;Integrated Security=True;User Instance=True
where hm=database name
application runs fine but now i am getting new error while running and after creating set up file.I copied .mdf file and .ldf file in set up project and also in bin/release folder and then total application runs fine but now i am getting error in crystal report asking for user name and passwords.

Please suggest me for the same.

Thanks in Advance.

Posted 15-Jun-11 22:10pm

mayur csharp G

Updated 15-Jun-11 22:14pm

Ramalinga Koushik

v2

Add a Solution

Comments

karan joshua 16-Jun-11 4:13am

In crystal report have u given user name and password?

1 solution



        
        

        
        
        Add a Solution
        

    

    
    
	    




Add your solution here


















	

		
		

		

		
		

		
		
            








Plain Text
ASM
ASP
ASP.NET
BASIC
BAT
C#
C++
COBOL
CoffeeScript
CSS
Dart
dbase
F#
FORTRAN
HTML
Java
Javascript
Kotlin
Lua
MIDL
MSIL
ObjectiveC
Pascal
PERL
PHP
PowerShell
Python
Razor
Ruby
Scala
Shell
SLN
SQL
Swift
T4
Terminal
TypeScript
VB
VBScript
XML
YAML













	
	
		
		
		
        
	
	






	OKPaste as

    
	
	
		Strip HTML
	

		Encode HTML
	

		Paste as-is
	

		Code block
	

		Quoted Text
	

		Best guess
	

	

	
		To display as
		
		
		
	

The content must be between 30 and 50000 characters.
		

		

        

		
			Treat my content as plain text, not as HTML
		

		
		Preview 0
		…

		
		

		
		

		
		



	
	
	
		Existing Members
			Sign in to your account
		
...or Join us
			Download, Vote, Comment, Publish.
		

	

	

		
		

			
			
				Your Email  
				
			
			
				Password  
				
			
			
				
					
					Forgot your password?
				
			
			

		
		 

		

			
			
				Your Email  
				
					
				
			
			
				
					This
					email is in use. Do you need your password?
					
				
			
			
				
					Optional Password  
					
					
				
			
			
				
					
				
			
			

		
		 

		
	

	

	

	
		I have read and agree to the Terms of Service and Privacy Policy

		Please subscribe me to the CodeProject newsletters
	






		
		
		
		
			Submit your solution
		
		

		
		

        
        

		
		
	    	When answering a question please:

		    
			Read the question carefully.
			Understand that English isn't everyone's first language so be lenient of bad
			spelling and grammar.
			If a question is poorly phrased then either ask for clarification, ignore it, or
			edit the question and fix the problem. Insults are not welcome.
            Don't tell someone to read the manual. Chances are they have and don't get it.
                Provide an answer or move on to the next question.
		    
		    Let's work to help developers, not make them feel stupid.
		
		

	

    
	

	
    

	






    

    
    This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kushal.patil121 · Accepted Answer · 2011-06-15T23:10:00

We are also getting the same error, then we will create a data set and pass the record to report (Where crystal report viewer is) . Its call Push report.

Here is the code



ReportDocument cryRpt = new ReportDocument();

                TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();

                TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();

                ConnectionInfo crConnectionInfo = new ConnectionInfo();

MIDL

cryRpt.Load(System.Windows.Forms.Application.StartupPath + "\\PickListRpt.rpt");




MIDL

crConnectionInfo.ServerName = lstrServerName;
              crConnectionInfo.DatabaseName = lstrDatabaseName;
              crConnectionInfo.UserID = lstrUserName;
              crConnectionInfo.Password = lstPass;




string lstrQry =" Your Query ";



                SqlConnection con = new SqlConnection(clsUserInterface.ConnectionString);

                SqlDataAdapter dr = new SqlDataAdapter(lstrQry, con);



                DataSet1 ds2 = new DataSet1();



                dr.Fill(ds2.Tables["dtReport"]);

                cryRpt.SetDataSource(ds2);

MIDL

crystalReportViewer3.ReportSource = cryRpt;
                crystalReportViewer3.Refresh();

About running crystal report on client side in c#

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us