Search results for query: *

I need to round a number a specific way, here's an example of the number, its in the Group Summary area. I am using CRXI: 25,187,680.50 should look like: 25187.7 I don't know how to get here, but I know it probably invovles a formula. Thanks, muffntuf

Hi, I have someone who called me about publishing a report with 2005 Visual studio .net. He wants to publish a series of reports in succession. For instance show rpt 1 for a minute, show rpt 2 for a minute, show rpt 3, etc. He's got CRXI R2, VS.net 2005. Has anyone done this? Thanks, muffntuf

hi, I am trying to get a command object to accept multiple values. Does anyone know how to do this. I suspect I am looking at an array. For example if I wanted a user to be able to enter a number of accountid's, how could I pass them to the command object? Crystal XI is the CR and AS/400...

Hi, I am using CR10. I have a main report that I need to grab subtotals out of subreport for. I got the Report Grand Total to come out of the subreport, but haven't been successful at bringing the subtotals up yet. The subreport is in the first group footer. This report has 7 groups with...

Okay awhile back I asked for help with Quarters and here is what was suggested below. When I group on this the only group I get back is QT1 even though the Tran_date is forced between '08/01/2005' and '08/31/2005'. I don't understand why it is not showing up as 'QT3'. Does anyone see anything...

Hi, I tried this before but need to try again. I need to have a report group on Quarters, but be able to run the report with either a selection on the Quarters group or by a date range -- BUT I need to pass the parameter back from the report selection criteria to the SQL COMMAND OBJECT which...

Does anyone know of a better way to write this sql statement? It seems that I need to exclude the and not like portion, but I don't think this is getting excluded from results. 'OTHERCONDIS' = CASE WHEN GLT_Dist.Acct_Nbr LIKE '01-4%' OR GLT_Dist.Acct_Nbr LIKE '02-4%' OR GLT_Dist.Acct_Nbr...

Hi, My brain is dead today, I need to do a simple quarterly formula you know: If datefield in January - March then "Quarter 1" etc. Except I need to be able to make this a rolling quarterly deal so if the report was run today or a year from now the formula would never have to be maintained...

Hi, got a question for yall- If I wanted to use CRXI to find the system values, how could I do that? Thanks, muffntuf

I still am not getting anything back. They want to be able to just take a partial part number like 151421 is the part number they just want to enter 15 and get all the records back that start with 15. k said - Make the parameter a range type, and set the default value to " " (a space). In...

k said - Make the parameter a range type, and set the default value to " " (a space). In the Report->Record Selection->Record place something like: if isnull({?part}) or trim(maximum({?Part})) = "" then {Customer.part} like "*"& minimum({?Part}) & "*" else if {?Part} = "2" then...

Hi, Using CR10 I need to able to select a part number, which is a string field, with a partial starting number or the whole number and they want to be able to put a range of values in the same parameter: Part Number 151127-00-000 151129-00-000 If somone just types in 15112 then I need all...

I need to test for one date being less than, = to or > another date: If datecreated <= needbydate then if the date is less than or equal to I need to get the difference of days as a percentage. So if something was created on the 1st of the month and was due by the 9th, but today is the 10th...

Hi, I have been helping develop several reports (in CR10)that have anywhere from one to 10 subreports (yes I know, yucko)in each. When we publish out to CE 10 they are requiring us to log in for each subreport. The subreports are linked subreports. I know I saw this a couple years ago, but...

Hi, I have been helping develop several reports (in CR10)that have anywhere from one to 10 subreports (yes I know, yucko)in each. When we publish out to CE 10 they are requiring us to log in for each subreport. The subreports are linked subreports. I know I saw this a couple years ago, but...

I know this is an easy one,but I can't remember for the life of me. I wrote a command line in CRXI to handle a union join. I had to put the date fields to text (string) in the sql code to prevent errors. I need to now convert them back to date fields in CRXI. I tried using cstr but got an...

does CR XI support a double or multiple case select statement? For example: Select year({hiredate}) case 1996: select {salary} case > 75000: {Salary} * 1.07 Thanks!

Hi, I have been working on a problem for a few days now--I am writing reports for a JD Edwards database. When I use just one or two tables/views performance is pretty snappy. But when I add more than that I get 5-10 records per 30 seconds. Has anyone worked with JD Edwards before and come...

Has anyone ever identified an object (table) with Crystal Reports for a parameter? I need to build a formula in a Biz View that identifies whether information is coming from one table or another, if it is then I need to label it with a letter that can be chosen in a parameter in the biz view...

Hi, I am looking for a custom function, I know its out there, I just can't find it-- Business Days that skip holidays to put in my library, anyone know where this is or have one they can share? Thanks, muffntuf