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

  • Users: rb2005
  • Order by date
  1. rb2005

    supress if duplicated

    hi, I am having problem with "supress if duplicated" this features of Crystal report. I am using Oracle 9i & CR 10. It's working for one report but it's not working for other. I have used this in past several time. Even I am checking this it's still showing save value in all line. I have tried...
  2. rb2005

    Enterprise Logon problem

    http://support.businessobjects.com/library/kbase/articles/c2016250.asp read this
  3. rb2005

    Connecting Crystal to Stored Procedure

    Are you showing parameter in the report? For displaying without time you can format that field.
  4. rb2005

    Connecting Crystal to Stored Procedure

    Let me know which Database you are using? What is the data type of date parameter in you stored proc.
  5. rb2005

    Failed to Open the Connection

    When ever you publish a Crystal report into Crystal enterprise you have to set the database. If you are in console management please click process and click database and set the database. I don't have CE right now else I can explain in details.
  6. rb2005

    Data level security

    You have to create business view. In business view data foundation/element section you have to create filter.Then you have to set rights to the filter.
  7. rb2005

    Cleaning up instances

    You can keep that instance for only one day. So next day you can not see the instance. There is a option which says how many days you want to keep that instance? you may try zero.
  8. rb2005

    command

    I have created command in CR10. Can I change the command name? By default it say command.
  9. rb2005

    issue with displaying data

    If sum(col2) is zero can I display like "+". This is working fine seperately. I have a formula like if sum(co1,groupname)=0 then "+" else totext(sum(col2,groupname)) But when I am using display formula it is printing zero. Any clue? If I change the datatype of the sumcol2 from number to string...
  10. rb2005

    issue with displaying data

    do I need detail section formula?
  11. rb2005

    issue with displaying data

    do I need to supress the group footer?
  12. rb2005

    issue with displaying data

    is this possible if I want to display everything in report footer. I was trying to display in report footer. If I use group fotter then it's creating seperate group for each line. But the requirement is when ever one group ends the next group will start in the same line. Like...
  13. rb2005

    issue with displaying data

    can I concatenate detail data with summary data. let say the data look like group 1 col1 col2 col3 A 5 7 B 8 15 C 8 9 Group1 total 21 31 group 2 col1 col2 col3 A 5 7 B 8 15 C 8 9 Group2 total 21 31 Can I display like...
  14. rb2005

    display data in special format

    I am getting the data but group total is printing after each line, but I need that only after end of a group
  15. rb2005

    display data in special format

    can I concatenate detail data with summary data. let say the data look like group 1 col1 col2 col3 A 5 7 B 8 15 C 8 9 Group1 total 21 31 group 2 col1 col2 col3 A 5 7 B 8 15 C 8 9 Group2 total 21 31 Can I display like...
  16. rb2005

    number to string

    I have a field which is number data type. Let say the field name is Amount, value is 1,200.00. I want to convert it into string so that the value will display like 1200. I am using totext to convert it. But I am not sure how to remove the "," which is nothing but thousnad eparator. In oracle 9i...
  17. rb2005

    Insert row into Crystal report

    I can not explain my requirement. Sorry. But I guess we have found a solution.
  18. rb2005

    display data in special format

    I have solved it.. I have put database version and CR version first time.
  19. rb2005

    display data in special format

    everything is not table field. to get this value I have few formulas. do u think it will work? first I have a static number which will concatenate the report header then the data. most of the cases column will concatenate each other with few ++++ so it will look like 1234myreport /23/2005...
  20. rb2005

    display data in special format

    I have a report which is displaying data like this. 12345myreport 3/23/06 abcd12340o87 njioer1245678 njkio190734 wert09876456 oilsir1234890 asnjoih12456789 bbcd12340o87 jjioer1245678 jjioer1245678 iert09876456 lilsir1234890 psnjoih12456789 Can I display data like...

Part and Inventory Search

Back
Top