Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. heppme

    SQL - Limiting result sets for aggregate functions

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

    Filter on text containing double quote

    Thanks, the second one worked like a charm!
  3. heppme

    Filter on text containing double quote

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

    Filter on text containing double quote

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

    Filter on text containing double quote

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

    End-of-file on communication Channel

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

    End-of-file on communication Channel

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

    End-of-file on communication Channel

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

    Mulitple rows for a record

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

    Left join limitation

    We're on 8i.
  11. heppme

    Left join limitation

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

    Left join limitation

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

    Comparing and Suppressing the records

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

    Suppression of row items in a CR8.5 crosstab report

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

    Error Formatting Cross-Tab Object

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

    2nd time posted, pls help, issues with sorting output

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

    Multiple Cross Tabs and Summary Vs Running Total

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

    Multiple Cross Tabs and Summary Vs Running Total

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

Part and Inventory Search

Back
Top