Search results for query: *

Hi Haven't got any better tips so I will use your formula. Thanks! Greta

Hi, I guess you mean calling a PL/SQL function (returns one value)this is possible, I use it a lot in my reports. As synapsevampire says you have not given your CR version or database, but since PL/SQL is an Oracle language i guess you are using Oracle database. You write the call to the...

Hi I'm using Crystal Reports XI and Oracle database. I have date fields that I want to extract only the day part of, and with the format 1st, 2nd, 3rd etc. Does anyone know if this is possible and which format I should specify in the formula? Thanks! Greta

Thanks lbass for always giving good answers. I know the reason that the main report is blank, there are no data in all the tables I use in this report (it is a new project suffering from lack of test data so far) I tried to reference the shared variable directly in my formula: shared...

Hi I'm using CRXI I have a subreport that contains 3 shared variables (unit, unit_type and currency). The code are similar to this in all 3 whileprintingrecords; Shared stringvar unit_type:= {UNIT.UNIT_TYPE}; The subreport is placed in the report header of the main report. These 3 shared...

Sorry for not being clear. I am using CR Developer XI, and am using tables to select the data (not command object). When I create the report I select tables from one schema, and this gets prefixed in the SQL (SchemaName.TableName.ColumnName). I wondered if there was any method of changing...

Hi I am using CR XI and Oracle 9. I have a database with different schemas/users in it with the same table structure but different data. How can I change manually between these schemas/users when running the report, and is it possible to add it as a parameter field? Thanks for any answers...

Thanks lbass, that seems to do the trick! -Greta

Hi, Still using CR XI and Oracle database. I posted a thread earlier today, found out some of that myself, but encountered more crosstab problems... Here is what the crosstab should look like (in design mode) the lines here should represent single lines size hairline...

Hi There is an option in the section expert that says supress if blank section. I guess you can use this to supress the section if it returns no data. To display the message you maybe can create a new section below/above the section that returns no data, and add a text field here with the...

Hi I have a crosstab report (Crystal XI, Oracle) where I want three summarize fields, but for two of them I only want to show the total (row total for one and column total for the other) is this possible in some way? Example Month Seller 1 Seller 2.. Seller5 Total ActualGCV Jan...

Hi Do anyone know if it is possible to call PL/SQL functions outside SQL Expressions? I have a PL/SQL function where I want to send in the parameterfield I get in the report as a parameter to the function. That does not seem to be possible in SQL expressions... I use Crystal Reports XI and...

thanks lbass for your time and effort in trying to help me. I think I might have found a workaraoud for this problem. So for anyone who is interessted this is what I have done: problem: if input year = 2005 and start = 10 contract year is between 1.10.2005 and 30.09.2006, if input year = 2005...

Again, thanks for your quick answer :) Maybe I have done something wrong then.. Here's my record selection formula: {CONTRACT_INFO.REVISION_NO} = {%Max Revision No} and {CONTRACT_INFO.VALID_FROM_DATE} = {%Max valid from date} and {CONTR_ACCUMULATOR.CONTR_ACC_DATE} in date({?Invoice...

lbass, thanks for your answer. This formula probably works fine, but the problem is that it doesn't seem to be pushed down to the database, which means I will get a lot more data than nececary from the database, which will slow down performance. Is there any way to make this formula so that it...

Thanks Ibass, just what I was wondering if was possible. I will try this. I also thought of putting the subquery in a PL/SQL function, and might do this if a command does not solve my problem. I also have another problem where I should use parameters in a SQL expression, maybe you or someone...

synapsevampire, Thanks for your answer. I am using Oracle 9 database. This is a complicated report with several sub-reports in it. If I use a Command object for the entire sql how will this effect the subreport links and the formula fields that I already have made? madawc, thanks for your...

Hi, I'm using Crystal Reports XI. Is it possible to add parameter fields in SQL Expressions? I want to create a subquery in an SQL expression and in that subquery I need to use the parameterfields from the report to select the correct record. Example Select CONTRACT_INVOICE.INVOICE_YEAR...