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!

  • Congratulations TouchToneTommy 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: *

  • Users: c15bm
  • Content: Threads
  • Order by date
  1. c15bm

    Modifying format mask after 1st line (Oracle Reports 6)

    I have an invoice report that I've done some major cosmetic changes to. Another request that has come up is to have the "$" appear on the first line of Charge_Types but not on subsequent lines. They'd like this to be repeated for the charge_type details as well. I'm having a problem checking...
  2. c15bm

    Oracle 6I - Conditional Printing (eg. address lines)

    Not super familiar with Oracle Reports (been about 5-6 years). I've modified a report (an invoice) that prints the address. The report would have a company name line, an attention line (if present) then 2 street lines (if necessary) then a city/state line. When the Attention line is not...
  3. c15bm

    Inserting a subreport (query) into existing report

    Would like to insert a subreport into a current report. Having a problem creating the frame (list or form) with the subquery and actually being able to see the subreport. I insert the frame in top left corner, then insert the subreport into the frame (I think) - I can only see a small rectangle...
  4. c15bm

    Multiple Independent queries that create a P&L report

    Have Impromptu 7.1 I have used older Oracle Report Writers & also Crystal Advance 9.0 with an introductory course in Cognos report writing. Need to create a Profit and Loss report for Gas trading which is made of of 1)Physical Gas Deals, 2)Financial (Swaps) & 3)Transport Charges. The data...
  5. c15bm

    Subreport parameters - same as main report

    I have a main report calling 3-4 subreports. The subreports share the same parameters. Is there any way to pass the parameters from the main report, without having to re-define them in the subreport. The reason for this is that I have to plug in the report to a Fuels Management system and I...
  6. c15bm

    Summarizing a shared amount in main report

    Obtaining a total from the subreport in the Group3 Footer section (main report and subreport share the same 3 breaks) but with different tables (records not related). I thought I could bring the total for the lowest break to the main report via a shared variable (Crystal 9) the field is...
  7. c15bm

    Shared Variables- usage in main report

    this is related to my earlier post. Thanks for the help. In the subreport, I originally totalled the amount field by location_code, unit_name & facility_id. I suppressed all but the location_code summary amount. The main report has consumption quantity & amount field summarized by...
  8. c15bm

    Crystal 9 - shared variables passing from subreport

    I have a main report that suppresses the detail records, basically showing summaries of consumption data by location_code, unit_name & facility_name. Some of the consumption data is in a separate table, the records are not related to the main table in the main table - thus a subreport. I have...

Part and Inventory Search

Back
Top