Recent content by jdwalton

Apparently, I missed something the first time, I couldn't find my discrepency, but I started over and redid everything it now works exactly as I need it to. Thank you very much for your patience with me, this is a huge hurdle for me that you have helped me overcome. thanks again. Jim

That's excellent! Thank you. That part works like I need it to. Once this is finished, I need to absorb everything you have taught me so I fully understand it. Now as a result of these changes, the drilldown from GF2 is not showing the raw detail. I hope what I'm going to ask makes sense...

Thanks for both responses! FVTrainer, I like where you are going with this, it looks like what I have in mind. When clicking GH1, I want to view the detail that is suppressed. Currently, the drilldown on GH1 shows GH2 and GF2. Can you give me more detail on drilling down from GH1 so that it...

I am relatively new to Crystal reports and I am finding that the drill down is not giving me the results I expect. I can attach the file if necessary but I will try to clarify what I am doing first. I have 2 groups, group 1 is carrier code and group 2 is Lane. The page header shows the title...

I just wanted to followup on this post. I finally got my problem solved. The oracle date field is, in fact, a date-time field and in oracle, to return the date and time or the time only, you must define how you want it formatted, otherwise it only pulls back the date. That has nothing to do...

Right before the word 'Time'

Thanks midearth for the info. I have tried what you suggested and I get an error saying 'A date time is required here'. That's my frustration is that the obvious solutions are not working. Any other ideas? Thanks again for your help, I do appreciate it. Jim

I am developing a report that displays the number of records that met the noon cutoff and that did not meet the noon cutoff. I have started with a formula like this: 'if ({table.datefield} > '???'.....' Everything I have tried where the '???' is does not work. I am hitting oracle 9.2 and the...

Yes I have, but the problem is that the parameters are a requirement. I need to be able to specify the date range for the data in the report. Thanks for the suggestion. I guess what I really need is to know how to convert the date to a string within crystal. Jim

I have a report that pulls data from oracle tables. I have 2 parameters set up to provide a date range to display on the report. These work fine within Crystal. My problem is when I open the report from within our application, the parameters are not showing and I believe it has to do with the...