You searched for the word(s): userid:823339

More Search Options

RSS Available

• Re: Button click even to open crystal report

  I guess this didn't work like I thought it would I am still having some problems. I have a Windows Form button that when I click on it I want to be able to bring up a Crystal Report in a new FOrm. The Form has a Crystal Report Viewer in it. How do I do this with the code I have below, this is the button click code(need to know what goes inside the button click code: private void btnReport1_Click(object sender, EventArgs e) { }

  Posted to Web Forms (Forum) by bootzilla on 12/31/2009

• Re: Button click even to open crystal report

  Thanks this helped.

  Posted to Free For All (Forum) by bootzilla on 12/24/2009

• Button click even to open crystal report

  I have a button click event but I don't know what code goes in it to open a crystal report that I have created. The code for the button click is below. I tried typing the name of the report hoping intellisense would pick it up but it doesn't. private void btnReport1_Click(object sender, EventArgs e) { } }

  Posted to Free For All (Forum) by bootzilla on 12/24/2009

• Incorrect syntax near '*' error

  Can someone assist me in why I receive this error on the update statement below and how to fix it. I have this statement as a part of a stored procedure. WHen I execute the entire procedure I get this error but when I highlight just the update statement and execute it updates with no errors. update monthlyinv1 set totalmiles = monthlyinv1.miles * monthlyinv1.qty, totalrate = monthlyinv1.routecost * monthlyinv1.qty from monthlyinv1 inner join RouteMaster on monthlyinv1.ROUTENO =RouteMaster.PUROUTE

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bootzilla on 12/23/2009

• Re: Incorrect syntax near '*' error

  I tried this and still get the same error. I can't figure out where the error is at.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bootzilla on 12/23/2009

• Re: Incorrect syntax near '*' error

  Here it is: ALTER PROCEDURE [dbo].[MonthlyInvReport1] --declare @date DATETIME -- --set @date = '20091223' -- --select -- cast(datename(week,@date) as int)- cast( datename(week,dateadd(dd,1-day(@date),@date)) as int)+1 --AS @S char(1), @M char(1), @T char(1), @W char(1), @R char(1), @F char(1), @A char(1), @counter int, @date DATETIME AS --Run for Sunday-- IF @S = 'S' BEGIN --highlight this section and run-- insert into monthlyinv1(monthlyinv1.ROUTENO,monthlyinv1.MILES) SELECT PUROUTE

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bootzilla on 12/23/2009

• Re: Incorrect syntax near '*' error

  THanks that did it.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bootzilla on 12/23/2009

• Need help doing a calculation in SQL update statement in stored procedure

  I need help with a calculation in a SQL update statement in a stored procedure. I am doing a insert-select combined statement by inserting into a table while selecting from another table. I then update to the table that I was inserting with fields that are not in the insert-select combined statement(hopefully this makes sense). On the update statement below I am trying to calculate the Mileage rate minus fuel times the total miles ran. So basically I need 1.3748-0.028 X DailyCSV.EMILEAGE. I am not

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bootzilla on 12/21/2009

• Re: Need help doing a calculation in SQL update statement in stored procedure

  I don't understand when you say I need a decimal (12,4) for Mileage_Rate and E_FuelSurcharge. Where would that go in my code and how would I code that? I am using an update statement because I am not able to insert all of the fields into the table using the insert statement because some of those fields aren't available to be inserted from that table. So I do an insert first and then go back and do an update for the rest of the fields.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bootzilla on 12/21/2009

• Re: Need help doing a calculation in SQL update statement in stored procedure

  Come on. SUrely there has to be someone who can help here. I tried setting a variable in my stored procedure like this and get an incorrect syntax error near '=': SET y = (DailyCSV.MILEAGE_RATE - DailyCSV.E_FUELSURCHARGE * DailyCSV.E_MILEAGE)

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bootzilla on 12/21/2009