Recent content by csm2

Some time ago I put a quick & dirty report out on a web server for the user. Since then I have fully developed the report on my local machine. When I transfered the new version to the web server and ran it, the old version ran even though I deleted itoff the server. How can I make sure that...

I need to take the calculation another step further. I need to calculate: the percentage difference from District Office average of each Nurse's individual average and the percentage difference from Departmental average of each Nurse's individual average. I was given the following...

My user is a Health Dept with 4 District Offices. They want to know the Average Number of daily visits each nurse in each DO makes during a month. They also want to know the % Difference from DO average of each nurse's average, as well as % Difference from Departmental average (all DO's...

How about creating a record set in SQL Designer, using the main query. Bring in the resulting recordset in to Report Designer and create a report using the sub-query.

cretanion Are grouping on month?

Why use a date range? IMHO it introduces potential problems. 1) The user needs to make sure that 12-20 characters are entered correctly rather than 6-10 characters. 2) In coding the "ToText" statement, one must keep track of all the parents. 3) The use of "Min" &...

Check to see if you have "Save Data With Report" checked. If so, then un-check it.

If all your sort fields are of the same datatype, all is OK. If they are different, you will have to change them to the same datatype: if {?SortOrder} = "N" then ToText ({table.date},"yyyy-MM-dd") else if {?SortOrder} = "D" then ToText...

Are you sorting on one field at a time or do you want to have a multi-level sort?

GaryWilson - No, I do not. Why do you ask?

On the "Set Default Values" screen, I have all the fields blank except for the "Select or Enter Value to Add" which shows current date in MM/DD/YYYY format. If you click on the drop down arrow, a calendar for the current month is displayed with current date highlighted. I...

I don't know if this will help you but when I have a SQL query with a sub-query, I run the main query in SQL Designer creating a recordset which is input to Report Designer where I execute the subquery.

Include field _TELMASTE_.DATE OPEN in the SQL Select statement. In CR Select Expert: set the value in the first drop down box to "is between" set the vakue in the second drop down box to "?FromDate" set the value in the third drop down box to "?ToDate" When...

If the year will play part in the charts then you must make YEAR part of your record selection formula or your grouping formula. Otherwise, if you just group on month, you will have multiple years included in your totals.

Do you need to take the year into account?