Search results for query: *

I want to present the user with a list of fields from which they can choose the field to group on for a report. I get 'Invalid Argument', or a message about trying to group on a non-recurring field. Using CR XI

Crystal Reports XI I am creating statements for lastfullmonth (CR function). I only want to print them for accounts that meet both of two criteria- 1. zero balance forward. 2. No activity during lastfullmonth. I am getting the balance forward info via a view in a group just below the...

Using crystal XI Dealing with selection criteria I have 2 identically structured tables. I want to select the record if the value in table2.field1 does not exist in table1.field1 I've tried being creative with 'instr' and in [array], in both selection criteria and section expert, but either...

In CR XI have a report that gets data via 2 commands. It also uses a cascading parameter. All were done in XI. I was able to add the commands to the repository. Then I attempted to add the parameters to the repository and wasn't able to determine how to do it. But now I can't edit either of...

CR XI I'm getting the balance from 3 subreports (invoice, payments, DrCrMemos) passing those values back to main, and doing the final calculation of the balance due in the main report. I want to group on the result of the balance due calculation. Is there any way?

Using CR9. I have a main report and 4 subreports. The ones pertinent to my question are: Invoice, context, person. They link this way: Invoice.Main_Context inner join to Context.Context_id. Context.Person inner join to Person.Person_id I have an invoice subreport. The invoice # is passed...

I want my data to look like this: Group A 1 4 7 10 2 5 8 11 3 6 9 12 Group B 1 4 7 10 2 5 8 11 3 6 9 12 I...

I have a report that is a receipt for classes that will run overnight. For each class, after the receipt it should print a requirements page. So the output should be something like: receipt 1, req 1, req 2, req 3 receipt 2, req 1 receipt 3, req 1, re1 2 etc, with req 1... being any of 50...

Using CE9 Prof. & CR9 Dev. I have a receipt running overnight. We want to have information reports print collated with the receipt, based on the items purchased. These information reports are separate CR reports. I've never tried this type of thing before. Is it easy/hard, possible/impossible??

I would like to install CE10 Professional on the Crystal server so I can take advantage of Business Views. I use CR9 Developer on another machine, and upload all reports to the web via the CMC. Will this work? Any compatibility issues? Couldn't find anything on the BO website. Couldn't even...

The repository database is on the Crystal Enterprise 9 Server. I also used that machine as my workstation in the past, but want more freedom to install programs, so I moved to a different machine for a workstation. I am trying to connect to the repository on the CE server for editing my CR9...

I searched the archives but evidently used the wrong criteria. I'm trying to make the group tree more useful. The group name is numeric {cngroup} and right now all the user sees is 1 2 3 4 etc. but there are responsible individuals assigned to each group and I would like the tree to show 1...

Has anyone come up with a way to do this, or a work-around? I'm rather desperate. I never dreamed there would be a problem, so I created a very detailed report that is fairly heavily formatted. It must be run for a project, exported, page breaks adjusted and sent to the printing company...

I've seen several other posts here, but none seem to give the exact set of problems I get. Using CR9 and Excel 2002. In Excel I have done the highlight and insert/name/define to give the worksheet area a name. I have also named each field. Then I set up an ODBC file dsn for Microsoft Excel...

I have a field that may have from 0 to 12 comma separated values. I need to display each value on a separate detail row. Using CR9. I tried creating a view, but failed terribly. This is against a SQL Server database which I have never used before. I'm used to Oracle.

Using CR9 and Enterprise 9 against Oracle 10 I have a product table and an option table. For each product there may be many options, 2 of which are gender options. I need 1 line per product and need to find the male option and display the maximum enrollment field from that option record...

We are using CE9 with CR9. At 2:00 AM CE runs receipts for all transactions that occurred currentdate-1 and where customers have email addresses on file. We want to automatically email each receipt to the customer it belongs to. Is that doable? If not, has someone found another solution that...

I think this is one of those deceptively simple problems. The desired end result is 1 page of 5 columns of consecutive numbers, beginning with a number obtained via a parameter. I've been sick, so maybe my brain is still in bed, but I haven't been able to get this done.

I am using CR9 Developer with two Access 2000 tables in one database. I have a 'current' table and a 'history' table that each have a field named 'status' and a field named 'status_date'. On my report I need to work with these as though these fields were in one table. My group#1 is SS#...

I have a subreport named 'Accomodation' that is placed in a group header. It has a shared variable that passes back either "None" or "OK" to the main report. The main report either displays the fields from the subreport (if the shared variable value was "OK") or...