Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Bentk

  1. Bentk

    Help with this report query for sum data

    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...
  2. Bentk

    Help with this report query for sum data

    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...
  3. Bentk

    Summary conditional

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

    Summary conditional

    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
  5. Bentk

    Phone # Formula or Function

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

    Phone # Formula or Function

    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
  7. Bentk

    Count Total Records for a group-- Start Over for next group

    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...
  8. Bentk

    Show Text if DB date = Blank

    Thank you. That worked like a champ! -Bentk
  9. Bentk

    Show Text if DB date = Blank

    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.
See more

Part and Inventory Search

Back
Top