Search results for query: *

Thanks for the hint. That got it to work. Here is the code. declare @ordernum int select @ordernum = 10248 select e.lastname+', ' + e.firstname as emloyee, od.orderid, p.productname, (select Sum (unitprice)from orderdetails where orderdetails.orderid = @ordernum)as ordertotal...

I am trying to create a query to pull up not only the unit cost but also the sum total of an order (sum(unitcost)) and return it to the result set for every line Item. I am writing this for a report and I will filter the data there. I am trying to avoid using a sub report. Here is where I am at...

Thanks you all for the help. This worked like a champ. Bentk

I need to summarize at field conditionally in crystal 8 I need to summarize all the feild "sales" based on this where column a=1 and column b=1 then summarize all "sales" rows where that condition is met I don't want to summarize the "sales" feild where a=1 and b=3 Thanks in advance, Bentk

k Thanks so much, I was not aware of the picture function. That's a lifesaver. Worked like a champ. Thanks, Bentk

I am trying to format a phone number that is a string to look like this. Currently the info returned from SQL is 1234567890 I need to make it format to 123-456-7890 Does anyone know of a function or formula that could make this happen? Thanks in advance, Bentk

I have a report that I need to count the records for each group. First group A. has 16 records returned. Second group B. has 25 records returned. When I use the function recordcount it returns back 41 records for every group. I need it to give me an individual record count for each group. Any...

Thank you. That worked like a champ! -Bentk

I have a report that often times is blank. I need to have it return a statement 'There are no widgets sold for this date range'. I need to supress this line when no information is returned from the DB.