Search results for query: *

synapsevampire, The only problem with linking the two databases is this... The location database is always the same until it gets updated. The other database is new every month. I just delete (archive) the old database, and copy in the new one, rename it and start running the reports. Derek

As far as the Underlay, none of the reports I looked at had that checked. One thing I noticed on the last one I ran, it worked on the last page but none of the rest. Derek

I don't have any service packs. I am downloading it now. Underlaying? Not sure what that is. What does it do? How would I check to see if it set that way? Thanks.

Here's the story... CR9. Main report pulls data from one access database. The subreport compares areacode and prefix derived from a formula in the first database and compares it to the second database (access). It then sends back the location for the main report to show. The problem... Some...

I am using CR9. I have a report that calculates all incoming calls for an 800 number. Each 800 number is a group. I have set it to start a new page for each group. Since each 800 belongs to a different customer, I'd like to start the page numbers over for each group. That way I could pring to...

I ended up cheating on this one. There were three fields that had to do with time. The first was DATE, there was also TIME and DATE/TIME. The way I did it was to ask the user what month. They would type "May" I had a formula that converted that to 05. Then I had another formula that took the...

I figured it out. Took a while. But I got it. However, I am not seeing how to turn a field into a date field. I need to prompt the user for a month required and the only way to do that is to compare the prompted value to a formula that pulls out the month. I can't do that unless I am able to...

I am using CR9. I am trying to create a report where I calculate cost of a phone call. The database I am getting from the phone company is a CSV file. When I create a report for it, all the fields show up as String[255]. Half of my options are missing. I can't use SUM on running totals. Formulas...

You are a genius! Thanks again. It takes while to run the report (60k records in 1st DB and 400k+ records in 2nd DB). I am going to put it on a dual processor server with more memory and give it a shot. Thanks again

Well, I ended up purchasing a database. The same links and subreport works great with just a few changes. The problem is that it the subreport is handing back multiple answers even though they are the same answer. Sometimes 3 or 4 or 8 answers or more. Another weird thing is there are two...

I think I may have it. I ended up using the mid formula to get the 6 digits that make up the area code and prefix and linked them to a formula in the subreport that concatenates the area code and prefix from the second database. Then it pulled the right info. Thank you very much for helping me...

The main reason is I don't 100% understand what needs to be done to get the end result. The links are causing me problems. I'm not understanding what to link to what. Am I linking formulas in the main report to actual fields in the subreport? I go to the subreport links and pick the mid...

Right now, I do have both databases in the main report but there are no links. The only group I have created is for sorting by the extension that made the call. In that group there are all the calls that were made by that extension during the time frame that I prompt for. It also calculates...

I am sure I'm missing something. Lets Say I dial the number 917897770000 Here is an example of what's in the second database 987 222 Dallas TX 654 333 Norwalk OH 321 444 Chicago IL 123 555 Charlston...

lbass, Thanks for your reply. So far I can display the area code and prefix portions perfectly. However, I am not seeing how to link the area code and prefix to the subreport. Also I don't have the second database yet. We haven't decided which one to purchase. I downloaded a demo portion of...

Sorry. I neglected to mention I am using version 9.

I need to find out how to get a location based on phone number called. The first database has all the phone call info like calling party, called party, time, date, length, etc. The second database will have area code, prefix, city, state, etc. Based on the CALLEDPARTY which will look like...