Search results for query: *

Okay, when I change only the ones that are messed up, the change is recorded when I save. There were several fields where I needed to change the format mixed up with others that didn't need changing and I was just selecting them all and changing the number format. When I only select the ones...

Actually they're summaries of formulas.

They're formulas, but I'm not specifying a format. I'll try putting the format in the formula.

I change 23.00 to 23, save the report, close it, open it back up and it hasn't changed. It's a new install and I haven't registered yet. Could that be it? Everything else saves and every once in a while (1 out of maybe 15 times saving to different files and folders and reimporting subreports) it...

In a group of records, I need not only the latest update datetime in the footer but also the latest user that updated. I've got a maximum(update_datetime) field, but how do I find the update user that shares the record with that field?

http://i3.photobucket.com/albums/y96/TripperDay/XtalTextWeirdness.jpg In all text objects and field headings in the Design and Preview tabs, Arial font displays every letter on top of each other. Very strange problem. Happens in every old report I open and new reports. Happens no matter what...

I got the same error message, and I realized it may be because we're using some special funky driver. Could that be it?

It's a SQL Server 2k database. I'm not using the command as a data source. I think I could, but first what I want to do is manipulate the data in a column so it can be used to join two tables together. Here's the command I'm trying to use: SELECT "JOIN_ACM_Contacts_ResApprover"."Request ID"...

I've got two views I want to link together, but the field I want to link on in one table has some extra characters, so I want to add a command like LEFT or SUBSTRING, but get an error like "Expected lexical element not found: <identifier>" or "Expected lexical element not found: FROM" I want my...

We're moving from Crystal Enterprise 10 to Business Objects XI and I need a report that lists the reports on BO XI that failed the previous day. In Crystal Enterprise 10, this was done using the CE10 database and APS_InfoObjects table. Unfortunately, the object name field in the BOE11 database...

I've got a field that's currently in hex I need to convert to text before putting it into the report. Anyone have a formula to do that?

Not trying to improve on synapsevampire's suggestion, just a simultaneous post.

I think the average should be 2.67. I'd do it with a formula dividing the count (or distinct count) of the of the cities by a distinct count of the states.

Thanks! I'm using version 11.

Not sure I'm using "metadata" correctly, but I'm trying to fix a report with about 20 formulas and 30 running totals defined by formulas. Is there any way to get a list of all those formulas so I can look at them and get a better idea of what this report is trying to accomplish?