Search results for query: *

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?

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

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)...

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!

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?

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

???

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

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!

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

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

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

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

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

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

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!

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?

I should have specified that I want to pull the Price from Sheet1, the site names and dates are constant. Cheers.

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