Search results for query: *

Yes, this was it. It works fine. Thanks for the help.

Hi, I think I was not clear enough by using the word group. I don't want to make a group. What I want is to add a number to a field in the record. If the record is in 1-1000, I want to add a 1, if a record is in 1001-2000 I want to add a 2, etc. Like this: (record1) name email 1 (record2)...

Hi, I'm making a report in CR7. I have a list of names, emailadress etc which holds over 10.000 records. Now I want to make different groups for each 1.000 records. For example: Record 1-1000: group 1 Record 1001-2000: group 2 Record 2001-3000: group 3 Is it possible to automaticly generate...

Hi there, I'm trying to do an average summary on a formula field. This formula field is like this: if {table.date} >= Date (2004,01,01) and {table.date} < Date (2004,02,01 ) then {@workdays} else 0 The field {@workdays} shows a number of workdays. So when I preview the report I get a list...

I'm sorry for not being clear. I'll give an example of the situation. I hope this can help you: There are a couple of users who have to make an assignment. In table 1 the startdates are registered. In table 2 the enddates are registerd (the date on which the assignment is being uploaded). I...

Hello, I've been looking in the forum for some helpfull posts, but I haven't been able to find any, so that's why I post a new one. I want to count the number of weekdays in a period (between {Date1} and {Date2}), so I can see how long it takes a user to make an assignment. Therefore I've made...

Hello, I've created a report which consists of a couple of subreports. When I want to open this report in K5 Modular (a dutch CRM program compatible with CR 7) I get the error 599 Cannot open SQL server. Sometimes it works fine, but most of the time the error occures. I can't find the cause of...

Hi, I've a report which I want to export to a CSV-file. In this report are duplicates, which are surpressed in the report. When I export the data, the duplicates are back. Is it possible to surpress them when I export the data?? Thanks in advance Sander

Thanks for the help!! I've got it working now with the advice of lbass.

Hello I've got this working now, but now I want the subscribedate to be in 2 ranges. Like this: if {subscribe date } in Date(2002,01,01) to Date(2002,12,31) and {subscribe date } in Date(2003,01,01) to Date(2003,12,31) then {Table.Person_id} This doesn't work yet. The subscribedate has to be...

I actually want to find out the number of persons who subscribed to a course in 2002 and in 2003. So the person must be in the range of 2002 and in 2003. There is a subscribe date which i can use, but how do I find out if the person subscibed in 2002 and 2003? I hope I explained my problem...

Hello I've got the following problem: I want to find out if a person is in a daterange. I've got the following formula: if {Table.Person_id} in Date(2002,01,01) to Date(2002,12,31) then 1 else 0 This is not possible, because the person_id is not a date. Is there a way to solve this problem...

Thanks dgillz and Reebo for the help. I've made the selection on {table.code} in the select expert and placed the {table2.memberid} in the report and it seems working fine now. Thanks

Yes, the report is grouped on a class_id. I just click 'insert summary' when I right-click my formulafield in the detail section.

When the member doesn't have the code &quot;X&quot; it becomes zero. When I do a distinct count it counts the zero as well, so when I have 30 members it counts 31. I hope you can understand my problem...

I've the following problem: In the details section I have a field (@members) which looks like this if {table.code} = &quot;X&quot; then {table2.memberid} I want to do a distinct count on (@members), because a member appears more then once, but it counts a &quot;0&quot; as well, which I don't...

I'm using Crystal Reports 7. How can I check if I have the most recent patches and dlls for export? (I'm not having full access to my cpu)

Hello I want to surpress duplicates which is working fine, but when I export the data to a CSV-file the duplicates return. Is it possible to solve this problem?? I surpress the data by clicking 'Surpress if duplicated' option in the format field menu.