Search results for query: *

I forgot. I couldn't enforce both. I received the following error. Cannot determine the queries necessary to get data for this report. Details: This query cannot be performed. The link order requires many to one query configuration which is not supported. Please rearrange the links.

My group stucture is the following: Employee Index Suppressed Employee Last Name Suppressed Request ID data appears here Request date Supprssed

I implemented your suggestion to add the command and then place the formula maximum({table.request date},{table.employeeID}) >= date(2005,1,1) in the group selection. It almost works. It leaves too much data behind. For example, Current Data There 4 employees but only two have request dates...

I got it sort properly but this formula maximum({table.request date},{table.employeeID}) >= date(2005,1,1)only suppresses records that contain 2005. I need to suppress the inventor and his or her requests if the year of all the requests doesn't contain 2005. NJ = 01/05/2001 Rey...

OMG so close! I originally placed by data in the group header of the state but I had to change it to the group header of request id. The reason for the move was because Crystal ignored the min date requirement and continued to display both states (NY and NJ). I needed to display the earliest...

This formula worked{Table.Requestdate} = minimum({Table.Requestdate},{tablerequestid }). Hooray. I have 2 other issues. I need to place the records in date order so I can place a counter for each record. In order to accomplish this I selected group sort expert then I selected the min request...

After reviewing my reportI realize my data isn't quite right to begin with. I need help correcting it. I need to get the earliest request date and the corresponding country listed in the request id. Right now I'm getting the earliest request date by not the corresponding country that goes with...

Ok now I see what's happening. Currently I'm getting every employee that has submitted a request less than or equal to 2005. See Peter in the below sample. She should be removed because she doesn't have a request in 2005. I need to include employees who have submitted a request in 2005 but I...

It didn't work. I have 4 groups on this report 1. Employee id 2. Employee name 3. Request # 4. Request date I placed all the data in the Request # group header. Also in the group header I have the running total. The running total is in date order.

I have a report where I list the employees and the number of requests they have submitted. What I need to do is just display the employees that have a request in 2005 plus their running totals. How can I filter that out? Current Results Earliest Name Request date...

I appreciate the advice. I was just trying to be thorough.

I don't see how I can have one report. I have a total of 14 subreports/columns counting the number of application based on very different criteria for each column. Snapshot The data for the first 4 columns stem from three tables and the remaining stem from completely different tables. My main...

I have one more question. I have 13 other subreports to link to this main report. Unforunately each report has a separate and unique criteria. Anyway, am I correct to say that I will have to create a separate formula for each subreport in the main report to display subtotals group totals etc...

Ohh!1 How stupid am I. I just fixed it. It works great. Once again thanks!!! Cheers R

Each of the region counts works beautifully but the final count ww is doubling. I placed this formula in the totals formula but now the report footer ww total is doubling the amount. Should I place this total formula in a separate formula. //{@totals} to be placed in the Group #2 (employee)...

The report I have works great it just I need to know how to combine sites information using the shared variable technique or may I should set up my report differently. I have a main report and a subreport. The main report contains the list of employees along with the sites they belong to. I...

Lbass thanks for your help. I'm just going to ignore the zeroes for now. The data is fine. Many thanks

1. The zeros appear in the state group.(VMIS_TABPRO.R_IDESTE}= state. 2.Yes that is correct.

OMG. ? ? ? It's nearly perfect except that at the very top of the report of have zeroes displaying. I'm not sure why it's there. I can't suppress because if I do all the state information disappears. I also placed a total on each group by selecting a group footer at random so in addition to the...

Thanks for the advice on formula writing. I'm not sure what am doing wrong now. The zeros are displayed for the SBUs that don't have data yet but it's not filtering 2005 data. It still displays all data from the database. When the parameter comes up it displays 2,005 (I guess 2005 was...