Search results for query: *

I Have a Crystal Report that provides a correct listing. I Created a second report displaying the same type of information, but from another Data Source. The only problem is that the Key field is sorting in order in one report, then in order within the second report, and the person who uses the...

thread766-1767434 Able to link to Synonyms, using SAP Business Objects Crystal Reports 2013 Support Pack 1 Version 14.1.1.1036. This is how: Open Crystal. Click on File: Click on Options: Click on Database tab: Only these three are checked: Tables, Views, Synonyms Click on OK: Click on File...

Hello, is there anyone out there who has experienced this problem or might have a solution? The report has 110 parameters. The set parameter order screen only displays 65 of the parameters. It is difficult to sort the bottom 30 because parameters the cursor selection can not be seen once it...

I want to be able to select database location on an existing report where the Synonym is replacing another data source. Or, just create a simple report using the Synonym. However, the DBO schema is not visible. Using Crystal Reports XI version 11.0.0.1282 on Windows 7 Professional, and sql...

Hi, I have spent way too much time searching dead end links and could really use some help. I am using a Microsoft report server and Asp code. The asp page is a second part in a third piece process. The first page is a parameter page, the second page uses the paramters, calls the crystal...

I am using Crystal reports XI, sql server 2005 db why won’t the selection criteria stay in the order that I place it? For example, when I save my report, exit and re-open, line 2 will be at the bottom. I change it back to what it is below, but it will not stay that way. Line 1...

Hi, I would like to use the decode statement instead of subqueries. The only difference between each subquery below is the value that is checked in fld3 and fld4. The query pulls the amount for that value for the keyfield in each query. The field names have been changed to submit this...

Hi, Here is an interesting problem. I'm working with a Crystal Report xi using Oracle. Before I changed the report, I had a working sql expression. The modification made to the report was to replace one table with another, I added the new table, changed the group from the old table to the new...

Hi, I have a simple report and want to add a column using an sql expression. Alone the report runs fine, and alone the sql expression works fine, when the sql expression is added to the report, the report runs and runs and runs and runs I finally have to end it abnormaly. I can use any...

Objective: Define excel columns while using an asp page to open a crystal report in an excel file neatly. The report is created in Crystal version 11. The report is formated for the purpose of exporting to excel. For example, in the File options, snap to grid is selected, free form is...

This command works in V10 and although I can use the sql expression field for other selects in V8, the command below works using V10 but not V8. The database is Oracle 8i. (select distinct pack_TAXnbr.func_GETTAXnbr(taxnbr, null, null) from table1 where field = "table2"."field2") Is there a...

Crystal Reports 8.0 Oracle 8I Data expected = social security number based on the customer number from tablename where customer number = 01. Function name: dbname.proc(pack_NBR.func_GETNUMBER) Delima = I have been using a ssn number from database 1 report 1 to link to a subreport. The...

Crystal reports 8 oracle database If I try the line of code below as part of the selection criteria, I recieve a message, "This function cannot be used because it must be evaluated later" {table.field} = maximum({table.field}) I know there is the option of grouping by the field name, however...

WHILEPRINTINGRECORDS; // // I am roughly following the example from // http://www.kenhamady.com/form08.html // and using multiple variable assignments in one formula. // // I believe the problem is in the the way // I have coded the very last line in the example // // // I recieve the...