Search results for query: *

I need to build a report that compares cost to revenue earned The simplified layout to explain the issue would be <GF1 - Speciality> <GF2 - case#> <detail>Item Cost <GF2> Total Item Cost,Revenue <GF1> Total Item Cost,Revenue i can easily get the crosstab to generate the total costs, but I...

I am really new (as in 1 day experience now) to using VMware but had an old windows 95 legacy system dumped in my lap that needed to be virtualized (vendor has not existed in 15 years) I created the VM and managed to get it online and seeing the CD drive of the host PC. The problem is I do not...

I am trying to make a report that will forcast all items that will be used on a given day. The items used are stored on 2 seperate tables in the database. Main and secondary (there is always a main but not always a secondary). I am trying to group on InvDesc and then I will list the details of...

I am wondering if there is a command to just give me the element number of an item in an array. I need to save space on the page, this report filters using a dynamic paramater so if 5 items are chosen in the parameter, I would like to be able to use the element# instead of the item that is...

a summary has been specified on a non recurring field" I am in the process of building a report that needs to pull data from the first case of that is in a certain time range (determined via parameter). originally I used the min function within a group selection critera and everything looked...

CR2008 Not really expecting a solution, but hoping someone has come across this before. As the title says, I cannot uncompress my details section. No error message or anything. I am assuming there is some kind of corruption on the the report, but so much work has been put into it now I dread...

CR2008 I have a report that needs to calculate the average of a variety of time fields. I've done the conversions to time->decimal value and properly created a weighted average crosstab (or seem to have). My problem is I was to convert the decimal value for the time averages back to the...

I am trying to export a report with a single formula that contains a very large string of data for each line. When I export to text, anything after about 210 characters is moved to the next line. At most there might be 300 characters on a line. Exporting to Excel and then copy/paste into...

I seem to have hit a wall resolving this what I thought to be an easy problem I need to build a report that will summarize certain procedures (main and sub)based off of patient req#. While a surgery will always have a main procedure they do not always have subs. Also a procedure can be a main...

I am in the process of updating reports to CR2008 from CR9. No problems with the report itself but when I copy it to the server andlaunch it from the system that will be using it I receive the error: Internet Explorer Script Error Line: 77 Char: 5 Error: '_calendarprevMonthLab' is undefined...

I am having issues displaying information, I am trying to create to formulas to list partipant and their times. To maximize the space on the page I want to break up into two seperate formulas that I can put side by side. i.e Arron, Bob 50 Banks, Bill 60 . . The arrays are...

GH1 - Day GH2 - Facility GH3 - Room GH4 - Time + display turnover time(*) D - Title Participant * Needs to be a formula based of off the next time the room is used. essentially I need to find the next time value (GH4) to use to determine the turnover time. The function will work if I place in...

I have a system that is being upgraded and I will need to upgrade all the existing reports. The vendor keeps stressing that I need to have Crystal Reports 12, I cannot find any reference to this version. I have the PO for CR 2008, before I spend a lot of money on new liscences I would like to...

I have a report that has a crosstab in RH1 that is a summary of all facilities. Then in GH1 is a crosstab that is specific to each Facility. My problem is that the crosstab in the report header can sometimes take more than one page, when it does so it will not apply the hage header until...

I am looking for a way to control the number of columns in a crosstab. There should always be 13 columns (based on fiscal periods). The fiscal period is contained in the record, the issue I had for example was if I produced a report for up to period 6, the cross tab would only contain those 6...

I am unable to use "keep group together" because of a bug in CR9 where if the group is larger than a page it will make page 1 blank. I use "Repeat Group Header on each Page" instead. I am running into a problem periodically where the GH will display at the bottom of the page without any...

I'm in the middle of developing a report that will have about 15 running totals I need a specific horizontal layour that I cannot accomplish with a crosstab. The RT's all reset after the lowest group. Is there a trick to get subtotals and a grand total of each RT or do I need to create new...

I am using CR9, which I have learned that there ia bug that when you try to use "keep group together" and there is more data that can fit on the first page it will begin it all on the second page (the Report/Page header still display on the first page). This was corrected in CR10...what I...

I have developed a report that is using 2 subreports (Detail section - Da and Db). I have no problems with the shared variable formulas, the values returned are all correct. I am trying to find a "trick" to suppress the group header if there is no information passed from either subreport. thanks.

I am having problems initializing my variable with CR7. I've had to create a report with MANY variables, a running total could not achieve what I needed. I have initialized them all to 0 with a formula in the report header. All is well until I relaunch the report (whether I close CR or not)...