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