Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Gino2020

    Crosstab suppress some rows

    any help will be appreciated
  2. Gino2020

    Crosstab suppress some rows

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

    Crosstab suppress some rows

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

    Crosstab suppress some rows

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

    Crosstab suppress some rows

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

    Crosstab suppress some rows

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

    Crosstab suppress some rows

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

    Crosstab suppress some rows

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

    Crosstab suppress some rows

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

    Crosstab suppress some rows

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

    Crosstab suppress some rows

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

    Crosstab suppress some rows

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

    Crosstab suppress some rows

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

    Crosstab suppress some rows

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

Part and Inventory Search

Back
Top