Recent content by jorg32

Hi, I have a client who's SQL Server goes every afternoon very, very (!) slow. He has 2 GB RAM to work with. Everytime I reset IIS + Reboot the MSSQLSERVER everything works fine, untill the next day...... When I take a look in the Task Manager the sqlservr.exe gives for the MEM USAGE ...

Hi, Is it possible to suppress a field when it find just a part of a word or phrase? eg : article = '123456_OMS' --> suppress when article ended with '_OMS' or suppress when '456' thanks for helping me. JM

Hi, Is it possible to let Crystel do showing on each page a maximum of eg. 25 records in the details? So yes, how to do this. thanks for helping me. J

I have 1 group header and when this group changed, CR has to count his rows again to make sure that it use a minimum of the page size. I have tried the thing that Naith gave me - this was a good thing (print-out), but the result wasn't good. eg: The group is called "Fish-Food" and it has 7...

Hello, I'm working with C.R. 8.0.1.0. When I use Multiple Columns The report shows me always a different number of rows in the detail section. eg : when I have 15 rows, CR gives me on the left side 10 rows and on the right side 5!? The result = that I have a lot more pages then I want to...

How stupid of me !!! Thanks for helping me 'lupins46' - I think that I need some holiday ;-) J

Hello, How can I let the Page Header appear only on the 1st page and not on the following pages? thanks for helping me. J

I have to make a list that includes all the article a client has ever order in the company and this grouped by different groups. Because every list is very large I want to make this on each page in 2 columns so I can use less paper. J.

Hello, How do I create the following in Format Section "Detail": e.g.: Article 1 - 20 pieces |Article 4 - 4 pieces Article 2 - 10 pieces |Article 5 - 10 pieces Article 3 - 5 pieces |Article 6 - 15 pieces etc... thanks for helping me J.

Hi, I've made an extra field in a SQL table where I can put a number of Prints for my report. How can I use this field to print exact the amount of printouts in my Crystal report? e.g.: Field = 5 --> so when I print the report,it has to print this report 5 times. Thanks for helping me J.

Hi, I want to check in a SQL when a client hasn't payed his bills after more then 30 day's. e.g. He has to pay on 2005/02/25 and if he hasn't payed after 30 day's (2005/03/27), he has to pay something extra. What do I have to do so SQL count on this date every time 30 day's? Thanks for...

Hi, We have written a programme in SQL. Now we notice that this works at the customers enormously slowly!? Our first thought goes to the indexes of the tables which are perhaps not well. The Second thought is that the "select" with bad indexing carries their work slowly out. Is there a...

Hi, I will start with the example because it is hard to explaine : Report Header: value of field = 100 In Detail lines I have several lines = 10 + 5 + 10 Total of this Group = 25 Total = 100 + 25 = 125 Next group has also several detail lines = 10+20+10 Total of this group = 40 Total =...

Hi, I've to make an auto-page-count in a C.R. and the count has to start back at 1 when the group is changing. Counting the pages isn't that difficult, but I want to set it this way : e.g. "1 of 3" - "2 of 3" - "3 of 3" and then back to "1 of 5" - "2 of 5" "......." Thanks for helping me J.

I did that before --> using Details 'a' and Details 'b', but then the second field (Details 'b') overlaps the first field (Detail 'a')??