Search results for query: *

K The cast formula worked great in Crystal to. Thanks for all the assistance.

I am trying to create a formula in Crystal Reports from a smalldate field from a sql server database. Can someone tell me if its possible and what the formula would look like. Is there a way in Crystal 10 that I could use SQL Expression fields to accomplish this. I am new to Crystal 10 so any...

Thanks to all - I used: shared numbervar SubNum:=SubNum+((?Pm-Sum of @Dozens}*{IXOPTN00.OPSLTM}) Now in the main report AFTER the subreport has run, you can use that variable, as in: shared numbervar SubNum; ======= I was using a shared var but trying to create another subreport for the...

Greetings, I have researched as much as possible for a solution to my dilema and do not see anything relative so I am posting for the pros.... I am trying to calculate grand totals from a sub report. I have a report with a subreport retreiving data from a different data source: Main Report =...

I have created a report in Crystal 8.5 with parameters and have several combinations for the parameters. I need to use the null or blank field in some of the parameter choices. I can choose this as a parameter for reportingby selecting the "" in the choices but when published on the...

I agree that is probably what is happening but is there any way around it to create the report? Is it possible to use a subreport and create a statement excluding everything that matches? If so how would it be written and executed? Thanks for you advice. B

I have been partially successful creating a subreport. However, I need to only see the exceptions from what is in one datasource and not in another and vice versa for auditing purposes. When I try to accomplish this select statement I cannot see the primary source as an option for the select...

I am trying to create an exception report that will return records from 1 data source that are not in the second data source such as case numbers. I am trying to link 2 string fields 20 characters long. I am getting the message" The specified fields may not link successfully due to...

OK I understand that but I have used that field as a datetime field. Now I am getting error message that a date time is required at the end of my statement.I know it must be something simple I am missing but I must not see the forest for the trees!!! Help {?Status} = {?Status} and {@App Status}...

Please explain the following field({AMAPPN00.FIELD}) I am not understanding the reason for it and what it should contain. Thanks for being so patient.

This works great if I use it within ths same date and bypass time but if I have an instance to report from 1730 of one date til 1729 of the next day I get no data returned. Here is my statement: {?Status} = {?Status} and {@App Status} and {AMAPPN00.AMAPDT}>={? startDate} and...

Thanks for the response. Now let me explain.... I have a numeric date field and a numeric time field in AS400. I want to construct a parameter(s) that will return a report based on date and time. Since I am reporting with shifts, the enduser will need the ability to use a parameter such as...

I have a report in Crystal 8.5 and I am trying to input parameters to include from 1 date and time to another date and time. The date and time fields are numeric(AS400) and seperate fields. I want Crystal to include records between these date and time fields. There may be an issue where the...

If the strTime is less than 1:00AM it shows 23(for 23 seconds after midnight . Also is could be blank if the process has not been completed yet but I expect the isnull takes care of that. Thanks for the response.

Hi, I am using Crystal 8.5 and an AS400 database and need to combine 2 numeric fields to create a date/time field. Can anyone tell me if I need to create seperate text fields first and then how to complete? Thanks

I am in urgent need of assistance. I have a formula in Crystal that will convert a numeric field to a time field. The problem is if the numeric field is less than 1:00 AM I get an error message "String Length is Less than 0 or not an integer. The formula is below: Any help would be greatly...

Hi, I am trying to create a date/time field in 8.5 from joining 2 fields together that are numeric fields.Must I change these fields to text fields before I can convert them to date/time? Thanks

I am in urgent need of assistance. I have a formula in Crystal that will convert a numeric field to a time field. The problem is if the numeric field is less than 1:00 AM I get an error message "String Length is Less than 0 or not an integer. The formula is below: Any help would be greatly...