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

    Top N filter, sort Alphabetically

    I have a report that shows the drug name (group 1), and a the sum of the quantity. I need to show the top 25 quantites, but have the report sorted alphabetically. I am using CR11 and pulling from an Access 2003 DB. Thanks!
  2. bkrav

    Performance Testing in crystal

    I have a report that basically pulls one record from an Access DB, then passes that record along to several subreports. Is there a way in Crystal XI to determine how the report runs, including the time it takes to run all the subreports?
  3. bkrav

    CRXI - Formula in SQL query

    I have formula that calculates the first day of the next month in a formula, but in the SQL it only lets me add parameters. Is there a way to use formulas in the SQL? I would just put the where clause in the record selection formula, but the sql is a union statement and I need to use it in one...
  4. bkrav

    Crystal Viewer - Drill Down

    I was wondering if anyone could point me towards what the best Crystal Viewer is. I have Crystal 10 (upgaded from 9), and I also need the driver to support drill down capabilities. Thanks
  5. bkrav

    Straight out of college, what to consider before buying a car

    I just landed my first job as a reporting analyst at a small healthcare company. I currently drive a Honda, and it is the same model that my manager drives (however he has a family, it is the 4 door family sedan, whereas I am single and want something sporty). I was thinking about getting a...
  6. bkrav

    How can I only display Report Header B when on the Report Footer

    Crystal 10 I have Page Header A displaying a GroupBy variable, and I have a summary crosstab in the report footer, so when looking at the report footer I want to display Page Header B, that says the Total. I tried putting the OnLastRecord in the suppress formula but then it would display the...
  7. bkrav

    Excel: Lookup value based on two columns

    I have an Excel sheet (made from an Access query) that is has three columns: Site Date Price 1 7/24/06 9 2 7/24/06 10 3 7/24/06 4 1 7/25/06 8 2 7/25/06 3 3 7/25/06 7 I have another sheet that has all the sites listed down the left side as rows...

Part and Inventory Search

Back
Top