Search results for query: *

Hi lbass, Thanks for every help. My report is now showing everything it has to show!! With your formula it did work. Thanks very much, FatEric

Hi lbass, Thanks for your reply. It did explain a lot. Too bad I can't use the running total in the header. So I will redesign my report a little and put it in the footer. I'm also sure that there are no NULL values in that field. Also "suppress if zero" is not ticked. "Show zero values...

Thanks lbass, The formula now works and I see the right number of frequency. Only when it is zero, it does not show anything (I want to see 0). It also only is possible in the footer of the group. But is there a way to put it in the header of the group. I have used summary's to show totals...

Hi everyone. I'm trying to make a running total formula work, but not getting there... In my report, I have detail lines containing a date and a number (0 or 1) if a person is sick or not on that date. The details are grouped by personal number. Now what I'm trying to do is to count the...

Hi lbass, I have managed to make the file. I have now joined the three tables (one main and two secondary tables) together. In my record selection I now have but the selection criteria. There was the problem. I forgot to but the ELSE TRUE criteria for the second secondary table. The sql now...

Hi lbass, I currently using CR9 (license from the company I work for). I'm not using any selection criteria's at the moment. I suppressed the detail lines I don't won't to see with a formula. Beneath you find the SQL: SELECT DISTINCT "TEMP"."TPGUDT", "TEMP"."TPPENR", "TEMP"."TPNAM1"...

Thanks Madawc, I thought of that one too, but didn't know how if it was possible. I have tried it and made the supress formula dependent. So that one worked. But then I also had to edit the running total fields (because they where still showing the total of all details. That has worked too...

Hi both, I indeed was doing some selections in the two other tables (not in the main table). And I have to do so. In the main table are only dates, name, number. In the other to are for each date a code. What I was trying to do was to display only some codes. So for example. Main table has...

Hi guys, I'm currently making a report that has three tables in the database design. The first table contains a date (for a whole year), a name, a number, ... The other two tables contain other values then name, number, ... In one of these tables you have all the dates from the beginning of...

Hi lbass, My again. Thank you very much. The summary fields show the right values in the header of my report. This is something i'm going to remember for certain. Again thank you very much. Star diserved! (if I could give you more than one star i would) Thanks, FatEric

Hi lbass, I'm at home right now, so I can't test it atm. But I will do so tomorrow. I let you know some more tomorrow. Cheers, FatEric

Hi lbass, When I place that field (@Z) in the detail, it show's me the right values. But when I place it in the group header, it only gives me 0 or 1... I now have an empty formula (@NULL), a formula (@Z): IF {F0005_6.DRDL01} = "Z" THEN {F0005_6.DRDL01} ELSE {@NULL} and a Running total field...

I'm summarizing on the field F0005_6.DRDL01 and it does a COUNT (so I does not have to be counted with the total, but it is a count -> I speak Dutch, so sometimes I can't explain things the exact way). I use the formula in the evaluate section (not the reset section). That's the only thing...

Also a little more info I have this: Factory has one or more Units Unit has one or more Lines Line has one or more Sublines subline has one or more Usernumber Each usernumber has a certain codes (one for each day). If such a code is a certain value, it has to be counted with the total, else...

Hi lbass, They are indeed running totals. But is there no way to transport them to the header or so. The order is a bit important to view. Thanks in advance. FatEric

Hi all, I'm working with CR9 and I have 5 groupings. Factory, Unit, Line, Subline, Usernumber. From those groups I have the sums (for each sum) in the group footer. Those who will have to work with the form have the abbility to select the detail of what they would like to see (Only factory sum...

Hi lbass, I now created a new report with just one odbc connection to the two library's, and you're were right, this is working much faster !! When I had the two odbc connections, the reports ran for 17 minutes (yes that's right). No it runs in no more then 1 minute. So thank you very much for...

Thanks lbass for your answer. Indeed I was linking trought 2 odbc connections. I found a manner to get the library's into CR9 trough just one odbc connection. I'm going to rebuild my report with those links and see it this is working much faster. I will let you know something when I have...

Hi lbass, I'm referring to one database (on an AS400 system), but I'm connecting trough 2 ODBC connections (because I'm using to library's on the AS400). Maybe that's why Crystal Reports things it are two different databases... When I look at the query trough Database -> show SQL query, I...

Hi all, I am writing a small report in CR9. I have two tables linked to each other with a left join. The first table has some user info in it, with some codes. Those codes you can find in the second table, with also i translated code. In my report I want those translated codes to show up...