Recent content by DanR

I was going to try that, but the report I'm trying to link the table into is already a subreport. Are there any other ways to force the link or modify an access table to allow the link to read properly?

I have a financial accounting database that uses dataflex files. I have created some auxiliary data files in MS Access to report on that as well. I have no problems linking Access and Dataflex files together when I am linking text fields, but every time I try to use a date field as a link...

Try tightening up the section that has the fields in it. Make the height of that section only as high as the tallest field in the section. I've seen this and otehr export issues that usually clear up when lining up fields properly and sizing sections to only fit the fields.

Sometimes, it just takes someone else to point out the obvious. It looks like moving the info to the page header may just work in this instance. Thanks for your help.

Try the following articles on Crystal's website. This is a known issue to them. I followed the instructions, and it works fine for me now. www.crystaldecisions.com article ID c2009572 or article ID C2010291

For dates, the formula will be ToText({table.date_field},"MM/dd/yyyy") Remember to use an uppercase M for month, as lowercase m refers to minutes. For additional conditions related to the ToText field, check out the help screen in Crystal. It has all the conditional fields listed as...

try the following: totext({Test_3.Category},0) + "-" + totext({Test_3.SubNumber},0)

I've built a report that has numerous sub-reports in it at various grouping levels. In an effort to keep these sub-reports and other grouping level data together, I have turned on the keep group together option. My report structure looks like the following. Group Header 1 is set to repeat on...

try this: IF {sp_Report.Required_Ship_Date} = Date (1940,01,01) THEN "Past Due" ELSE ToText({sp_Report.Required_Ship_Date}, "MMMM, d, yyyy") The "M's" must be capitalized, as a lowercase m is for minutes.

For any selection criteria you do want to appear, create a parameter for that selection criteria. For example, if you have a selection formula that says: {table.date}=Date(2002,04,18), you can create a parameter called {?Date} and change your selection criteria to say {table.date}= {?Date}...

when you pull up the compiled report in runtime (.exe file), there is a check box in the bottom left hand coner that says "Modify Selection Formula". Uncheck that box, and the selection formulas will not appear. If you have certain selection formulas that the user does need to...

I have had a similar issue in Crystal 8.5 under WinNT. If you can open the report in design mode, go to Database, Verify Database. It sounds like the database structure may have changed, and Crystal can't read the file.

I didn't put two and two together until I read your post, but yes. I started using CR8.5 on my development machine a week ago, and IE crashes when I run some reports.

I was searching old posts, and came aross this post that describes my issue exactly. Will Crystal handle sorting groups as described in the original post. Thanks for the help.

Having the same problem as KenD (no compression) Trying to follow dragonpath's advice I had a look for the "use admin's settings" but I can't find it in any applet. Any ideas?