Search results for query: *

I am having a problem with extra pages displaying within the main report when I export into Microsoft Word. I have two groups in the footer area that have the New Page after group function activated. I think since I have two groups that are using this feature it is causing extra pages within...

I am trying to do a compliance report that tells me how many people have entered less than 40 hours per week. But I have to calculate hours per period. So the grouping is,from the top, by employee, period, and hours. At the detail level I have hours for each day and I summarize the hours at...

Is there a way to link a date parameter used in a main report to a subreport? I want my subreport to collect data for the selected range in the main report. Is there a way to link the parameter in the main report to the subreport?

I am using subreports for the first time for one of my reports. What is happening is the subreport is running for only the last record. I have made a transactions report that displays information for each period. The Main report has to date parameters that allows me to select multiple...

I have a formla that returns a number as a value however I can not sum on the field because within the If/Then statement I have a text field comparison. Example of my code if(({SECURITY_PROFILE.FULLNAME}<>previous({SECURITY_PROFILE.FULLNAME})) and ({TW_V_TRNSTOT.TRANSTOTAL}<35)) then 1 The...

Does anyone know if it is possible to take the value within a subreport and put it within a formula within the master report. I have made a subreport that basically gets the total number of employees. But now I need that total to make a calculation within my main report. Is there a way to do...

I hope this is an easy one. I am making a custom parameter for my implementation team. I have one parameter that has 4 preset names such as 1_Name, 2_Name, 3_Name, and 4_Name. What I am doing is looking at the first position, which are the numbers and using them as identifiers for fields in...

Does anyone know if it is possible to call the parameter window from Front Page so that input from the user can be entered? After the information is entered the report would then create an HTML file which could then be displayed. I am able to call HTML files with ease. I just want to know if...

Hi, I want to do a simple conversion from a string format to a number format so I can do some caculations. I am using Crystal 8.5. Ok here is the problem. I have two fields that are of type string; however, they have number variables that I need to do a caculation on that are within the...

Is it bad programing technique to put a cross tab in the header area of a report. I say this because sometimes Crystal Reports will give a doctor watson error on our server if no data is returned. I was wondering if anyone has seen this problem and has a recommendation for where not to put...

I am using the decode function in a view. I want to know if it is possible to set a field length for the new field which I am putting values. Sample code: create view x as select x,x,x, to_char(decode(trans_ukey1, 'HOME', rate1, trans_ukey1)) department from x By default it looks like...

Hi, I created a view in my database and I used the decode function to get the information I needed based on a simple condition. However, I do not know how to convert one field to a string data type. I think Oracle by default gave the field a number data type. Numbers will be going into the...

In the detail section of my report I have a formula where I assign two variables. NumberVar x; NumberVar y; In the formula I return &quot;y&quot;. But I am unable to sum on that field. I noticed that happened when i made a basic formula that only had the number eight. I couldn't even sum on...

This is the first time I have used a Loop control function so I am guessing as to how it is suppose to work. Basically, I am taking a From and To parameter and trying to find out how many work days there are between the two dates; however, I need to filter out weekends. I figured I could do...

I am creating this view and I wanted to know if there is a way to create a special if/then statement within the select statement. Everything I need is in the same table. I need to select another field in the same table if one table is equal to home. EX. IF transactions=HOME then department...

I am using a Java based application and I want to call Crystal Reports using an API. What API is the best to use. It is a must that I am able to pass formulas and parameter values to the report before execution. Does Crystal have anything for this and if not is there a third party software...

I want to make a parameter that shows data based on permission tables I have. Based on permissions I want to populate my parameter field with data that is based on the user that is running the report. The permissions are composed of many tables and fields. Has anyone tried to do something...

I am having a dificult time converting a SQL 7.0 report to Oracle. The Oracle database has the same tables as the SQL database. I change the driver and then set the locations and the only visual problems in the query are that the table names are in lower case. Running this against the Oracle...

I have a table that I need to use that has no fields that can link to the rest of the tables I am using. I need to use this table for a validation check within one of my formulas. When I add but not link the table through the visual linking window it tells me that &quot;this method is not...

Does anyone know an easy way to convert a Microsoft SQL Report to an Oracle report with minimal lost of database fields. I had a SQL database and an Oracle database with the exact tables and everything. I made this complicated SQL report and now I want to convert it to Oralce with out having...