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 bkrike 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: WittyD
  • Content: Threads
  • Order by date
  1. WittyD

    Turn table on it's side

    Hello, I have a column that I am trying to display on one row. Unfortunately the tool I'm using is limited and I don't have the ability to use sp, and the reporting tool I'm using is limited so I'm left with a SQL query only. I'm using SQL 2005. Here is the table that I have: ID GROUPID...
  2. WittyD

    Group Description on Crosstab

    Using Crystal 9.0 and Timberline database access thorugh odbc. JCT_Transaction Cost_Code Amount 51-10-11 5.00 51-10-12 10.00 JCM_Standard_Cost_Codes Cost_Code Description 51-10-00 Land 51-10-11 Land Aquisition 51-10-12 Land Deposits Above are the two tables I...
  3. WittyD

    Help with formating formula for crosstab

    Using cr 9.0 I am trying to format a column on a crosstab report. The column is based on a formula that displays two separate fields. Here is the formula: "GSF: " & table.GSFTotal & " NSF: " & table.NSFTotal All I want to be able to do is have a "return" in the middle of the formula so it...
  4. WittyD

    Color code help

    Crystal Reports 9 Can someone explain how the color codes in Crystal work? I know crRed and 255 are equivilent. What kind of number sytem is this and how would I find out the codes for other colors?
  5. WittyD

    Suppressing Group Header

    I'm somewhat new to report writing so go easy on me. Lets see, currently I have this format: GH1 need to suppress if all all other GF's are suppressed GH2 always suppressed GF2 Suppressed if Variable =0 GF1 Suppressed if Variable =0 I can't base the formula to suppress GH1 on the variable so...
  6. WittyD

    Select Expert Problem

    I set up a condition in the select expert, Crystal Reports V9. Very simply, field date <= parameter date. For some reason it filters out most of the dates that are > the parameter date but it returns 2 dates that are > the parameter date. Anyone have any ideas? I'm stuck.
  7. WittyD

    Problems linking tables to a command

    I used a union statement and created a command in Crystal V9. I am having problems linking other tables to this command and receive an error message from crystal that says, "Unknow error." Do you have to do anything different to link tables to a command?
  8. WittyD

    Is there anyway to group off a shared variable coming from a subreport

    I understand crystal preforms grouping before it processes subreports. I just thought I would see if you gurus knew any tricks or tips for grouping a shared variable coming from a subreport. I am using crystal V9.

Part and Inventory Search

Back
Top