Search results for query: *

Hi, We currently use CR XI and set the reports through a third-party front end product, which negates the use of Dynamic parameters This is about to be changed (the third party product will be fixed to allow to read the reports through there to BOE (which we are buying) and all functionality...

Hi, My problem is with trying to select data based on the right(X) characters of a Static parameter, where the "X" is not a definitive number. I want the list of parameter options in the drop-down list to be a concatenation of the description and code fields, but only use the CODE part of the...

Hi, Using BOTH crystal V10, and crystal 2008 - the same problem occurs. Crystal Oracle ODBC Data connection for an Oracle database. I have a table with a CLOB field type, that is displaying in crystal as a bunch of squares. I have tried running a report against the same table on another...

Hi, I am trying to create a SQL Query within a crystal report, using Oracle Sql, and am having trouble with it. The query is to give me a summary table of data (one column in the output), to link into the CWRCASE Table in the Crystal Report, with one line per CASE_ID, showing the LATEST...

Hi, I'm using Crystal V10 on Oracle DB I have added a Select Case statement to the record selection, but its now taking a LOT longer to run. I had to do a nested Select Case, and I think I've done it wrong. Can someone have a look at this and tell me how I can fix it? (SELECT...

Hi, I'm using Crystal V10, and have a report that I want to add a monthly grouping level to. All the data comes from 3 separate sub reports, and is just all passed through to the main page to display and calculate summaries between the sub-reports. The main page has a group by location, and...

Hi, Using Crystal v10 and Crystal Enterprise v10. I have created a basic data report that I run through Eportfolio, and automatically email out on completion. The only problem is, if I set the report FORMAT to be "Tab Separated Values", instead of the report coming out as 4 columns of data...

Hi, Using CR V10 still... I know that fields are case sensitive unless you specify 'lowercase' or 'uppercase' on the field name, but how do I make it so that regardless of how the user enters the parameter text, it will still match up to the data in the field? So I need the Parameter field to...

Hi, V10 Crystal reports On my cross tab report, the gap around the data fields in the cross tab columns is quite large. As a result, I am having trouble getting the report to fit on one page without having to shrink the font right down, when really if I got rid of the white-space areas...

Hi, Ok, the only way I can get my summary data on the first page of my report to fit on one page is to have the first page as PORTRAIT Orientation. Otherwise I end up with 3 lines of data on the next page. But the rest of the report needs to be LANDSCAPE. Don't suppose there's any way this...

Hi, Using Crystal V10. I have a page header that I want to display on all pages except the first one. However, when I do a conditional suppression in the select expert of the report, the page header suppresses, but there is a blank space still allowed at the bottom of the page, where the page...

Hi, Using Crystal V10 I have a cross tab of data thats grouped along the top by date (by week). The problem is, the week goes from Sunday to Saturday rather than Monday to Sunday. I am using the date field as the column header, with the grouping level set to group "for each week" and...

Hi There, Ok, can someone please tell me if they have ever come accross this problem, or can give me any hints on fixing it..... Here is some background of the report first. I have a basic Crystal report, that is run daily. It has a date parameter (defaults to 01/01/00), and in the...

Good morning, I have been asked to urgently find out whether the following 2 are compatible: 1. Crystal Reports Developer Version 11.5 with 2. ACTIVEX Control Version 11.0 Can someone please help?? Let me know if you need further info - I'll check back often. Thanks regards BB *** Count...

Hi, Can someone please give me a quick yes/no answer to this. Can I write a report in Crystal Reports XI, and publish it to Eportfolio (Crystal Enterprise V10) or will there be issues?? I need to know this to advise whether another dept should buy Crystal Reports XI or V10, as they will be...

Hi, One of my work areas is using Crystal Ver 7 (yes, you heard right - version 7!). So can you please tell me if Crystal reports written in Version 7, can be published onto Eportfolio Ver 10 (Crystal Enterprise 10), to run? Also - does Crystal 7 have parameters?? I can't recall its been...

Hi There, I use Crystal Reports 10, and Eportfolio 10 (Crystal Enterprise 10) to publish the reports. I have a report that is run in Eportfolio as a PDF file (Adobe), but when the report runs, one of the fields changes format on me. This only happens if you run it in Eportfolio - if its run in...

Hi There, Using CR V10. This report contains 2 group levels, Grp 1 and Grp 2 (the inner group). The data displayed when the user opens the report is in Grp 1 footer, as summary totals etc. I have suppressed Grp 2, and I want the user to be able to drill-down directly into the Detail...

Hi There, I use CR V10, and I have a problem with Groups showing in the Group tree, that don't show in the report. I have my data grouped by LOCATION, but in some instances none of the data within a location group is VALID to display in the particular report, so the group is suppressed. But...

Hi, If there is an answer to this already somewhere, please point me to it (I couldnt find it). Anyway, I'm on CR 10, and have a relatively basic summary report, that just displays the total cases per location, and shows what percentage that location has in relation to the report grand total...