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!

Recent content by mynameant

  1. mynameant

    Conditional Suppressing a column based on CECURRENTUSERNAME

    That is perfect. I was thinking I have to say IF x="y" then true else false. But that's not needed. It's working as expected now. Thanks :-)
  2. mynameant

    Option to show detail

    Can you show summary when the users run the report and then let them click on a button to see Details? This can be done using a sub-report for Details. 1) create a sub report 2) place it any where [on summary section] as a small Hyperlink 3) link parameters from Main to summary report
  3. mynameant

    Conditional Suppressing a column based on CECURRENTUSERNAME

    Is it possible to suppress a column value based on the user who logged in? I am using CR XI rel 2 and trying to use the following IF Statement in conditional suppress formula: if CECURRENTUSERNAME="xxx" then true else false; but Crystal doesn't like it. it rejects the usage of...
  4. mynameant

    Pass a Multi-Value Parameter to Stored Procedure

    Hi all, I am using CRXI and have a report based on an Oracle based Stored procedure. I need to make the parameter on this report as multi- value parameter which I cannot directly. So, I am doing something like this using a sub-report. Main Report: =============== Empty report with a...
  5. mynameant

    Query to get security information from BEXI

    To Turkbear:- Yes, that's what I need. Can you provide a script for it? I can build a script if I know what objects I need to look at it. If you know what objects I should query, that'll help too. To, patBIK:- I think you gave a URL from your server :-) But, my problem lies with Query builder...
  6. mynameant

    Query to get security information from BEXI

    Hi All, We are using BEXI Release 2 and are in need of finding what report is being access by what group[s] or users. Is there any way to build a query and fetch from BEXI Database? If so, does any one has a query available. I am incharge of generating this report and definitley do not want to...
  7. mynameant

    Alternate Shading of Rows in Group

    Ummm.. that would be a bunch of groups I need to be creating [a lot]. I'll just draw empty boxes around each line and fill it with different BGColors. But, thanks for all the help.
  8. mynameant

    Alternate Shading of Rows in Group

    I could put a box around all those objects and fill with color. Should have tried before putting the question. Thanks for your help though. If you have a different soluiton that would be great.
  9. mynameant

    Alternate Shading of Rows in Group

    That's what I am trying to avoid :-) But if there is no other way , then that's what I have to do. So, how do I color the objects for each line? I mean there are four - five fields placed for each text object in each line. So, should I just select all then pick a color? ifso, how does it put...
  10. mynameant

    Alternate Shading of Rows in Group

    Actually, there is one Group. In that I have put some text objects Name1: Name2: Name3: and some of my computations are group level and I put them for each Name. So, for those lines [My details are suppressed for this report], I need to alter the background just to make them...
  11. mynameant

    Alternate Shading of Rows in Group

    When I do that, it's putting crWhite [or whichever color] on the entire group. It's not changing based on lines inside the group header.
  12. mynameant

    Alternate Shading of Rows in Group

    Thanks for your response. I have only one Group in my report, G1.
  13. mynameant

    Alternate Shading of Rows in Group

    Hi all, I am using CR XI Release 2 and have a report [summarized to Group] that I need to shade it grey or white alternatively. Unforutnately I do not want this on Details but it's on group level itself. Let me explain: I have grouped all the rows I am getting from my query and summarized like...
  14. mynameant

    Assigning Varaible to a Parameter???

    Thanks for the response, but I think I should explain in detail about my requirement. User selects muliple parameters for a report. I need to pass these parameters to Oracle stored procedure and bring related information. But ,unfortunately, Multiple parameter in crystal is a string array and...
  15. mynameant

    How to capture special field values in XI?

    I am trying to assign current user to my Parameter like this: {?MyParameter}=ceCurrentUser it fails on "a number , currency , boolean, string is expected here" error. Same if I do with a {databasetable.columnName}=ceCurrentUser. I also tried the way you are doing: If ceCurrentUser='USER1'...

Part and Inventory Search

Back
Top