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!

Register Log in
  • Congratulations strongm 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: *

  • Users: tmccoy1
  • Content: Threads
  • Order by date
  1. tmccoy1

    SQL Command join to external server/database

    Anyone have any tips for the correct syntax to use in the SQL command to join a table from an external server and database? This works in a straight sql query with brackets around the server name, but Crystal rejects that with an error. It also works to manually select the tables from each...
  2. tmccoy1

    Variable Parameter using SQL wildcard

    My report is based on an SQL command that sets variables based on a CASE statement based on a parameter select. It then uses the variables to populate part of the where clause to select records. Example: Set @var = CASE WHEN {?param} = 1 THEN '[^SUB]%' Select….. From… Where tbl.field LIKE...
  3. tmccoy1

    Conditional html formatting on a field in a formula

    This works on static text, but when using an actual field it just prints the field name on the report, bolded and in red. Any suggestions on fixing this in Crystal Reports 2008? IF {field_code} = 'Y' THEN "<html> <font color = red> <b> {field_value} </b> </font> </html>" ELSE {field_value}...
  4. tmccoy1

    Query results faster for larger criteria range

    I have a SQL Server 2008 query that runs by a date range for transactions. If I limit the date range to a period of 5 days or less, the query takes almost 2 full minutes to execute. However, if I set the date range for over 5 days, even for a period of several months, the results come back...
  5. tmccoy1

    Subreport and Link Parameters

    I have a report that typically pulls a small amount of data per instance since it is run per client ID. The main reports runs very quickly. When adding a needed subreport the report then takes a long time and appears to cycle through the entire database, rather than being narrowed by the...
  6. tmccoy1

    Exists subquery - missing results

    I would greatly appreciate extra eyes to try to solve this issue. The EXISTS subquery is eliminating a row(s) of data that it should not. The first part of the query, prior to the EXISTS subquery returns the record in question, and a separate query on the table used in the EXISTS subquery...
  7. tmccoy1

    SQL structure rejected by Crystal

    My SQL query runs fine in SQL management studio, but when pasting it into an SQL command in Crystal it is rejected with " HIST ...label is not among the applicable tables". Any pointers appreciated. here is the SQL Select chrg.field1, hist.field2, etc. FROM billing_tx_charge_detail AS chrg...
  8. tmccoy1

    Assistance with Replace

    I am modifying a report that uses a formula for a grouping and would appreciate any advise/explanation that anyone might offer. The formula is: REPLACE(TRIM(REPLACE({tbl.prog_val},{tbl.prog_code},'')),'/','-') I am new to the REPLACE function, but I believe that I follow its functionality in...

Part and Inventory Search

Back
Top