Search results for query: *

Hi there, Thanks all for the help. I will find out if Crystal (developer) is installed on that box and try to run it with that and see what I get. There is no record selection formula. The SP handles all record selection and Crystal just spits out what's produced. When I try the report on...

I'm not sure I understand. No code in ePortfolio and no code in my report other than the asking the user for the parameter. Maybe the stored procedure needs to be posted? But I don't think that would be the problem since it works everywhere else?? I'm so confused. So should I post the...

Hi all, I am having a problem I hope you can help me with. I'm using CE9.0. I have this one report that takes a performance type as a parameter (among others). The report runs fine in ePortfolio for all performance types except IC. But the odd thing is that the IC performance type runs fine...

No, I never really received anything. Wish i could help but I don't really understand it myself. -= Hypermommy =-

Thank you so much for your help! This was driving me crazy. Well, it turned out there was a problem with the permissions in the database. When I worked on my desktop everything worked fine because I am a trusted user of the database. However, when I moved over to ePortfolio and it was...

I have a report that uses a stored procedure in a SQL Server database as it's data source. The report was developed in CR9.0. Our CE version is 9.something. I went into the CMC and added the report. I had some problems with logging on to the databse, but those went away when I duplicated the...

Using CR9.0 I have a need to grab a total from a subreport and show it on the main report. Is there a way I can do this? Thanks. -= Hypermommy =-

I need to count how many distinct permitholders show up in a report. I have a group based on permitholder. How can I count the number of times I see the group header? Thanks. -= Hypermommy =-

Hi all, I'm using Crystal Reports 9. I have a parameter {?Type} into which users can select multiple values. I *think* Crystal views this as an array once they select their types (right?). I would like to list all types selected at the bottom of the report. I'm guessing I need to include a...

Darn.... every time I think I've posted everything I leave something off :-). I am using Crystal 9 and a SQL Server database. Please (when you get a moment) let me know how to do this, both how to access the results of a Stored Procedure (never did that before) and how to do it using only...

Hi there all, Our DBA has given me the SQL statement to get the admissions tax credit but I'm unsure what (if anything) I can do with it in Crystal. I need to make a formula of it so I can show the resulting number on the report but am at a complete loss as to how to do so. The SQL...

Hi all, I'm using Crystal 9. I have a report that has a parameter for the user to select called ?DataToShow. The possible values are: Type Only Division Only Type and Division I've got various groups set up. If they select type only, then I hide the division group. If they select division...

Hi all, Want to do something here but am unsure how to do it. I've got a relatively simple report that has a single detail line and two groups. What I'd like to do is conditionally color the background of the outermost of the groups but only when the user has not collapsed the view down to...

Using external code to do parameter collection... you mean like have a web page or a client server app... grab the parameters using that and then pass them to Crystal Reports? -= Hypermommy =-

I need to populate a parameter list dynamically in CR9 and can't seem to find how to do that? Help? Thanks. -= Hypermommy =-

Okay, so let's say I make a variable called EmployeeName in one of my formulas. Now, if I were to want to print the value of that variable on the report, I'd have to make another formula called @EmployeeName just to print the variable value? Is there any other way to do it? I'm trying to...

Basically, I've been handed a report that is: 0-6 days 7-30 days 30+ days DDD BBB DDD BBB DDD BBB Type 1 5 2 2 4 6 8 Type 2 2 6 2 5 7 9 Where the help desk tickets that...

Can I use two-dimensional arrays in Crystal formulas using Crystal Syntax (can't really re-write the report right now and the previous developer used that instead of Visual Basic so it's time for me to learn it)? How do I declare the array? How do I redimension it as it needs to grow? Thanks...

Thanks! I was just getting back online to say I'd figured out how to do it. I may even learn to actually like this tool :-) -= Hypermommy =-

Hi all... I've inherited a tricky little report and am trying to simplify the formula so I can comprehend the report. Several times in this one formula I've noticed code like: if (assigned_to = "group 1" or assigned_to = "group 2") then do something. Of course, in the...