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 Mike Lewis 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. rreddy01

    parameter issue in crystal reports 2008

    I have a crystal report 2008 built out of stored procedure(Procedure is using SQL server 2008 database). there is a datetime parameter in stored procedure.when it is coming to crystal reports it is showing as datetime but when i change the parameter type to dynamic the paramter datetype is...
  2. rreddy01

    Open document issue

    I need to build a report in such a way that it should take the parameters from URL.. I have createad the URL but i need to know where i have to code in the report and what code i have to use so that the parameters will be inputed to the report. Any suggestions... Thanks, rreddy01
  3. rreddy01

    optional parameter issue

    Thanks for your reply and that worked for me.
  4. rreddy01

    optional parameter issue

    I am trying to create an optional parameter in crystal reports 2008. There is a parameter field called Name which is given as optional.. if they dont enter anyvalue in the parameter it should pick up ALL values..I have defaulted the parameter to 'ALL' in parameter list but when they want to...
  5. rreddy01

    passing all values from main report to subreport

    I have a mainreport which has ID,contractID(15 characters- A10000-00-000-0),date.. Mainreport has group by on ID.. for ex: there is a contractID: A11111-00-010-00 is under ID 01 for tthe date may2012. but there may be same contractId just with slight difference in number under jan2012 and...
  6. rreddy01

    Avoiding duplicates

    Disregard this post..
  7. rreddy01

    Avoiding duplicates

    i am trying to get all the codevalues separated by commas in a variable x but while doing this getting some duplicates or some values are missing. WhilePrintingRecords; stringVar x; if length(x) = 0 then x := x + {CODEVALUE.DESCR} // else // x := x + ", "...
  8. rreddy01

    Formatting of Groups

    This worked.thanks everyone for the help.
  9. rreddy01

    Formatting of Groups

    Thanks for your reponse! yes, i was doing the exact same thing but the next section is getting continued on the same page(group section #3e) but now i want the group section #3f too to continue on the same page because there is plenty of space in the page
  10. rreddy01

    Formatting of Groups

    I have a report in which i have group footer #3d and #3e. there is a formula written in group footer #3d to supress some text object if it is a state project,if it federal then i am not suppressing anything. whenever it is state project there is a free space coming up. Instead of free space...
  11. rreddy01

    Group sort

    I have a report which is grouped by manager name, i dont want that to group in alphabetical order instead i want to start with letter B. Thanks, rreddy
  12. rreddy01

    SQL Expression

    Can i use this below Query and write a SQL expression or atleast create any formula.. i have never used SQL like this in my reports. SELECT WEBTRNSP.PROPOSAL.PROPOSAL_ID, WEBTRNSP.PROPOSAL.PROPOSAL_NM, LISTAGG(WEBTRNSP.PROJECT.FEDPROJECTNUM, ' & ') WITHIN GROUP (ORDER BY...
  13. rreddy01

    looping in crystal reports

    Thanks for your reply @lbass.
  14. rreddy01

    looping in crystal reports

    Thanks for your reply. i have created a variable called federalcountyname, trying to get all the county names in that variable separated by commas.but when i do that i am getting duplicates. the output should be A,B,C,D but instead of this i am getting A,B,C,A,A..etc Thanks, rreddy
  15. rreddy01

    looping in crystal reports

    I have this below formula in my main report. this formula is getting all the county names into a variable called federalcountyname but the thing is the county names are repeating, means they are getting duplicated. For Ex: they are counties called A,B,C,D ETC. WHEN I USE THIS FORMULA I AM...

Part and Inventory Search

Back
Top