Search results for query: *

Hi Hope somneone can help. I have one crystal report that has 2 sub reports in. I run the report through Crystal Reports and the report runs fine with the 2 sub reports also displaying. If I run the same report in GoldMine, the main report displays but the sub reports don't. Any reason for...

Hi Guys Crystal 8.5 Is their anyway I can display all field values even if they have no values in. Basically I have a field that can contain either one of these value (SUPPIER,CUSTOMER,BUYER). So I want my cross tab to show all ot the field value even if their is no records with the selected...

Hi Guys I have created a cross tab that displays certain figures for each month. I need to add a column with static figurs to the cross tab. So at the moment my cross tab shows as: Jan Feb Mar Total Sports 1 2 2 5 Business 5 4 5...

Hi Guys Sorry another question. I have a parameter that prompts the user of payment details. Want I want to do is if user elect credit card the the next prompt is to ask fo Credit card details or if user seect Cheque then the next prompt will be for Chque number. Would I need to put an if...

Why didn't I think of that? Thanks for that it does exactly what I need it to do now.

Hi Guys Is it possile in Crystal Reports that you can have a field where you have the option to select an entry from the drop down. At themoment the users run the report with the contact informtion and then print of the page. They then have t type in by free hnd the information. But I was...

Hi Guys Found the answer DateDiff ("m",{CONTACT2.UA1},{CONTACT2.UA2}).

Hi Guys I have 2 date fields A1 & A2. How can I calculate the number of months between the 2 data fields? Thanks

Hi MJRBIM When your report runs automatically, does the screen maximise? I have created a .bat file and put the parameter of START /MAX however what happens is that HammerLaunch3 opens maximised but when it opens the report it goes back to normal size. Thanks

Thanks for that. Hopefully this is the last question. I can now get the report to run and have a scheduled task a minute before to kill the process. My next question is, when the report runs, the screen is not maximised, how can I get the screen to maximise automatically. Thanks

Thanks for the reply. I have downloaded a trial version of hammerlaunch and can view the crystal reports. However i am not sure how I can get the report to automatically refresh every 5 mins. Thanks

Hi Guys Is their a way that I can get Crystal Reports to automatically refresh every 5 mins with the same parameters. I want to set up a report that displays on a big screen that shows all user sales for the particular day. All users will be able to see the screen and the report refreshes...

Oh I did it the long/hard way. Thanks for the info LBass. i have managed to figure it out thanks to your info. Much appreciated.

I created a formula call 'aa' and this is the code if Sum ({@Value},{CONTACT1.CONTACT} ) > 200 then Sum ({@Value},{CONTACT1.CONTACT} ) else 0 So basically if the overall sales of a contact is over 200 then it will display their overall value else it will display 0. I then want to calculate...

Thanks for the Reply ibass. Yes Sale 2 for Joe Bloggs should be £110.00, was a typo. I have never used Running Totals before so will research that and give it a go. Would I have to create a new formula for running totals? Thanks for the feedback.

Hi Guys Hope someone can help as this is driving me crazy. I have data for person sales and I have grouped this as below. Joe Bloggs - Total Sales = £210.00 (This is group section) sale 1 = £100.00 sale 2 = £210.00 Jon Jones Total Sales =...