Recent content by demosoc

Hello All, I'm new to Mysql and am having some trouble. I'm trying to insert into a junction table, "action_x_recipient", and I'm getting a 2013 error code. When I run the query w/o the insert, it runs fine. Basically we get a big data dump (over 8 million rows) which I need to move into...

Mike-you got me thinking more about the details and the suppression option and I came up with a solution after looking at the data- since the dynamic fields do not exceed 2 lines, and since each detail has a different size font, I added a details section (d and e) with suppression formulas for...

Thanks for trying!

Thank you for the suggestion Mike- it seems I'd forgotten to add the most important part- unfortunately, the lines (line 1, line 2, etc.) can grow. I actually have the label set up as you suggested, but can't seem to find a way to make the final detail line print at the bottom of the label due...

Greetings, Feeling a bit dim-witted here...I'm working on a label report in Crystal 9 which needs to print a barcode on the bottom of each label regardless of how long the name and accompanying info is (which needs to be positioned at the top of the label and grow downward). Like this...

That was it!!! There was one little query in the Access DB that was still calling the removed 'Bounced?' field. And when I deleted the field in the Access query, the reports stopped asking for it! That's so strange as the query was never a part of the report. Crazy. Thank you so much!

Unfortunately, that doesn't work. I tried making the 'Bounced?' field a text and even a date/time field and the report doesn't care or highlight the field. This is the case even on the ReportCopy. So I get the prompt regardless of field type, and I still am unable to locate where the field is...

Thanks to all for the efforts so far... Well, I've tried to export the report definition, but can't get it to work. It requires the disk (which took us awhile to find) and the one we found doesn't help even when I point it to the file it's looking for. So I'm currently unable to export the...

NiteClerk- thank you, but unfortunately, this didn't do the trick. Additionally when I look at the report explorer, the field does not appear. -------- lbass- I am prompted in the 'Enter Parameter Values' box, under 'Parameter Fields:' it appears as 'Contacts.[Bounced?]' -------- I created...

Yes, I verify the database, it recognizes that the table has changed, says it is up to date, and then I get the prompt for Contact.Bounced? as a Parameter Value when I try to run the report.

1. No- the only Selection Criteria is based on cst_add_date being >= a Parameter Date field 2. No- there are no subreports

I am running Crystal 9.2.0.448 against an 2003 Access DB and am pulling fields from two tables. The problem is that one of the fields (contacts.bounced?), which was removed from the report and also from the DB is now appearing as a parameter. When I open the Field Explorer to see if the field...

Hello, I have a multi-user Access 2003 database with front and back end security that has been working just fine for everyone. One power user was recently upgraded to Office 2007, and there have been issues ever since. I believe everyone else is still running 2003. This latest one happens...

Thanks so much dhookom!

Do you have them compact automatically, or do you do so manually? And how often?