Search results for query: *

little explanation : i have 24 hourly averages for a day (24 running totals) i add them in an array, then take the maximum of this array ; i repeat this for the 31 days of a month (31 formulas) and, at the end of the month, i add the 31 maximums in an array, and take the maximum... Of course i...

last message : september 2000... :-) i already use this method to obtain the maximum of several fields, but if ever one field is null, the maximum of the array returns NULL, and the maximum of the array, in which i use this NULL maximum returns NULL too (yes ken it's about my 2400+...

Hello ! I saw last night that i have a broken component on my geforce3 !!! it's the red-circled one >>> http://www.ifrance.com/yyyyyeeeeeaaaaahhhhh/leadtek-gf3-front.jpg it's not my card, but exactly the same model i was experiencing a big performance decrease for a few weeks, and at last...

Hello ! This time this is a very small report (4 formulas, 2 parameters and 7 running totals ! amazing ! ;-) ) i'd like to know, if possible, how to dynamically change the default values in a parameter : in the db i have a DateTime field (called timestamp), and when i create a parameter, with a...

in the RDC 8.5 integrated to VB6, you have an icon that allows you to save as a CR file (shape of a floppy-disk, near the zoom control) Then you just have to act as if you wanted to add a new crystalreports 8.5 file to your projetct, which will create a new .dsr, the one that you want :-)...

hum... cannot upload the .rpt... seems that the file is too big if anyone interested let me know and please could you tell me a "good" web space provider (free of course :-) ) Later, Bob

fareopagita you posted while I was writing :-) If anyone could give me a french translation for "stored procedure", or could tell me how to create one, that would be useful thanks ---no report uploaded yet, i'm modifying some £µ^£@## bug CR did yesterday, i'll certainly ask how to...

Hello ! I see that my 2000+ formulas/running totals were source of amazement :-) If you guys want to see it, i can upload my report (3,2 Mo lol) so as you can see it by yourselves... However, i'm french, so maybe you will not understand the names/labels, furthermore you will not have the...

"stored procedure" : does it mean that when i create a report, i have to select a .dsn file as database ? the problem (i think) is that, once i have achieved the report, i will integrate it into a VB application, then send it to a plant. And there is no database manager there, so i...

if possible i would have used cross tabs with days as columns, but when i tried i wasn't able to obtain a valid result

lol yes at least 2000 formulas/running totals when i create or delete one, sometimes i have to wait for 1 or 2 minutes (3'45 maximum, i calculated yesterday :-) ) before i can do anything else (indeed it depends on the processor, this one is a P-III 733) the .rpt file is about 3Mo :-) I don't...

Hello I have reports integrated in VB6, with over 2000 formulas/running totals, and refreshing, takes a long, long, long time ! is there a way to speed up all that ??? I read the faqs, and found that i had to leave the "use indexes or server for speed" option checked... but i have the...

-Update- naith, it works with the use of 2 local arrays, containing exactly the same values... but i cannot wait for a long time, so i'll take note of your solutions to use them if ever i have to "improve" (weak word :-) ) my reports Bye bob

hi naith, the idea was good, I didn't even thought about it, but unfortunately it doesn't work, i get the same error message. in the meantime i changed global to shared, may it change results ? That's so bad i have not much time left to finish my project, so i think i'll decalre all arrays as...

Hello ! I have a big problem using arrays as global variables. Here it goes : Formula 1 : global numbervar array m1 := makearray({#MOYH CO 1 0},{#MOYH CO 1 1},{#MOYH CO 1 10},{#MOYH CO 1 11},{#MOYH CO 1 12},{#MOYH CO 1 13},{#MOYH CO 1 15},{#MOYH CO 1 16},{#MOYH CO 1 17},{#MOYH CO 1 18},{#MOYH...

Hello ! I have to deal with a monthly report displaying all 31 days in a tab shape My problem is, that a specific field needs to be an hourly maximum of a day, for all days. At first i thought about making one tab for one day, with 24 cells (one by hour), then taking the 31 max of the 31 tabs to...

:)

hum hum correction again... this doesn't work... a new hour has started ans the formula simply takes into account the current hour, the maxhours formula is always overwrited I'm going to try with arrays, and if possible i'll take the maximum of the array or something like that :) later bob

you can't group on 2 fields at the same time but you can make several groups with a certain hierarchy : group 1 : year group 2 : month ---details--- group 2 end group 1 end then you can place {TABLE.YEAR} and {TABLE.MONTH} in each dedicated group, with the number format. But this will...

so put your 2 fields on the report (put the "delete" option checked) and change the number properties for both fields, then they should be handled correctly in the formula