Current Position:Home > Passing a variable to an SQL Expression Field

Passing a variable to an SQL Expression Field

Update:11-30Source: network consolidation
Advertisement
Is it possible to pass a value or variable to an SQL Epression field?  I want to sum the values of open invoices for a particulat customer and want to do this using an SQL Expression Field.  I need this sum in a  subreport and since I can not put a subreport in a subreport I want to do it using an SQL Expression.
Thanks.
Ralph

The Best Answer

Advertisement
That would require a SELECT statement in the expression and they really are not designed to do that.
If you can't do this client side write a stored procedure then you have full control and CR is just used to display the data.
  • Passing a variable to an SQL Expression Field Update:11-30

    Is it possible to pass a value or variable to an SQL Epression field?  I want to sum the values of open invoices for a particulat customer and want to do this using an SQL Expression Field.  I need this sum in a  subreport and since I can not put a s

  • SQL Command/SQL Expression Fields Update:11-30

    CR XI R2 Hi All, Here's the situation. There is an SQL table of lookup codes.  The columns in the table are "FIELD", "VALUE", and "DESCR". The data looks like CRA_TYPE      RV     Receiving CRA_TYPE      AJ      Adjustment CU

  • Select statements inside a SQL Expression field Update:11-30

    Hello Why cannot we use the Select statements inside a SQL expression field in Crystal Reports ? Any alternatives for this... SELECT Top(1) "SomePrivateDatabase"."SPDname" FROM "SomePrivateDatabase" inner join "Subscribe

  • NOT ABLE TO SEE SQL EXPRESSION FIELDS IN CR2008 Update:10-11

    Hi, I am not able to see the SQL EXPRESSION FIELDS in the FIELD EXPLORER of CR 2008.Can you please help me BABASHARIHi, I would suggest you open the question in the Crystal Reports forum. IngoRead other 2 answers

  • How to pass a variable for a SQL query in OLEDB source? Update:10-11

    Hi All, I am new to SSIS and working on it past few days. Can anyone please help me getting through a scenario where I need to pass a variable in the SQL statement in OLEDB source connection. Please find below for the details. eg: 1) I have a SQL tab

  • SQL Expression Fields button not visible in Field Explorer Update:10-11

    Hi, On my Crystal Reports installation I can see the button SQL Expression Fields in Field Explorer but it is not visible on client's installation. How do I make it visible? I need to create a new report with SQL query for client. Thanks, Ajay Audich

  • SQL Expression fields do not display when no records are returned Update:10-11

    I have a report that uses SQl expression fields to summarize in the Report footer.  When the main report does not contain any records the SQL expression fields are blank. Is there a way to force these SQL expression fields to be evaluated evn when th

  • Select Expert or SQL Expression Fields help Update:11-30

    I am trying to do something I would consider very simple but can figure it out. I have two tables.  FDC_Trips & Facility.  On the report I can get the FDC_Trips.DivertedbyFacility field to populate a number value because that field is an integer.  Bu

  • SQL Expression Fields Update:11-30

    In crystal report 2008,I create a SQL Expression Fields,but how to write the SQL query in the formula workshop, Edited by: nylethx1 ye on Jul 23, 2008 9:48 AMSelect count(*) from Table Your query must return a unique value. From Don: SQL Expressions

  • Sql expression fields in subreports (CR XI) Update:11-30

    Post Author: yyu CA Forum: Data Connectivity and SQL Is it normal that the sql expression fields don't show up in a subreport? I don't see any. Does anyone know how? Thanks!Sorry for the delay getting back to you all. I set up a report against the xt