Click here to Skip to main content
15,902,114 members
Home / Discussions / C#
   

C#

 
GeneralComboBox Scrollwheel disable Pin
R.Myers17-Jan-08 3:41
R.Myers17-Jan-08 3:41 
GeneralRe: ComboBox Scrollwheel disable Pin
DaveyM6917-Jan-08 4:27
professionalDaveyM6917-Jan-08 4:27 
GeneralRe: ComboBox Scrollwheel disable Pin
DaveyM6917-Jan-08 5:00
professionalDaveyM6917-Jan-08 5:00 
GeneralRe: ComboBox Scrollwheel disable Pin
R.Myers17-Jan-08 9:09
R.Myers17-Jan-08 9:09 
Generalrtb / rich text box Pin
Member 394658217-Jan-08 3:40
Member 394658217-Jan-08 3:40 
GeneralRe: rtb / rich text box Pin
Luc Pattyn17-Jan-08 3:55
sitebuilderLuc Pattyn17-Jan-08 3:55 
Generaldisplay image located on client Pin
Chazzysb17-Jan-08 3:34
Chazzysb17-Jan-08 3:34 
GeneralCrystal report stored procedure server location Pin
Scalee17-Jan-08 2:54
Scalee17-Jan-08 2:54 
I have created an invoice like crystal reported,
Which gets it data from a stored procedure with 1 parameter which tells which invoice data to use.

Now the problem is that it always tryes to execute this stored procedure from the server it was created on, I have set the database login but it still doesnt execute from that database.

Now im either looking for a method of fixing this or another method to get the data in.
I have tryed using a dataset using the SetDataSource function but i have no idea how i can assign or even get the fields in the crystal report designer mode to there proper locations.

Thanks

			//create a new report object<br />
			ReportDocument Report = new ReportDocument();<br />
			//check if the factuur.rpt is located in the root directory<br />
			if (File.Exists("factuur.rpt"))<br />
			{<br />
				Report.Load("factuur.rpt", OpenReportMethod.OpenReportByTempCopy);<br />
			}<br />
			//else look if its 2 folder up (bin\debug, bin\release)<br />
			else if (File.Exists("..\\..\\factuur.rpt"))<br />
			{<br />
				Report.Load("..\\..\\factuur.rpt", OpenReportMethod.OpenReportByTempCopy);<br />
			}<br />
			//If both fail display error message and abort<br />
			else<br />
			{<br />
				MessageBox.Show("Factuur.rpt niet gevonden, opdracht kan niet uitgevoert worden");<br />
					return;<br />
			}<br />
			//set database login needed for stored procedure<br />
			Report.SetDatabaseLogon(settings.user, settings.password, settings.server, settings.db);<br />
			//set parameter value, this decides which invoice is display.<br />
			Report.SetParameterValue("@FactuurID", ID);<br />
			//Display the invoice on the viewer<br />
			crystalReportViewer1.ReportSource = Report;<br />
<br />

GeneralRe: Crystal report stored procedure server location Pin
Chazzysb17-Jan-08 3:44
Chazzysb17-Jan-08 3:44 
GeneralChange Components icon Pin
Abhijit Jana17-Jan-08 2:32
professionalAbhijit Jana17-Jan-08 2:32 
QuestionRe: Change Components icon Pin
TJoe17-Jan-08 4:03
TJoe17-Jan-08 4:03 
QuestionWPF - Which Components? Pin
Tomerland17-Jan-08 2:31
Tomerland17-Jan-08 2:31 
AnswerRe: WPF - Which Components? Pin
Philipp Sumi17-Jan-08 2:40
Philipp Sumi17-Jan-08 2:40 
AnswerRe: WPF - Which Components? Pin
DaveyM6917-Jan-08 2:44
professionalDaveyM6917-Jan-08 2:44 
AnswerRe: WPF - Which Components? Pin
Tomerland17-Jan-08 2:46
Tomerland17-Jan-08 2:46 
GeneralKey pressed Pin
t_nedelchev17-Jan-08 1:38
t_nedelchev17-Jan-08 1:38 
GeneralRe: Key pressed Pin
Not Active17-Jan-08 2:12
mentorNot Active17-Jan-08 2:12 
GeneralRe: Key pressed Pin
DaveyM6917-Jan-08 2:38
professionalDaveyM6917-Jan-08 2:38 
GeneralRe: Key pressed Pin
DaveyM6917-Jan-08 2:51
professionalDaveyM6917-Jan-08 2:51 
GeneralRe: Key pressed Pin
Abhijit Jana17-Jan-08 2:26
professionalAbhijit Jana17-Jan-08 2:26 
GeneralRe: Key pressed Pin
Luc Pattyn17-Jan-08 4:00
sitebuilderLuc Pattyn17-Jan-08 4:00 
GeneralShort Keys Pin
t_nedelchev17-Jan-08 1:33
t_nedelchev17-Jan-08 1:33 
GeneralRe: Short Keys Pin
DaveyM6917-Jan-08 1:46
professionalDaveyM6917-Jan-08 1:46 
GeneralRe: Short Keys Pin
t_nedelchev17-Jan-08 1:50
t_nedelchev17-Jan-08 1:50 
GeneralHowto PictureBox to a bitmap Pin
electriac17-Jan-08 0:39
electriac17-Jan-08 0:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.