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

    Top / Bottom End Parameter

    You could always have the hyperlink point to two different reports. I'm sure theres a way to do it using a Select Top statement, how comfurtable are you using commands within Crystal?
  2. bkrav

    Top N filter, sort Alphabetically

    Got it working. This is the command I used- select top 25 RX.RX_Site_Code, RX.RX_Drug_Name, Sum(RX.RX_Qty) AS SumOfRX_Qty, Sum(RX.RX_Price) AS SumOfRX_Price, RX.RX_Site_Code FROM RX GROUP BY RX.RX_Site_Code, RX.RX_Drug_Name, RX.RX_Site_Code HAVING (((RX.RX_Site_Code)={?Site Code})) ORDER BY...
  3. bkrav

    Top N filter, sort Alphabetically

    Thanks for your quick reply, but I am not completely following you. This is the command that I have - SELECT RX.RX_Site_Code, RX.RX_Drug_Name, Sum(RX.RX_Qty) AS SumOfRX_Qty, Sum(RX.RX_Price) AS SumOfRX_Price FROM Site INNER JOIN RX ON Site.Site_Code = RX.RX_Site_Code WHERE (((RX.RX_Date)...
  4. 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!
  5. 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?
  6. 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...
  7. 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
  8. bkrav

    How to select X number of months based on 1 parm date

    Hi! This code (done in Crystal 10) will select records based on a parameter (?date) for the last X number of dates (which can also be a parameter, or simply hardcoded like in the example). This code is useful when you only want one date entered as a parameter, as it could easily be...
  9. bkrav

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

    Thanks for everyone’s input. I already looked into all associated costs (insurance, fuel, maintenance). I was trying to get an idea on how your vehicle (and image) could effect a career path. I plan on buying a 2007 GTI. See you on the highway. Cheers!
  10. bkrav

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

    drlex, you do bring up a good point. I think showing that I am willing to work hard for what I want will show ambition, especially since the people that have had my job previously just went through the motions and didn't try to improve anything. Grenage, I have only been here a month so I hope...
  11. bkrav

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

    You guessed right I am from the good ol USA. The cost of the is vehicle is about 10 grand less than a years salary, so financed out over 3-5 years (and trading in my $3K car) makes the payments very manageable, and I have a very good credit rating so I will not need a cosigner. Insurance will...
  12. 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...
  13. bkrav

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

    The thing is the total crosstab located in the report footer is sometimes 2-3 pages, so starting it on a specific page will not always work. Perhaps I could just place a title in the crosstab that displays on every page? The whole idea heree is that this one report can just be updated and then...
  14. 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...
  15. bkrav

    A better way to set up tables

    Why not store everything on a single table? The only reason I wouldn't would be if multiple patients have the same emergency contact and phone number, which would probably be unlinkely. Also, check out the naming conventions faq:http://www.tek-tips.com/faqs.cfm?fid=2190
  16. bkrav

    Excel: Lookup value based on two columns

    Ahhh, I tried making the range larger but I was only changing the range for the first part of the equation, not for all three parts. Thanks for the help!
  17. bkrav

    Excel: Lookup value based on two columns

    John, I got the formula you suggested to work, however I need to be able to search from around a thousand rows, and I get a #NUM error when I try to have it search the entire column. Is it possible to search the entire column?
  18. bkrav

    Excel: Lookup value based on two columns

    I should have specified that I want to pull the Price from Sheet1, the site names and dates are constant. Cheers.
  19. 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