Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. davew123

    Automating Datasource Change

    Thanks, Ken. Looks like that may do the trick, however, does it support Crystal 2008? - I see that Crystal XI is the latest supported version according to the documentation.
  2. davew123

    Automating Datasource Change

    Hello I have a number of reports which connect to a datasource (ODBC DB) which I intend to split into two seperate sources. This will mean identifying each report using this datasource and amending them manually to use the two new datasources where tables are required from each. I'll also need...
  3. davew123

    Passing Arrays from formula fields

    Thanks for the help lbass. As the data I am using is going to remain relatively static I may not want to have if as in input parameter. How could I replace the parameter entry in your example not({table.field} in {?excludedvals}) with a formula field which held the values? (eg...
  4. davew123

    Passing Arrays from formula fields

    I have a report with a subreport which both need to select on some data. For example not {table.field} in ["001a","002b"] I want to avoid duplication of data within the reports and so would like to store the data in a formula field and pass the data down to the subreport. For example: in...
  5. davew123

    SQL Query and Formula Fields

    Sorry, I probably didn't explain myself clearly. I have a report based on a command which takes in 2 parameters, a start date and an end date. In our system we store dates in a completely different manner (i.e. not M/D/Y or any combination of that format). To make life easier I want to be able...
  6. davew123

    SQL Query and Formula Fields

    Is there any way to include a formula field in an SQL query written using 'Add Command'? I need to take in a parameter and process it in order to derive the value needed for the query. Regards David Williams
  7. davew123

    Problem with totals and charts

    Hello I wonder if anybody can help me with a problem I currently have. I have written a report which groups some detail data by client, group1, group2. Client and group1 are always populated but group2 may be blank. In the detail of the report I need to see info for all by client and group1...

Part and Inventory Search

Back
Top