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...
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'...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.