Search results for query: *

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

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

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

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.

Hi, I have 2 fields that can both Grow, Printed under each other. The problem is when the 1st field is to big, it overlaps the second one. The purpose is that there are printed one after another without any extra space in between. I use C.R. 8.0.1.0 Thanks for helping me!!

Hi, I've a Description line in the section 'Details' with format 'Can grow'. The thing is that sometimes C.R. does it OK and makes an extra line, but not always!!? e.g.1.Correct "Kinderhelm rocket power jongens blauw 50 - 56 cm" correct result is: "Kinderhelm rocket power jongens blauw 50 -...

Hi, How do I have to make a list of clients including sum/month/client? Example : Client A : Client B : Client C : 01/04 = 340.50 € 01/04 = 1,520.36 € ... 02/04 = 352.68 € 02/04 = 250.36 € ... 03/04 = 25.59 € 03/04 = 1,985.32 € ... ...

Hi, I've had the next error : "The conversion of the nvarchar value '200408160214 ' overflowed an int column. Maximum integer value exceeded." I trye to search this value in the Select, but cann't find it!! Is there something extra in the Analyzer to search a specific value into a complete...

Hi, I've made a Crystal with 2 Details (a & b) - 1 of this is always surpressed. The problem is that Crystal put the Report Footer directly after the last Detail line instead at the end of my page. How can I solve this problem? Thx Jorg

Hi, I've made a list where every Detail line got a number (Record Number). How can I stop this count and start again from '1' when I use a new page and/or when it starts with a new client,....? Thanks for helping me. Jorg

Hello, Can somebody tell me how to surpress the following : E.G. = 150.00 euro has to be 150 150.75 euro has to stay 150.75 So every time I have a double zero behind the comma, I have to surpress them (double zero's only!!) Thanks for helping me!!

Hi, Can somebody tell me how I can find 1 specific field in several tables in a SQL-Database? Thank you for helping me. Jorg

Hi, Can somebody tell me how I convert : 04/26/2004 (=nvarchar(50)) to 20040426 (char) Thanks for helping me! Jorg