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 strongm 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
  • 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

    Question on parameters, I have a report with 3-4 subreports, the subreports share similiar parameters. Is there a way to pass the parameters to the subreports rather than recreating them for each subreport.
  7. 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...
  8. c15bm

    Shared Variables- usage in main report

    Not sure I understand. Even if I create another formula using the total from the location_code field, the new formula doesn't appear in the listing of fields to summarize. Could you give me an example of how to create the formula and use it ?? Thanks
  9. 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...
  10. 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