Search results for query: *

What a bummer! I don't understand why would you release CR2008 SP1 but not Server SP1 if they don't work together. Only BO (SAP) can do this! Oh well it has been fixed by reinstalling everything again. Many thanks for your kind reply. Regards Jehanzeb Jehanzeb Crystal Reports 2008 Visual...

neozeke could you please let us know if you are using any sub reports on this ? or are there any redundant formulas or parameters or running totals placed in that report? Perhaps clicking on "Report--->Check Dependencies" might help you find the cause of this issue. Regards Jehanzeb Jehanzeb...

I was trying to avoid crosstab as I am not sure if it will export the data into Excel properly after using it. Plus there are quite alot of limitations in Crosstab. Saying that, I am trying it with Crosstab and will post the result soon. Many thanks once again regards Jehanzeb Crystal...

Afternoon all, I have to setup a report based on the dynamic parameter values and am not sure how it can be done?. I have dynamic parameter ({product_desc}, the report should show prices according to whatever description has been selected from the dynamic parameter. For example Parameters...

Dear all, I have created a report which consists of 3 sub reports. All three sub reports uses different date fields from different tables (though the database is the same). The main report uses its own date field which is from another table. So, there are 4 reports in all Main Report takes...

Got it! right(('00000'+Totext(recordnumber,0)),6) Regards Jehanzeb Jehanzeb Crystal Reports 2008 Visual Studio 2008 Informix Database

Morning all, I am aware that the record number function is used to allow "auto numbering" function in your report. However can you customize the numbering system so that it can start with 6 digits, i.e. 000001, 000002, 000003 and so on.... I have tried to use the "Number" tab under the field...

Well I tried using Mock Crosstab but that does the same thing, as long as it is on the single page it works fine but as soon as you click to the next page the percentages gets reset. Regards Jehanzeb Crystal Reports 2008 Visual Studio 2008 Informix Database

Perhaps this is the answer to my question?? Bug with multi-page cross-tabs and global variables Thursday 4 December 2008 @ 12:40 am Some of you may have played with a technique that I have written about in the past. It is where you use a variable to create running totals within a cross-tab...

...the Normal Percentage field. Whileprintingrecords; Numbervar x:=Currentfieldvalue; Numbervar c:={@TotalJobs-CancelledJobs}; Numbervar v:=((x/c)*100); Numbervar gTot:=gTot+v; if gTot > 100 then "100.00%" else totext(gTot,2)+"%" Then I created another formula reset which I placed on...

Thanks IIbas, I have just entered the information as you suggested and now running the report. Will post once the records are perfect :-)) Many thanks once again Regards Jehanzeb Jehanzeb Crystal Reports 2008 Visual Studio 2008 Informix Database

Happy new year IIbass and thanks for your kind help with this query. Yes. Daily means Currentdate. Daily, Last 5 Days, Last 4 Weeks and Year to date - all are setup as Working days by the use of formula. One question when you said, you would setup a String parameter and use that parameter to...

Perhaps I might be able to use {Order_Header.Date_Entered} >= Today-365? Regards Jehanzeb Crystal Reports 2008 Visual Studio 2008 Informix Database

Can I setup 4 different criteria within Record Selection formula? Regards Jehanzeb Crystal Reports 2008 Visual Studio 2008 Informix Database

Morning all (happy new year! :-))) I have found one problem with my report which calculates number of returns and credits. The report is set to 4 date criterias. 1: Daily 2: Last 5 Days 3: Last 4 Weeks 4: Year to date Now to get the report work faster I added a formula into the report record...

I think I answered my own question while typing the question. I placed the graph on the group header and kept the footer for the data and clicked on Keep group together. It worked like a charm :D Regards Jehanzeb Jehanzeb Crystal Reports 2008 Visual Studio 2008 Informix Database

Dear all, I have created a report which is working perfectly however the problem this time is the layout of the report. For example. Right after the graph on the first page (Group Footer 1a), data starts to show up, which means, the data adjusts itself either on page 1 or 2 by itself. That...

IIbass this has been sorted out now :-)) I realised it afterwards and fixed it :-) Now the issue is showing the same number of days on the graph as it does not reflect those values which contain "Null" or "0" value. As far as the above question it has been sorted. Regards Jehanzeb Jehanzeb...

Right I have tried the way it says it, I grouped it by number of days in ascending order.I then used formula (from 0 to 10 days) If {@NumofDays}="0" then if ({order_header.order_status})>0 then if ({order_header.order_status})>-1 then ({order_header.order_no}) and placed all of them in the...

...of holidays DateVar Array Holidays; // Bank holidays dates array Weeks:=(Truncate(End - dayofweek(End) + 1 - (Start - dayofweek(Start) + 1))/7)*5; Days:=DayOfWeek(end) - Dayofweek(Start) + 1 + (if dayofweek(start) = 1 then -1 else 0) //adjust for starting on sunday: +(if dayofweek(end) = 7...