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!

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

Search results for query: *

  • Users: spiderusa
  • Content: Threads
  • Order by date
  1. spiderusa

    Excel DSUM Help

    Hello, I have a DSUM formula in my spreadsheet that looks like this - =DSUM(Sheet1!$A:$L, Sheet3!$CK7, Sheet3!$F1:$O2). F1 to O2 in Sheet 3 is a set of fields with corresponding values that the function tests against. Name Name Status Ops Grade Score Amount Date Sum Description <>*AL* FAC...
  2. spiderusa

    Need help with date parameter in stored procedure.

    Hi I'm using this stored proc in crystal reports and need help with it. The trouble is with the dates. I'm not getting any errors but the results are not right. I tried to comment out one of the dates and check the other one. Start date - irrespective of the date entered, the amt is summed to...
  3. spiderusa

    CR9 - Pulling data from another formula

    Hi I'm using Crystal 9 with SQL server 2000. The report has values from 6 tables. Its layout is Id Name Title Section1 Section2....Section 18 1 John Pres Member <Null> <Null> 1 John Board Member <Null> <Null> 2 Mary VP NonMember...
  4. spiderusa

    CR9 - Mail Labels modification

    Hi I'm using Crystal 9. I need to modify the dimension of labels in an existing report. How can I do this? I tried page setup but that only allows to modify the margins and not the gap between or the size of the labels. Thanks.
  5. spiderusa

    Concatenation - column values to row values

    Hi I need to create a report with basically three fields - Name, ID and Titles. Name and ID are present in Customer Table Titles is present in Details table Basically there are several titles for each customer and each title is present as a row in the Details table. The Foreign key is ID. I...
  6. spiderusa

    Using Select expert with derived field

    Hi First time posting here. I need help with using the select expert on a derived field. Basically I have to create two report say 'Customer A with sections' and 'Customer A without sections'. My report has CustomerID, Name and Section (derived field) among others. I have also grouped on the...

Part and Inventory Search

Back
Top