Search results for query: *

I haven't writtne an array display in about 5 years, but need to now. I am getting an error on the counter in the declare formula and in the populate formula for the counter_myfield: Declare formula: Whileprintingrecords; global stringvar array my_array; global numbervar counter_myfield:=0...

I need to have an accounting period, which controls the grouping(s) rotate. Here is the example: Period 01 - Period 12 should be shown first in the report Period 02 - Period 01 Period 03 - Period 02 Period 04 - Period 03 Period 05 - Period 04, etc. so if the Posting date is in May, then April...

I need to fake count pages, but only its in a group. The page footer and header are not being used because they need a cover page and then a blank last page, so I have the report making a new page before the first group and after the group of information for that same group. That works...

I have an array set up to gather 2 sets of variables to fill and x and a y array. I don't have the detail section quite down, it is asking for a then on the if statement in XI R2. Thought you could leave it without a then piece to the statement. I am horrible at loops, how do I do this? Reset...

Can someone explain better than the help section, how XIRR is used? If you have these figures with these dates: Group ABC: -10000 1/4/06 -10000 2/4/06 10000 1/5/05 30000 12/5/04 XIRR(values, dates) The report is grouped and the data above is an example of...

I found something on a SQL board about using a case statement in the where clause and haven't gotten it to work yet. Need: a data field that can have one choice, a range of choices or no choices. Control group is the field and it looks like: Control Group Start ______ Control...

I have a field that if it is null then I need to look at antoher field and get the result here, BUT - I have a parameter that needs to feed off of this exchange. Table A = Contract Table B = Activity Table C = Business Units If isnull(contract.account_unit) then (Activity.Account_unit) else...

Hi I need to name this case statement as a field in a query: SELECT CASE WHEN ACMNTHDR.DFLT_ACCT_UNIT = ' ' THEN ACACTIVITY.ACCT_UNIT ELSE ACMNTHDR.DFLT_ACCT_UNIT END FROM ACMNTHDR INNER JOIN LAW9.ACACTIVITY ON ACMNTHDR.REV_ACTIVITY = ACACTIVITY.ACTIVITY When...

Hi I have this code, and generally the min function works, but it is not picking up the minimum date as requested. Can someone help. The from clause and where clause do not matter. And there is a group clause, which should not matter right now. This is the piece that is not working. I have...

Hey I haven't run into this in years, but CR XI is not showing the tables I have access to in the database expert. I know I have access because I can write a SQL Command and get the data back for the report. But I need to see the tables. Anyone run into this? Thanks so much! satinsilhouette

SSRS is querying Oracle. I am trying to switch a format of MM/DD/YYYY to YYYY/MM/DD. I can't seem to get any of the functions to take a syntax change. How is everyone changing the date format coming out of Oracle? Right now the format is set to D. Thanks so much! satinsilhouette

How do I get the dataset floating box back. It disappeared and I can't see. Could see it in full screen mode, but now that is gone too. Thanks! Thanks so much! satinsilhouette

Hi, I am correctly displaying a multivalue parameter in the header of a report, but now would like to display 'All' if the user selects 'All' in the parameter. So Book Numbers (you select one or more or "all": __ALL __1 __2 __3 __4 __5 __6 __7 __8 If: X_All __1 __2 __3 __4 __5 __6 __7 __8...

Hi, I am correctly displaying a multivalue parameter in the header of a report, but now would like to display 'All' if the user selects 'All' in the parameter. So Book Numbers (you select one or more or "all": __ALL __1 __2 __3 __4 __5 __6 __7 __8 If: X_All __1 __2 __3 __4 __5 __6 __7 __8...

Hi, I need to display a multi value integer (not string) parameter in SRSS 2005 Header. I can't seem to find any snippets of code for an interation loop or anything else. Has someone done this yet? Ex: AU 1 2 3 4 5 6 User chooses 3,4,5. They want to see 3,4,5 displayed in header. Thanks...

I need to find 20 random records out of thousands. In excel this is easy. How do I do it in Crystal 11? Thanks! Thanks so much! satinsilhouette

Hi, Need a little help. Usually my 'All' parameters works fine, but I need to be able to pick multiple selections, or just the all. So here is what I have, I have the allow multiples off for right now, but need to turn it back on. ( If {?Status} <> "ALL" then {Table.Status} = {?Status} else...

HI, I have several derived tables in a universe that all use a begin and end date. But that is the only similarity. Right now, these derived tables come up into Crystal reports as separate subreports. I need for the users to have only one begin date and one end date to show up for a...

What I need: I need to be able to count this formula: if {@Bus Days Fwd to AU} < 2 then 1 So if it is < 2 then 1, should register as one record to be summarzied for the overall report and for a group. BUT - I don't see it to summarize. Nor do I see it to build a running total, or Manual RT...

Hi, I haven't written a subreport, with shared variables in over a year, but don't remember experiencing this issue before. I have 2 groups in the report- Employer and Category. I have set up the subreport the same way as I need to pick up particpants vs. eligibles. The main report is the...