Search results for query: *

Hello ALL, If anyone ever has troubles with the color highlight system in Crystal reports XI charts in an external CR viewer (not Crystal reports designer) then you must be sure to set the text to UPPERCASE and limit your description to <= 3 characters. Set your text to uppercase and left(,3)...

Hello, The Crystal Reports 8.5 Viewer is not displaying Memo RTF fields (Oracle 9.2 LONG Field type) when being viewed via remote desktop on a terminal server. The report runs but the text fields are simply blank. If we login as Administrator then the memo fields are visible. We have copied...

Hello I have a very complex problem I need help with. I need to sort the order of transactions in my database but many transactions have the exact same transaction date. There is also a unique timestamp field but I can not use this alone as a user can specifiy the transaction date manually and...

Hello all, CR XI DB: Ora 9, MS 2005 Is there a method to automatically export a report into multiple PDf files. I have a huge reminder list and want to export the report into multiple files (one for each supplier). Thanks again. APB

Hello, mssql 2005 Oracle 9 CR XI I have a performance issue..To array or subreport. I am not familiar with arrays so all the help would be appreciated. In the main report I have basic data based on a unique ID table (ID, description, type etc). Depending on the ID_Type there can be many...

Hello, CR XI MSSQL and ORACLE Is it possible to "tell" crystal reports which sub report should be displayed first depending on the data being produced. Current my sub reports are in similar group headers: group header 2a, 2b, 2c etc. I want to re-order (sort) them based on a formula?? Meaning...

Hello, It looks as though Crystal reports XI running on an mssql 2005 db is automatically trimming my TEXT field (memo). It is only showing the first 600 words or so. Any ideas? What is the largest text size you can display in CR XI. I know there are some limits of adding these fields in...

Hello, Usually people complain about duplicate records but I am requesting the opposite. I have many PO Items connected to my purchase order. Each PO Item has a "received qty". I want to duplicate the PO Item by the received qty: So if PO Item "1" has 20 received qty it should appear 20 times...

Hello, I have a timesheet table I want to report on. Each record has a start date-time and end date-time and activity. I am trying to create a timesheet setup and dynamically display a colored box for every half hour during the period worked (onle line per 24 hour day). So for monday and...

Hello, MSSQL CR XI r1 I have a question regarding radar charts and grouping in general. I want to create a group in CR that shows all items then 2 additional groups for Item A and Item B. When I create a formula for this it seems to display all items in ALL group and does not include the...

Hello, I want to create a chart in CR XI. database is MSSQL 2000. I have some manual/hard coded figures I need to display and also some database summaries I need to display. The reason for this is we do not have data before 2007. so I want a line chart which groups per year: Except the years...

Hello, CR 8.5 DB: Oracle 9.2 I have a charting problem that hopefully someone has come across. I want to create a bar chart with several "independent" groups. When I add several groups in the "on change of" section CR links these groups together. I want each bar in my chart to based on an...

Hello, I am just wondering if it is possible to set a field/text in CR XI to be considered as a form field for data entry when I export to pdf?? You know how Adobe acrobat highlights form fields as light blue in a pdf document. I want to create a PO Inquiry report and automatically export to...

RE: Oracle LONG Field types not supported - CR XI Hello, I am having many problems with my LONG fields in CR XI with oracle 9 and 10. When I updated them to Clob crystal reports worked fine. But I want to try and avoid doing this if possible. When using LONG various problems occur, random...

Hi, MSSQL 2000 Crystal Reports XI Possibility to create views I need to design a report which displays missing Ids from one table. The Id is made of two components: the year (2 digit) and a four digit running number. Example: 06-0001 > 06-9999 This field is not a primary key so in some cases...

Just curious about one thing. Oracle 9.2/cr xi If I set up the following in my record then it does not show NULL records: ({ORDER.STOCK} = 0 or isnull({ORDER.STOCK})) But if I change the order then it does: (isnull({ORDER.STOCK}) or {ORDER.STOCK} = 0) Why is this??? Any help would be...

Hello, version Oracle 9.2 Crystal reports XI I am having a small oracle issue. I want to use the standard "Oracle server" driver but it does not allow me to create an sql expression IFNULL: {fn IFNULL("Table"."field", 0)} Does anyone have ideas. I then place this sql expression into my...

Hello, CR XI Pro Oracle 9.2 Windows XP SP2 I have problems using the Text interpretation (RTF) when using datasource: ORAOLEDB.ORACLE If I switch to MSDAORA it works but then the reports run much slower in my application. So I am stuck between a rock and a hard place. For two of my tables I...

Hello, CR XI MSSQL2000 & ORA 9.2 Windows XP SP2 I want to remove all rtf tags from a memo field. I want to standardise the font in my report. The final result will be a string formula with only the text - no rtf code. I have tried the following formula - but it probably doesn't cover...

Hello, I am using a hyperlink in my report to open an object in my database: "http://localhost:6000/" + totext({OBJECTS.Object_Id},0,"") When I click this record it opens my object but it leaves the browser (IE or Firefox) open. Is there a way to close the browser window with some additional...