Search results for query: *

any help will be appreciated

Hi LB, the cross tab is working, in fact the report is working but the loading is very slow, the reason I guess is cause the Excel sheet is not linked to any other table. but if i link it ..then i get only the data that is present on the db and not the whole range of dates i need. How do i speed...

Hi Lb the formula for {@Merged_dt1} is date ((Mid ({BAQReportParameter.Option01},4 ,2 )+"/"+ Left ({BAQReportParameter.Option01}, 2) +"/" +Mid ({BAQReportParameter.Option01},7 ,4 ))); I had to resort to this formula cause my db returns date in us format mm/dd/yyyy and in text format...

I have the Excel sheet with 2 columns 1st with dates and 2nd with days of the week. Which in the Cross Tab, I added those 2 rows ex. Sheet_.F1 (this is first column in Excel where all dates are consecutive) Sheet_.Fri (this is the weekday names , sun, mon..etc) then in the summarised field...

i am able to join (left outer join) but does not give me the desired output. the formulas are as follows; Select Expert Record : {Sheet1_.F1} <= {@Merged_dt2} and {Sheet1_.F1} >= {@Merged_dt1} the merged date formula is nothing but the start date and end date in uk format rather than usa i.e...

Also another thought, what do you think about it. Can i use arrays to fill it with dates in the range ex fill the array with dates starting from 14/11/10 till 20/11/10.

if i link the Excel sheet with the data table , the SQL query looks like < SELECT `Sheet1_`.`F1`, `Sheet1_`.`Fri` FROM `Sheet1$` `Sheet1_` EXTERNAL JOIN Sheet1_.F1={?ReportDataSet: LaborHed.ClockInDate} > used external join so it should include the dates which don't have a record in the...

Hi LB, The SQL query is passing < SELECT `Sheet1_`.`F1`, `Sheet1_`.`Fri` FROM `Sheet1$` `Sheet1_` > the entire calendar I have filled the excel with consecutive dates for 10 years. The Excel sheet is not linked to other table, however if I link it then it only shows those dates which have...

Hi LB, The solution works fine, but is very slow , I think it is due to the excel sheet with dates I am linking, can I replace that with a formula to create dates.

Hi LB thanks, i got it working Finally , :) thanx a million, can you suggest a book for Crystal Reports (with advanced features explained).

Hi LB , i am able to capture the summary , assign value 0 if > 4.5 , and with suppress rows in Customise Style of Cross Tabs, am able to suppress rows, but it suppresses the dates which have 0 value as well ,(to give a more clear picture, those are the rows which have no records, coming from db...

hi I can suppress summary, but how do i suppress the whole row is there a work around, also in terms of the performance what do u think of cross tabs are they slow ? thanks in advance, you have been a great help LB.

hi I can suppress summary, but how do i suppress the whole row is there a work around, also in terms of the performance what do u think of cross tabs are they slow ? thanks in advance, you have been a freat help LB.

Hi I have a similar problem, I have an clock in solution, where i have some dates with data such as, various entries for a date eg, 01/11/2010 1hr, 01/11/2010 3 hrs etc, 03/11/2010 2hrs , 05/11/2010 4.5hrs, 05/11/2010 4 hrs so i need total for each day and highlight only those days, where total...