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

  • Users: sbelt
  • Order by date
  1. sbelt

    Help on generate automatic groups!!

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

    Help on generate automatic groups!!

    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)...
  3. sbelt

    Help on generate automatic groups!!

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

    Average summary

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

    Problem with count of weekdays in CR7

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

    Problem with count of weekdays in CR7

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

    Help on: Error:599 Cannot open SQL server

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

    Surpress duplicates

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

    Range problem

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

    Range problem

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

    Range problem

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

    Range 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...
  13. sbelt

    Summary 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
  14. sbelt

    Summary problem

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

    Summary problem

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

    Summary 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...
  17. sbelt

    Surpress duplicate data for export

    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)
  18. sbelt

    Surpress duplicate data for export

    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.

Part and Inventory Search

Back
Top