Search results for query: *

Ok. This has me crazy. I'm sharing a value from subreport to main report and it's doing something odd. I've tried a dozen different troubleshooting steps and have stripped everything down to the basics to see what is going wrong. Here's the final troubleshooting steps I'm at. //...

Making a simple macro to open a series of workbooks, select certain cells out of them and copy to ThisWorkbook I have it all set up and working, my code works, but I know there has to be a more elegant solution. The cells I'm copying from are, of course, not in any logical order. Some are...

I've got a series of reports I'm tasked with maintaining, I know there has to be a better way of doing this but I don't know how to go about it. The existing reports are all organized with sub-reports, each distinct product is in it's own sub-report. These are problematic to maintain...

I know I've done this in the past but I haven't done it in a number of years. The answer is in my head but I just can't remember how to do it. Desired output: UserID TotalCalls ShortCalls 100 200 10 101 210 50 102 150 6...

There's got to be something simple I'm overlooking, I have one specific variable that seems to have quit passing it's value to my parent report. CR XI Subreport variables @SPSCAban shared numbervar SPSCAban; If condition = 1 then SPSCAban := sum(table.abandon) @SPSCHandled shared numbervar...

Working on a series of reports and I ran into a bit of a problem. CR XI, pulling from Informix, DB2 and Oracle DBs I am pulling data from 4 sources, each within it's own subreport, and compiling numbers to show combined scores. A row in my databases is created each time there is activity on a...

Reaching out to this group for suggestions again. Sample of data Date Target_Calls Total_Calls 3/1/09 100 110 3/2/09 200 230 3/3/09 225 250 ... 3/21/09 115 125 Here's what I'm trying to accompish. MTD score which is defined as...

Hi folks, hope you can help me work out the logic on a problem I have. Average Speed of Answer (ASA) defined as Answer_Time * Handled_Calls. Therefore, Answer_Time = ASA * Handled_Calls. I receive my data in the following format: Date ASA Calls_Handled 3/1/09 20 100 3/2/09...

Hi all, I tried searching for a previous example however using the work 'like' gives many, many results :) I have a report I've inherited and I'm stuck on a problem. Querying MS SQL Server and I'm trying to get a list of Object_IDs. Example of table 1 Date_field, object_id, data_field1...

I hope someone can give me a hand while I'm learning the ins-and-outs of Informix. I have a table with a bunch of data including dates in Datetime Year to Minute format. I want to run a query and sum it up by date, I'm struggling with it's wonky time formats. select date(d_time)...

I'm getting the dreaded "A subscript must be between 1 and the size of the array" error. Searching for that error produces many results and I know what's causing it but I just can't figure out why in this case. Handed an old report at my new job and told a) understand how it works and b) fix...