Recent content by heppme

select id_number, job_number, run_number, max_areasum areasum from ( select id_number, job_number,run_number, sum(area_percent) AS AREASUM, max(sum(area_percent)) over (partition by id_number) as max_areasum from ipc_peaks where ref_unit is not null and peak_name is not null and...

Thanks, the second one worked like a charm!

I've found an inelegant answer to my own question. I stopped checking for the double quote character within the text name and looked for found values off of a function: InStr(1,[DELTEK_PROJ]![PROJ_NAME],Chr(34)))>0

Here's the where clause: WHERE (((PROJ.PROJ_NAME) Like "*[ampersand#34;]*") AND ((PROJ.LVL_NO)=4) AND ((PROJ.ACTIVE_FL)="Y") AND ((PROJ.ALLOW_CHARGES_FL)="Y")); The ampersand is the character, not the word.

I have to filter for text where it contains the double quote character in a query. I have found that the ASCII value is 34, but have been unable to apply it correctly within Access.

I was able to get into the sight the second time, thanks. I've pointed this out to one of the dba's and they'll take a look at things from their side. Which means I'm on to other work in the meantime... Slizzo

Thanks for the response, but I'm not already a member at that site and don't wish to pay their fees to sign up. I'm going to move everything to another database and see if the problem still occurs.

I am working on Oracle 8i & Crystal Reports Developer 9.2.3.70. The report being developed works with data returned from a procedure. The error sometimes being generated when trying to run the report is as follows: Failed to Open Rowset. Query engine error: 'ORA-03113: end-of-file on...

Create a formula for each amenity. (Examp. Formula for Amenity Type 'B': If Amenities = 'B' then 'B' else null) Group on Rent$ and place all fields in this grouping for display. Grouped by Unit Type: A1 Grouped by Unit #: 101 Grouped by Rent$ 500.00 B G Y

We're on 8i.

Kenhamady, Yes, it would but it would bring null values in on the side of table two. Here's a real-life example and why I use this SQL: select * from proj a, genl_udef b where a.proj_id = b.genl_id(+) and a.proj_id = '010142.011' and (b.udef_lbl_key = 6 or b.udef_lbl_key is null) select * from...

You can filter on the table side with null values when using an outer-join. It works (in Oracle) as follows: select * from table1 a, table2 b where a.field1 = b.field1(+) and b.field2(+) = 123 I use this frequently in Toad and Crystal by editing the SQL statement and don't have any problems...

Add a distinct count total on the date field. Then go into Format Section on the group header and add a formula like this: if DistinctCount ({table_name.dos}, {group}) > 1 then true else false Hope this helps.

Rather than suppress items, add a group for country. This will separate the states/provinences according to country when the cross-tab is placed in that group footer or the report footer. To display the zero counts in each state, add a formula to handle the null values. Example: if...

I'm receiving this error and cannot find any helpful documentation. There are twelve sections in the report footer with individual cross-tabs. All involved amount formulas are one copied formula with minor changes to return different data ranges. All cross-tabs are a copy of the first cross...