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 wOOdy-Soft 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: *

  • Users: HPNAGA
  • Content: Threads
  • Order by date
  1. HPNAGA

    Number Parameter changing values from Main report to sub report

    HI All, I am using Crystal Reports XI version. Database : DB2 I have an CASEID field in DB2 which is of type BIGINT I have a report which shows the summary of a region related CASEIDs however I have a dynamic report which has CaseName as subreport caption. I am passing the caseid as...
  2. HPNAGA

    parameter need to year instead of Date

    I am not sure if I am doing it in the right forum. i am using Business Objects Designer V 11.5.0.0. I have created a derived table which has prompts user to select a year like this select * from ABC where YEAR (ABCDate) = YEAR[highlight #FCE94F](@Prompt('Select...
  3. HPNAGA

    Date function problem

    Table : "TableXYZ" Column : "ColumnA" User provides a value which is stored in variable "UserYear" Needed Query : Select all fields from TableXYZ where year of columnA = UserYear Query I came up with : select * from TableXYZ where year(columnA) = UserYear. Query my boss want : He wants a...
  4. HPNAGA

    Subreport Shared Var not updating in Main Report

    Hi I am using Business Objects XI. I will try to trim down the issue so that it makes sense. I have a Group Footer in that I have two sections In Section A I have a Shared Var CaseCount In Section B I have a subreport which will give the Shared Var CaseCount = 25. How can i get the...
  5. HPNAGA

    Excel 2010 Conditional formula

    Hi I am not that good with excel so please bare with me ..I am using excel version 2010. I have data like this Column A Column B column C Abc.......abc.....abc ccc.......ccc.....ccc bab.......bab.....bab aaa.......aaa.....aaa ccc.......aa......ccc ccc.......cc......cc and i want...
  6. HPNAGA

    Formula value to change

    Hi I am using Business objects XI. I want to know if there is a way to change the value of a formula based on the section it is.. Lest say i have a group footer and i have two sections Sec A and SEC B. In Sec A the value should be 1 in Sec B the value should be 2 please let me know if you...

Part and Inventory Search

Back
Top