Search results for query: *

Hi everyone, We have numerous CR reports that mingle a combination of Access and Oracle data (sometimes just Access data) that have worked fine with the Access MDB format for years. Now we're moving to the ACCDB format and the reports work fine in the Crystal Reports developer tool using OLE...

Hi Guys, Sorry if this is old news, but I'm stuck! I've been given this Word document in DOCM format (XML with macros enabled). They have numerous Combo Box content controls inserted all over in tables. What they want is that if someone picks "Yes" or "No" from the list, that it automatically...

Hi Guys, As most of you have seen, Access 2007 is quite different in regards to the searching and filtering capabilities. Searching is very fast now, but it only finds the fist instance of a string within the master records, starting at the beginning of the recordset. There is no "find next"...

In Access 2007, I can't find a way to open several forms at startup (creating tabs for each for in a certain order) then passing the focus to the first form (the tab furthest to the left). I can open all the forms and get them in the order I need, but changing focus to the 1st form seems impossible.

Hi Guys! The issue is simple... on a form, the user right clicks and chooses Text Filters, then Equals, then types in a value. If no data comes back, the form blanks completely (all fields and lables are gone) and it locks up. Even the Filter toggle button at the bottom of the form is locked...

Hi Guys, I'm a n00b to VBA and Tek-Tips. Gotta say up front, this place is great. I find all sorts of useful info here, so thanks. Also, I apologize up front because I'm sure this topic has been covered but I can't find it. I'm probably not searching for the right words. What I really need to...

Hi! I've been doing Crystal for quite some time, and I'm currently using CR XI R2 Sp2 with the Business Object Enterprise. The problem I'm having is that if I export my report in RTF, everything looks perfect with the correct page breaks and formatting. However, if I export to a "editable...

I've got a report that's centered around line items. They want it grouped by each category of line items, but the categories are in the same table as the details. There is a field called "PARENT_YN" to differentiate the detail lines and the category lines... so if "PARENT_YN" = "Y" then that's...

Good day! Thanks to you all for making this such a great forum! My problem is fairly simple; I have a VB6 app that we've deployed on Server 2000, Windows 2000 and Windows XP via a .msi file created in Visual Studio Installer v 1.1. Now all the sudden on Server 2003 it only installs "for the...

Good day, I'm going nuts over here with this issue. I'm using CR XI R2 SP1 with all the latest hot fixes (version 11.5.7.620 to be exact) and I'm still having problems, albeit much fewer than with XI R1. Today what I noticed was that commenting out lines in my formula was synonymous with...

Hi! I'm using Oracle 9i and Crystal Reports XI R2 Sp1. Here's my dilema; I put in a Selection Criteria like this {Documents.Document_Date} in DateTime({?beginDate}) to DateTime({?endDate}) and ({Documents.Author} <> "Jane" and {Documents.Document_Type} <> "PDF") Which should mean that any...

Good day! I have a very unusual request... but first let me say that I'm using BOEXI and CR XI-R2 with an Oracle 9i db. Here's the problem; I have counties stored as their county codes and county names. In the multi-param I pass the codes, which works great. Now, at the top of the report...

I have a situation where I need to use a multi-select parameter with the IN and LIKE operators together, something like this; {TABLE.FIELD} in (like ("*" + {?ARRAY_PARAMETER} + "*")) I know I can do this {TABLE.FIELD} like ("*" + {?SINGLE_VALUE_PARAMETER} + "*") or this {TABLE.FIELD} in...

I've been trying to get conditonal group footer suppression based on number of detail records. Here's what the problem is; I have invoices in the detail section and they are grouped for each month with a summary for each month in the group footer. For most months there is only one invoice, so...

I'm using CR XIR2 and an Oracle DB with native connection. I have a report that I created which is basically a manual crosstab. The report structure is very simple; there's just one group and one detail line. I have it grouped by Project Type. On the top I have manually broken it into twelve...

Hi everyone, Let me first say thanks to all of you for your informative help! I'm a resident lurker and I find Tek-Tips to be a great resource. Here's my question; I have a parameter that can take in multiple values, and I want to display those values on the report... so I wrote the following...