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

  1. bobmorane

    Looking For the MAXIMUM Value of several Fields in a table.

    ...to display every days in 1 form but, if ever one hour in the month (!!) isn't in the database, i'll get a NULL result !!! note : this makes 31 * 24 = 744 formulas note 2 : the number of formulas displayed on the form, in only 1 page, is 31 days * 40 rows = 1240 formulas (font size = 6), plus...
  2. bobmorane

    Looking For the MAXIMUM Value of several Fields in a table.

    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+...
  3. bobmorane

    GeForce3 : broken component

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

    Parameters & Default Values

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

    how to copy a Dsr from VB6 project and make changes then save as new

    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 :-)...
  6. bobmorane

    Speed & Crystal Reports

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

    Speed & Crystal Reports

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

    Speed & Crystal Reports

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

    Speed & Crystal Reports

    "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...
  10. bobmorane

    Speed & Crystal Reports

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

    Speed & Crystal Reports

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

    Speed & Crystal Reports

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

    arrays as global variables

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

    arrays as global variables

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

    arrays as global variables

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

    monthly reports & hourly max by day

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

    formula problem concatenating 2 strings

    :)
  18. bobmorane

    sum & total

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

    formula problem concatenating 2 strings

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

    formula problem concatenating 2 strings

    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

Part and Inventory Search

Back
Top