Reports

Alternative Crystal Reports
Hi, We have few applications which are running on WinNT environment and using crystal reports. We are migrating these applications to Win2003 and have few questions regarding the tool "Crystal Report 97": - Is it compatible with Win2003 Server? - Is it a good idea to replace it with some other tool? What ar... 27 Feb 2006 16:37

Setting Sort Order By Coding
I have a report that has a default Sort and Grouping (field names and Asc/Dsc). I also want to be able to set the Sort Order on the fly from within a form via a command button.using OrderBy and OrderByOn. 1. Can this be done? And without permanently changing the default sort order designed into the report Sor... 26 Feb 2006 21:41

Excluding weekends and holidays from date calculations
Hi - I have a client who would like a report comparing start date and completion date for various tests to determine how long it took to complete each test. The calculation needs to exclude weekends and holidays. Can anyone tell me if there is a way to do this and, if so, how? Thank you much. ... 20 Feb 2006 18:20

SQL
I have a report that feeds from a query - When I run the report, I want the last names in alphabetical order. Below is the SQL for the query. If you notice, at the end it states - ORDER BY LastName; - Why aren't the last names in order? Do I have to do something to the report? Thank you SELECT [LastName] &... 16 Feb 2006 10:44

dcount function
I have a main report called agents report. I have attached a subreport called sragents. An agent can register different type of loans such as :Primary", "Helock", "PM","RCES". The type of loans are listed in LoanCode column in the subreport. I have to make four text boxes in the main report which would capture... 12 Feb 2006 02:56

Fonts and symbols
This question would probably apply to any office app but I'm going to use the information on an Access report so I'll post it here. I need to print a symbol for degrees (Farenheit) on a report and can't seem to find a font family that will print this particular character which of course is only a super-scripte... 2 Feb 2006 16:39

Form Data to Report Data
I am sure I am making a newbie mistake, but I think I have a legitamate problem getting data from a form to a report. I have a very complex UNBOUND access form and it has several command buttons that spawn a few different reports. I know that generally reports have to open a form to get data, but in my case, ... 31 Jan 2006 09:13

"The OpenReport action was canceled" error message
Can not view any reports in any database using Access 2003 on my laptop only. Sometimes receive an error message above, most of the time - nothing. Tried everything I could think of, but re-imaging my laptop (re-installed Office 2003 Pro many times, even tried deleting my domain profile in XP Pro). I am a netwo... 26 Jan 2006 18:02

How can I get the median of the numbers in an Access Report?
I am trying to put a median function in the report footer in access for a series of rates. The mean(AVG) was no problem, but it doesn't appear that Access has a median function. How can I accomplish this? ... 24 Jan 2006 13:14

dlookup failure
Can anyone tell me what is wrong with the following syntax. =IIf([premium]=0,Null,DLookUp("[totalpremium]","qtotalprems",[netwtpeawt04.name]="[name]")). I've tried it several ways with the [ ],s. I just doesn't return a value even with one in the query. all return null thanks, Rong ... 9 Jan 2006 04:15