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 TouchToneTommy 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 rdrose2499

  1. rdrose2499

    Release Crystal Report Object in ASP page

    I have generated a very basic ASP page in which the user supplies a start date that then runs another ASP page which does some processing and when the processing is complete, the ASP page does a response.redirect to the Crystal Report that I have created. All is well until the user clicks the...
  2. rdrose2499

    Using count with field in DB and another formula

    Actually, what you suggested worked except I found out as I worked through my logic that I am actually working with 2 different recordsets. The closed parameter looks at the tech field whereas the logged total comes from another field call callreceivedby. I'm trying to figure out another way to...
  3. rdrose2499

    I have a report in which I need to

    Ok, I did as you suggested, however because the count for calls closed looks at the "tech" field and the count for calls logged looks at the "callreceivedby" field, I still am having trouble using a running total or formula for the count on the logged calls. How do I use 1...
  4. rdrose2499

    I have a report in which I need to

    Yes, the first SQL statement is the SQL generated in the report and yes I did modify it to only show me techs who are part of the team "desktop". As for the second select, that is what I need to do somehow in a formula for the logged calls total. Basically I have to create a report...
  5. rdrose2499

    I have a report in which I need to

    I have a report in which I need to specify how many tickets a tech has logged and closed for each day. I am able to get the closed value to display correctly. However, my logged field is a little tricky. In the table, the field CALLRECEIVEDBY is the what is first populated when a ticket is...
  6. rdrose2499

    Using count with field in DB and another formula

    Ok, I had actually done the first part where I set a formula for each of the column headers. However I'm perplexed with how to write the formula in the running total. If I were to write this out in SQL it would be something like this: select count(id) from calls where calldate =...
  7. rdrose2499

    Using count with field in DB and another formula

    I am trying to build a report that will do 3 things. One, the user enters a date, then on the report going across the top the date they entered is in the first column, then the subsequent columns increment by one so that I can display a week's worth of data at a time. Now, on the row, I have...
See more

Part and Inventory Search

Back
Top