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 Chriss Miller 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: *

  1. spiderusa

    Excel DSUM Help

    It would be better as I have a more than one Dsum criteria range. Rather than use 50 columns in each range, I can input all exclusions in a single cell. The AND makes sense. Any idea how to code it? Thanks.
  2. spiderusa

    Excel DSUM Help

    Would it be possible to add all exclusions in a single cell like = "<>*80" or "<>*()* and so on?
  3. spiderusa

    Excel DSUM Help

    Hi Skip, The code I have in works. It is just that when there are other names to be excluded like '*AB*' or '*80*' or '*()*', I have to create a column for each. There could be 50 different exlusions and I do not want to create or maintain 50 columns. I'm looking for other options within Dsum...
  4. 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...
  5. spiderusa

    Need help with date parameter in stored procedure.

    I removed the 'and' because I was commenting the other parameters and checking for just the end date. the original code was Select @SQL = @SQL + ' where' + ' Customer_id in (' + @CustomerID + ')' + ' and change_date >= ' + @StartDate ' and change_date <= ' + @EndDate ' and...
  6. 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...
  7. spiderusa

    Concatenation - column values to row values

    lbass, Thanks for the inputs. One more question. What if there is a null value and I need to exclude it? I tried isnull(titles) and then isnull({table.title}). both didn't work. Any suggestions? Thanks.
  8. spiderusa

    CR9 - Pulling data from another formula

    Thanks guys. The null values were the problem. I used the same concat formula for the sections and it worked.
  9. 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...
  10. spiderusa

    CR9 - Mail Labels modification

    Thats not good at all. There are so many to do. Thanks anyway.
  11. 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.
  12. spiderusa

    Concatenation - column values to row values

    lbass Thanks for the quick response. I tried your formulae and they worked perfectly. I then joined another table Order Details and each customer has more than one order. So if a customer has 5 orders, each title is repeated 5 times in the display. I tried to insert another group but that...
  13. 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...
  14. spiderusa

    Using Select expert with derived field

    It worked. I converted the null value to 'No' and now its working..I'm stupid I guess. Thanks for the replies guys.
  15. spiderusa

    Using Select expert with derived field

    lbass. Thanks for replying. If I can have your email, I'll send a sample spreadsheet. and yes I meant using a formula. I'll try to explain the whole thihg again. Hope I make some sense. the layout is like this. CustomerId, Name, Address, Club.....Member, Section1, Section2...Section18. The...
  16. spiderusa

    Using Select expert with derived field

    I forgot to mention one more thing. All the data is present in the Group footer. There are 10 different sections (10 derived fields). So when I check for each customer I get several duplicate customerIds. So grouping was the best option. Using this 10 derived section fields I created another...
  17. 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