Search results for query: *

I need to sum the values (in detail section) where another column's value is = "value a" and ingore/don't sum where <> "value a". This sum is going in the group footer. Payment Status 10.00 value a 12.00 value b 8.00 value c 10.00 value a total: 20.00

I have a stored procedure that I know is executing (sql query profiler) correctly and returning results however I am having problems filling session varables with the results of the recordset. Why am I doing wrong with the recordset? set objConn = server.CreateObject("ADODB.Command") set...

All, It's been a long time since I have worked with asp and I can't figure out what I am doing wrong. I am trying to execute a stored procedure and store the results in a session variable. On my .asp page I have a include file<!--#include file = "../common/Connect.inc" --> The Connect.inc...

I have a report that I need to modify the SQL. I have two tables, Table A has a datestamp and Table B list every day of the year with a time value of midnight. I need to link the two but since all of table B's time values are midnight I can't find a match in the Table A. I have tried to...

Is is possible using CR 8.5 to create a formula to change the color of individual bars in a bar chart? For example I need to change all the bars < 90% to red. If CR 8.5 can't do it does 9? Thanks

I have 10 individual reports that I need to combine into one weekly report package. I need to be able to export these to pdf as if they were one report. I have never really used sub reports before but I thought this may be my solution? If this is possible how would I set up a main report that...

My company has a policy that does not allow web servers to map to printers. I have several reports that I have created which are very wide(they contain 30 plus fields). I thought if I mapped to a plotter printer from my desktop computer it would give me additonal width, which it did. I now...

I am using the the hour function as follows: hour({tablename.open_date}). I am using this in a chart to display calls that were opened by hour & every hour is diplaying 8.00, 9.00 etc...and I can't get rid of the trailing zero's. If I convert the formula to text and trim the zero's it does not...

I cannot find a way to calculate Grand Total Calls below. I have the Technician Calls total's for Group #1 below. I need a way to sum ALL of the Technician Calls total's for each technician, overriding GH#1 or count every call_id(unique field) for each technician, overriding GH#1. The details...

I am trying to use a like statement with no success. Here is what I am doing: Dim ObjRS Dim StrSQL Dim varLocation varLocation = Request.Form(&quot;location&quot;) Set objRS = Server.CreateObject(&quot;ADODB.Recordset&quot;) StrSQL = &quot;SELECT LOCATION, REGION1, SITE_CATEGORY...

I need a way to group items by date depending when they are due(work days). For example, I need to look at the [current date] and compare to a field called [customer want date]. I then need to group items: Due Today, Due in 1 Business Day, Bue in 2 Business Days, etc.... How can I add...

I am in need of a formula that will loop through records in a table and calculate the time between two dates. The fields include a ticket number{NUMBER_SC}, the status of the ticket status {TYPE}(could be any of the following: open, assignment, reasignment, suspended, unsuspended, resolved...

I am trying to implement Ken Hamady's Business Hours Formula and I have run into a problem. I am a member of a reporting team that is over a Call Center. My {Start.Time} is the create date/time of a ticket and my {End.Time} is the date/time the ticket was resolved. This is a 24hr call...

I need to create a report that will show the last full week and the previous full week. Example: If a user runs the report on a Wed. the report will not inclue data from the current week but will show the last full week and the week before that. The report will have two charts comparing weekly...