Search results for query: *

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

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

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

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

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

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

Hi all, Any way to print all the code in a report? Or do I have to go into each formula, cut and paste, and then print that. Haven't found a way to print the code at all, but then again, I'm a brand-newbie at this. Thanks. -= Hypermommy =-

Can anyone tell me how to comment the report as a whole? I can see how you comment particular formulas, but I'd like to put a comment for the report as a whole discussing the general logic of the report, the business reasons for it, etc. Any way to do that? Thanks! -= Hypermommy =-

Hi all... I'm new to charting in Crystal and have a question I hope you can help me with. When I insert a chart using the Chart Expert not all of my formula fields show up as available fields under the "Advanced Layout" option. Why would some formula fields show up and others not...

Hi all, I'm hoping you can help me out. It's been a while since I've worked with CE (a few months at least). I've been tasked with providing a webpage that can allow outside entities (companies, general public, etc) to access our Crystal Reports. First, how do I put the report in the...

Hi all, Our SysAdmin is getting a problem on the production box when trying to set a CE user up to use NT Authentication. It works in Beta but not in Production. I'm trying to find some avenues of exploration that may lead us to an answer. The error messge we're getting is: "Error...

Hi all, Our SysAdmin is getting a problem on the production box when trying to set a CE user up to use NT Authentication. It works in Beta but not in Production. I'm trying to find some avenues of exploration that may lead us to an answer. The error messge we're getting is: "Error...

Hi all, I want to use an ado Recordset against CI_InfoObjects so I can then manipulate the recordset. However, I don't know what to use as my connection object if I do this. Anyone got some sample code I could look at? -= Hypermommy =-

Hi all, We have a report that did work in Crystal 8.5 but is now not working in 9.0. It acts as if it's not reading the selection criteria correctly and/or not processing the formula correctly. I think it's the formula because when I put a text field in the database to show the @RegionBundle...