Search results for query: *

I have a report that groups and sorts by a stream name attribute- a string, obviously. Most records are sorted correctly, but a handful having names like Joe Creek Trib 2, Joe Creek Trib 12, etc are not sorted correctly. It reads "Trib 2" as being alphabetically after "Trib 12" (presumably...

I am trying to streamline report generation from ArcMap (GIS software that uses CR to create reports from in-document data). To do this, it seems that I need to create an RDF file, but I can find almost zero information about RDFs, how to generate one, how to manipulate them, etc. Are there...

I've got about 800 files I need in about 200 seperate zip files. I have access to a WinXP Pro (with native zip support) but it doesn't seem to be able to create a zip file. I understand the syntax for adding to a zip, but nothing seems to want to create one from the command line. I'm working...

Using CR XI, is it possible to center text horizontally and vertically within a text box? Thanks, dylan

I feel like I'm missing some nuance/feature of the program here... I'm using CR XI. I have the option selected to show guidelines in design view and in preview. I can set, view, and manipulate these guidelines fine in design view, but I can't see them in preview. I do have the option selected...

Does anyone know why when I go to size (right click: size and position) a box, Crystal Reports changes the values I enter? If I enter a width of 2.910 and height of 0.540 in the Object Size and Position box, hit OK, and reopen the Size and Position box, the numbers have changed; usually they...

I need to limit the range the date code I got from an FAQ that places the current date in the neighboring cell. That code works fantastic, but it applies to the entire column. I only need it to apply itself to rows 3 through 45. Not sure what to manipulate to accomplish that. This is the...

I'm trying to create some sort of template in CR XI. I have a report formatted exactly how it needs to be. However, I need to be able to change the data source for a handful of fields from one table to another table in the same database. The field names will be exactly the same, just the...

Is there a function similar counta() that does not count cells with formulas in them? perhaps one that only considers the results of that formula? thanks, dylan

I'm busy making a simple spreadsheet complicated for my own learning experience, so thanks for the patience... I have a data validation drop down menu, but my users are very resistant to change. Previously, we entered our initials in certain cells. The drop down menu is great, but I suspect a...

I'm sure this has been addressed, but I need to calculate a cell with the date of the day another cell is filled in. Any suggestions? I know I can write something like: =IF(COUNTA(A1))=1,"date","") But I don't want Excel to recalculate the date everytime it refreshes. Thanks, dylan

I'm trying automatically generate a report I have to reproduce for a large volume of data. I have the MDB query set up returning the correct values, but I need the data grouped- similar to how, say, Crystal Reports can group based on an attribute. Is there a way to do this? Is there a...

Does anyone know why when I turn off the start up prompt about updating automatic links (Edit>Links...>Startup Prompt>Don't display the alert and update the links) I still get prompted? What's going on? Am I misunderstanding "Don't display the alert" ? Thanks! dylan

Does anyone have some tips on how to get a border around a particular section? I've got the borders around individual objects down pat, but could really use an easy way to outline each section. I'm using Crystal Reports XI. Thanks, dylan

I'm using Crystal Reports 11 and can't get the object size and position box to hold the values I enter. I assume there's some limit to the precision, but it's not really even close to the numbers I enter. I'll enter 0.1875, for example, enter the other numbers, hit enter, and nothing changes...

I've got a formula that references another spreadsheet. Basically, it goes down a row starting at, say, D3 and checks to see if anything has been entered. If it has, I want some text to show up; if D3 is empty, I want it to check C3, then B3, etc. Normally D3, C3, etc. will have an 'x' in it...

I've got a spreadsheet used across our office by about a dozen people. I needed to change some values, blah, blah, blah and created a macro do it. Used the macro, then deleted it. However, everyone in the office now gets a warning about macro security when they open my spreadsheet. I know...

Is it possible to link data in an Access database (geodatabase, for what it's worth) to an excel sheet? I'm not sure how to go about doing this. Thanks, dh42891

I have about 1500 files taking up about 50 gigs of space. Unfortunately, it seems I may not have copied all the files from their original location. Is there a copy command I can run that will not overwrite? I know I can specify a flag that will tell windows to automatically overwrite, but I...

I'm creating a progress tracking spreadsheet. I'm new to this and only need a simple formula that calculates a percent, but I'm trying to figure more complicated stuff out. I'm using COUNTA to count the instances in one column and divide it by the instances in another. Now, I'm hoping there...