Search results for query: *

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...

Create a formula to establish the type heirarchy (examp. if status = 'Alumni' then 1 else if ...). Sort on this field. Create a formula to display the minimum (if top of heirarchy is assigned a one) status field [examp. minimum({@heirarchy},id) and place this in the id header or footer.

Thanks, both of you, for the response. I am faking a running total by changing signs in some of the detail to get the totals needed. Unfortunately, separate sections won't work as the 'running totals' are in the midst of the report. Could try many (5-6) sections and separate cross tabs for...

I am developing a cross-tab report for the dynamic column capability. There are only three rows, but a mix of summary and running totals are required. Thought the fix was to have two identical cross-tabs placed one over the other and suppress the totals as needed to display only the required...