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

    How to Save Renamed Axis Labels???

    I had a very similar issue whan loading graphs from XI to infoview. The graphs lost all the formatting I had painstakingly applied. This solution worked. Many thanks
  2. FrankTWall

    Parameter value to subreport - only one value returned need multiple

    Thanks very much for your suggestion Synapsevampire , redrew the synapse in my brain and saw the light you created. Fixed and thanks
  3. 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...
  4. FrankTWall

    Formula and cross tab shuts down CR?

    Just wondering if you ever solved this problem? It has happened to me today.
  5. FrankTWall

    Averaging weekday variable

    Spot on lbass, worked a treat. Many thanks
  6. 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...
  7. FrankTWall

    Parameter record selection dynamic and static

    Played around with this some more. Works well but I will have to educate the users that even though there is a default value appearing they are still searching by either the customer name OR SAP ID. Thanks
  8. FrankTWall

    Beyond Cross-Tab in Crystal X

    I am trying to work out what the % values relate to??? Might help with what responses you get.
  9. FrankTWall

    Parameter record selection dynamic and static

    Thanks K, I had used this formula with success but I was wanting to go to the next "step" where if they were prompted for the SAP ID , that was the only parameter requiring data and vica versa. Using this formula requires the user to enter both. I think one of the issues is that the customer...
  10. 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...
  11. 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...
  12. FrankTWall

    Cross tab date grouping by week - changing week start date

    Many thanks to you both for your suggestions. Tried them both and had the greatest success with LBass's suggestion. Great stuff, many thanks
  13. FrankTWall

    how to group data into weeks

    Select the date you require the group on, create group and then you get an option in the group dialogue box to group by day, week, month etc.
  14. 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...
  15. FrankTWall

    Percentile on summarised data

    Many thanks LB- got it working Frank
  16. 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...
  17. FrankTWall

    Median - on summarised data

    Thanks again LB I want to display the results of the formula for each Group in the Group Footer or report footer depending on where I am displaying other data (from running totals) I am at another place today but late yesterday I set up a seperate calculation and display formula (slightly...
  18. FrankTWall

    Median - on summarised data

    Ibass you are a legend and many thanks for the quick reply Now(there is always a follow up question), what is the best way to display the median for EACH group (they have to either be in the GF or RF Many thanks again
  19. 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...
  20. 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