Search results for query: *

Thanks Brian, I'll have a go at this once we get our BOE product in a month or two, and see how we go. Lets hope we have the full functionality to pass through and use the LOV's in the front end product as promised :-) regards BB *** Count your blessings not your problems****** :-)

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, Thanks for your responses. Great help. In this instance the Mid({?LOCATION},Instr({?LOCATION," ") +1) works better than the TRIM(RIGHT), because of the variable length of code can be between about 2 and 9 characters, so rather than put lots more spaces and then trim, its easier this...

Is is possible to just exclude the days in the selection criteria of the report? EG and Not({DVDN.row_date}) in [Date(2011,01,01),Date(2011,01,04)]) regards BB *** Count your blessings not your problems****** :-)

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, Does your field {MSC_TBL.MSC_DUE_DATE} contain a list of dates, with one line per forecast? If so, then your formula above will only look at the data on each line, and won't know whether there is a 2010 date aswell as a 2011 date. How about splitting your formula into 2 formulas...

Hi, Thanks for your help Ian. Unfortunately the one above wouldnt work for me, but after a LOT of trial and error, I ended up using this formula: (Select CDRDOCT_DTYP_CODE From CDRDOCT where CDRDOCT_SEQ_NO = (Select max(CDRDOCT_SEQ_NO) MAX_SEQ From CDRDOCT Doc, CTRDTYP...

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...

Thanks but I dont know HOW to make the group in the main report work, considering that all 3 Sub reports look at the START DATE and END DATE parameters differently: Sub report 1 uses INIT_FILING_DATE <= START DATE PARAMETER and CLOSING_DATE > END DATE PARAMETER AND Sub report 2 uses...

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...

I was displaying a group header and footer, but not the detail level of the report. Thanks regards BB *** Count your blessings not your problems****** :-)

Darn! Well thats kinda silly. Oh well, Thanks Lbass regards BB *** Count your blessings not your problems****** :-)

In the running total expert In Evaluate, select "use a Formula" Then put not(isnull({FIELD_NAME})) If these are NULL fields, it will exclude them but if they are blank fields you would need to put Not {FIELD_NAME} = "" Hope that helps regards BB *** Count your blessings not your...

Hi, Thanks for your assistance. Thought that might be the case. No probs in the meantime the user has come back and said they want the 2 split into 2 reports anyway, so its no longer an issue. Regards regards BB *** Count your blessings not your problems****** :-)

AWeSOME!!!! That does exactly what I need. Now I can fit everything on one page across with tons of room to spare. So I can even enlarge the text a little for the old managers to read. Excellent. regards BB *** Count your blessings not your problems****** :-)

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...