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 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: FrankTWall
  • Content: Threads
  • Order by date
  1. FrankTWall

    Parameter value to subreport - only one value returned need multiple

    Crystal XI SQL database Have a main report with grouping on a formula , say Fibre DSL Internet etc there are 3 groups below this level but probably irrelevent for this question I want to have a sub report (at each group level) that selects the ID's from the data in the main report (at group...
  2. FrankTWall

    Averaging weekday variable

    Hi All, CRXI, SQL I "borrowed" this code off the , I think, FAQ's of this forum. Works a treat. Now I need to generate an average number of days by week and month (2 groups in my report) The results from the formula , shown below, are not available i.e. do not appear as report fields, when...
  3. FrankTWall

    Hyperlink Parameter record selection to subreport

    Crystal XI, SQL database Have a main report with a cross tab displaying in Row 1 - start date by month, Row 2 Customer name and then the Maximum of the contract ID for each customer. I want to create a hyperlink from this contract ID to a subreport displaying more detailed information...
  4. FrankTWall

    Parameter record selection dynamic and static

    Crystal XI, SQL server. I have a report I need the users to either select a SAP ID or a Customer name. I have set up dynamic parameter for the customer name and a static parameter for them to enter the SAP ID. I have a third parameter that allow them to chose whether they want to search by...
  5. FrankTWall

    Cross tab date grouping by week - changing week start date

    CRW X1, SQL DB Issue: Have a cross tab with 3 columns Column 1 - by Month Column 2 - by week Column 3 - by formula that forces "Week" (which is Mon - Friday) and then Sat and Sunday. i.e 3 groups within the week Rows are by region There is a date parameter and users will generally select...
  6. FrankTWall

    Percentile on summarised data

    I have searched this forum and cannot get my head around the correct way to solve this problem CRW V8.5, Oracle DB I have a report with 3 groups G1 - Case type G2 - case status G3 - case ID I have a formula that identifies which events in a case I want to count in the details section and I...
  7. FrankTWall

    Median - on summarised data

    I have searched this forum and cannot get my head around the correct way to solve this problem CRW V8.5, Oracle DB I have a report with 3 groups G1 - Case status G2 - case type G3 - case ID I have a formula that identifies which events in a case I want to count in the details section and I...
  8. FrankTWall

    CRW8 Stopping drill down on a group but viewing data

    Hi everyone, First post. I am wanting to view the group name and data from a group but don't want the user to be able to drill down on that group only the second group Any ideas? Frank

Part and Inventory Search

Back
Top