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!

  • Congratulations strongm 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. nb4884

    Export to excel splitting in 2 lines

    Thanks LB, I made all objects the same size and work around the guidelines and also there were some fields in sub report , which were placed in the details sections but I did not want to show them. Removing these fields and making the fields the same size, checking guidelines worked. Thanks
  2. nb4884

    Export to excel splitting in 2 lines

    Sorry my subreport is in gp footer 1a and Sum is in GP footer 1b. There is no GP footer 2
  3. nb4884

    Export to excel splitting in 2 lines

    GP 2 displays a column for sum from 2 sub reports. It is singlw value. (My previous post on how to add data from subreports and display in main report) All other fields inlcuding 2 subreports are in GP_1 Also I noticed that the gp_2 value not only displays where it should be but also displays...
  4. nb4884

    Export to excel splitting in 2 lines

    All, I have about 20 columns in my report . When export to excel it displays 12 columns in one one row but other 8 columns are in row 2. What could be causing this? I have all 19 columns in gp_1 and 1 column in gp_2. gp_1 has underlay following sections checked in. One column that is in...
  5. nb4884

    Add data from subreports and display in main report

    Bruce, What does it mean "Must be in a section after the subreport." I cant place subreports and the subtotal from subreports in same section , which is group footer? I have placed 2 sub reports in main report in main report's grp footer. I want to place the sum from these 2 reprots next to...
  6. nb4884

    Add data from subreports and display in main report

    Subreports are located in Group Footer. Want to display the sum from supreports in group footer as well. Thanks
  7. nb4884

    display data in different branches

    Hi All, I have a report which has 5 phases. 1,2,3,4,5. Each project has a phase. Project has costs in multiple phases For ex: Data for costs in phase 5 project is Phase Department $$ 3 HR 500 5 Accounts 100 5 Admin 200 2 Accounts 300 1...
  8. nb4884

    Add data from subreports and display in main report

    Hi All, Is there a way to get data from 2 subreports and add them as a column in main report ? Here is what my data looks like: Subreport 1 Formula 1, Formula 2 Subreport 2 Formula 3, Formula 4 I have these 2 subreports in main report where Subreport 1 displays Formula 1 in a column in...
  9. nb4884

    Formula for current date calculations

    Thanks LB:) You are awesome !!!
  10. nb4884

    Formula for current date calculations

    I used the same formula as : if year({table.date}+184) = year(currentdate+184) and {table.date} > currentdate then ( if month({table.date}) <> month(currentdate) then {table.monthlyusage} else ( {table.monthlyusage}/ day( dateserial(year(currentdate), month(currentdate)+1,1)-1 )* ( day (...
  11. nb4884

    Formula for current date calculations

    It does not show me the balance of the current month. Only shows data starting from 12/1 onwards. Thanks
  12. nb4884

    Formula for current date calculations

    Thanks LB, but the formula does not pick the data for the remaining month of Nov. (Like in the 1st formula it ends calculating for Nov- averaged on remaining days) It does not average on Nov i.e starting from currentdate. It starts calculating only from 12/01 onwards. Although it works on the...
  13. nb4884

    Formula for current date calculations

    Thanks LB, The formula appears to be the same as one above (15 Nov 11 17:00) I am getting ) missing error. Added a ) but then got an error as "not too many ..." Pls suggest
  14. nb4884

    Formula for current date calculations

    Thanks LB , I get the same error ) is missing. And when I added ) i got an error"Too many Arguements..." highlighting "dateserial(date(year(currentdate), month(currentdate)+1,1)-1" Please note that this reverse formula for calculating from todays date to 6/30 or 07/01 is for a different date...
  15. nb4884

    Formula for current date calculations

    Thanks LB, that formula works. Can you also suggest one more formula, I could have opened another thread but it is a similar one.pretty please? Second scenario is calculate monthly usage starting from cuuenrdate upto before 07/01(0r 06/30 but the dates I have are starting from 01 of every...
  16. nb4884

    Formula for current date calculations

    So instead of 2012...cant I write something like year(currentdate)+1. Adding parameter is something not in scope of the report design reqt. Thanks
  17. nb4884

    Formula for current date calculations

    Thanks LB, and next year will I have to mamually update the year to2013? Is there a way to make the formula general for all Years. Many Thanks!
  18. nb4884

    multiple values in one row

    Thanks LB, the formulae worked. I created a sub report and works great
  19. nb4884

    Formula for current date calculations

    LB, the formula doesnot show any error. My FY logic got changed, can i use same formula if I were to calculate usage from 07/01 - 06/31 ? Thanks

Part and Inventory Search

Back
Top