Search results

Didn't mean to rant of chew off any heads I really don't bite...well not until i know you better :D :)

Defeats the purpose of the forums

Try a Subreport The main report would be the Company and in the subreport you would list the Interviews for each company and sort them however you want.

Thank you everyone I'd like to thank everyone for all of their help i fixed this by abanding my original design and totaly redoing the report and the query it came form. With that design there are no subreports to foul things up and with a Simple IIf check box to designate history i have...

Ok how is this done Ok i undestand the principle but am unable to figure out where to impliment it. If you let me know for one subreport i may be able to reorgize things to get most of what i need.

well that should not be a problem Well all of the data in the two subreports comes from the same table. so the join should fix both. What join do i need to change and where. I don't think you want the main relationship changed. So do i just change it in the top portion of the design query grid?

thats exactly what i want thats what i want now how do it?

One Last Time before defeat Ok this is the last gasp of a HasData hasbeen. My main report Named "Department by Range" has the fields: Department, Lastname, Firstname, Senioritydate, vacationelegibility Subreport1 Named "Time off History(Date Range)" Lastname(nonvisible)...

I know that has Data has been done to death but i need a little help with it. I feed a Report with a form that picks the dates a Between in each of two subreport's I need the report to only print the people with data in that range. It is currently showing all of the people with blank...

Fixed

Problem Narrowed The problem is occuring with everyone who has more that one type of Absence. It displays them as many times as they have items. It some one has both LOA Approved and Vacation Approved it will list them twice if the have LOA App,Vacation App and Vacation Denied it will show 3...

I wish it was that easy First thing I checked. I thinks the problem is with the fact that the person in question has a LOA approved in History and Vacation Approveds in current so the main reports notes 2 sets of data and displays both nor relizing it's the same data. I'm grasping at straws...

no this is a stupid question Ok i get that. so if the sub report has data then it will be visable and if not it won't show. Where in the report does this go, or does it go in the Query? And the second stupid question..... Me = Queryname or Reportname?

I have report with two subreports. The report is for tracking time off the Type of Time off is Value list "Vacation Approved, Vacation Denied, LOA Approved, LOA Denied, and LOW" my subreports count the History and the current and subtotal the information. One of the employees is being listed...

I can't wrap my head around HasData I must me deficient because I just cannot wrap my head around HasData. It just confuses me to no end. :(

Arrrgh..... The Has Data just confuses me :confused: I've done searches on it and i still don't understand it. But i'll try again.

I think i have to use IsNull but how? "(IsNull ( [Time Off Current].Report![Text12] ) ) or (IsNull( [Time Off History].Report![Text12] )" I think this will help me in the Main report but where to i put it and what else do i need to make it ignore and entries where the subreports return Null...

I have a main report with 2 sub reports. The report is set up as a date range in the Sub reports. somtimes there is no data in the range selected but the main report line still show. How can i get the report to not display the Main report lines if the subreports for that person are Null.

Thank you Thanks dcx I thought that might bethe case.

I don't know if this is possible. I would like to Put a List in my Querys criteria. The Current criteria is "Like [Department:]" is there a Way to have this call the Tables list of departments and make the Parameter entry box into a list with a drop down button? I might be out of my mind i...