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
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...
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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.