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 MikeeOK 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. ezamon

    Parameter not filtering data.

    Thank you for getting back to me Dgillz. I did that for the [manager] and [Year] field just now, but for the [Period] it is a little more complex (for me that is). I have two queries, the main query that gets the data from few different sources and the the Cross tab Query that my report is...
  2. ezamon

    Parameter not filtering data.

    Hello All, I have been working on an expense report using CR 8.5 working off of data from Access 2000 Crosstab Query. My report has been working when I hard code the filtered values in the Query that crosstab qry runs off of, but when I try to use Crystal Parameter Fields it returns all the...
  3. ezamon

    Getting Error message that I have never gotten before.

    I built a query that was working, now I have been getting an error message "Scaling of Decimal value resulted in data truncation," and my data is not coming back. I am using an ODBC connection, and I am not formating the decimal place. I am summing a formula that takes the 12 months of the last...
  4. ezamon

    Linking tables in Crystal Reports 8.5

    I have been trying to add a second table to my report and I have been having a little trouble as Crystal reports 8.5 does not seem to let you link to a table with out the column in the table being indexed (or primary key added). The only problem with that is the table that I need to link has a...
  5. ezamon

    Supressing fields with no records

    Cretin thanks for your post before, it worked but now I have spaces where the supressed rows are, do you know how to fix that? EZ
  6. ezamon

    Supressing fields with no records

    I have category names in Group header #1 which I would like to return only issues that are open. Example: Field name Count of open issues Sales 2 Computer 4 Email 1 Marketing 0 Car 10 So I'd like to take out the "Marketing" that has...
  7. ezamon

    Access 2000 Crosstab query with a Form

    So far I have 2 other people at work stumped on this one. I am trying to create a userfriendly way to run a report with a Form that has three Combo boxes. One is a Period field (or Month) second is a year field and third is a person's name. I have the cross tab working off another query that has...
  8. ezamon

    Access 2000 Crosstab query not working with a Form.

    So far I have 2 other people at work stumped on this one. I am trying to create a userfriendly way to run a report with a Form that has three Combo boxes. One is a Period field (or Month) second is a year field and third is a person's name. I have the cross tab working off another query that has...

Part and Inventory Search

Back
Top