Recent content by FrankTWall

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