Search results for query: *

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.

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

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

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

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

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

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.

Thanks guys. The null values were the problem. I used the same concat formula for the sections and it worked.

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

Thats not good at all. There are so many to do. Thanks anyway.

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.

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

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

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

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

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

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