Search results for query: *

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

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

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...

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...

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...

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...

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.

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.

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...

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...

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.

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

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...

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...

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'...

lbass, I could not link the field to a parameter in sub report. I could only link param to param, but i'll check again. Regarding the second option I could not do that. let me explain: I have main report to accept multiple parameter values from user. so, it's going to be an array of values...

Thanks Turkbear, I'll give it a try. Hopefully it works. Thanks for your help.

Is it possible to assign a variable value to go to parameter in CRXI? I am passing a shared value from main report to sub report and my sub report has a parameter which should accept this shared variable value as the parameter value. is it possible? Thanks

Sorry, couldn't check your reply immediately. Just got a chance to check it. I thought I could create a variable to hold the CEuser name. But when I am in formula editor to capture this, there is no way I can get CEUsername in formual editor to say something like: myvariable:=CEUsername; any...

Does anyone know how can I capture special fields and pass them onto a formula or to a database? Eg: I want to capture users who log into BEXI [special field-> CEUsername] and using their username, I want to retreive some values from database? Any ideas? Thanks