Search results for query: *

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

Thanks very much for your suggestion Synapsevampire , redrew the synapse in my brain and saw the light you created. Fixed and thanks

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

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

Spot on lbass, worked a treat. Many thanks

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

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

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

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

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

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

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

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.

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

Many thanks LB- got it working Frank

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

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

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

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

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