Search results for query: *

Thanks lbass. I think I was trying too many different scenarios and just totally missed adding the new formula into the selection. Everything was working for me except the "All Area Projects" selection so I added that and now it all works fine!! Whew.... step away from the computer :-)

{APDEFN.APTYPE} in ["PLANNING", "PLANNING 2"] and ( ( {?Planner}<>"ALL" and ( ( {?Planner}="NONE ASSIGNED" and ( isnull({APEMP.EMPID})or trim({APEMP.EMPID})="" ) ) or {APEMP.EMPID}={?Planner} ) ) or {?Planner}="ALL" ) and ( ( {?PlanArea}<>"ALL" and ( ( {?PlanArea}="NO PLAN AREA" and (...

Thank you lbass! You have done it again! This works. Now my only problem is the additional request I just got for this report. They want to ALSO be able to query on Plan Area. This is another table related to the Project table in a One:Many relationship. It is in the same situation as the...

Hi lbass. Yes, I have a left outer join from the project table to the employee table. OK I seemed to have gotten it to work when I select the NONE ASSIGNED parameter. But not when I select the "ALL" parameter, I only get the none assigned. I think I must have something wrong with my...

Hi all. Here is one I can't figure out. The facts: I have a table of projects with details about the projects. (Table name is PROJ) RELATED to that table, is another table that identifies the employee responsible for the project (EMPLTABLE.EMPID) The tables are related through the PROJID key...

Oh I think I got it. I removed the Sum({@nulldecision}, {table.applicationID)=0 from the group selection and built a parameter called Decisions. Then in the record selection I put: (if {?Decisions} = "No Decision" then {@nulldecision} = 0 else if {?Decisions} = "Has Decision" then...

That's great lbass and it works, but how can I make that a parameter? The user wants to be able to select a parameter to sometimes look at only those without the decision, and sometimes wants to look at those With the decision... and sometimes all of them.

Hi. My report lists a bunch of applications and each application should have one, or many, decisions. The user wants to be able to list the applications that do NOT have any decisions. What I was thinking of doing, was creating a running total of the decisions (therefore I get the ones...

sorry.. the spacing was all messed up in that message so attached is a bit better to see the fieldshttp://files.engineering.com/getfile.aspx?folder=268820f5-7837-4cee-ac95-356ca1f2d78a&file=Supress.xlsx

I have one table called TableA that has the following fields: UniqueID ParentID All are text fields I am creating a report that pulls in the same table twice into the database so that I can link as follows: TableA has a left outer join from UniqueID to TableA_1.ParentID The data could be like...

Hi; I have a report that uses a union query. The report displays a list of properties and indicates the vendors code. The properties are one table (Table1), the vendors are another one to many related table (Client). This works fine. However, if the property was consolidated or subdivided...

I don't see an "attachment" data type... I see a "hyperlink" data type....

Hi there! Thanks for replying!! I am using MS Access 2010.... and I am not aware of any "new" way of doing this.... can someone walk me though it? Thanks!

As far as I can tell, there is nothing else running...

thread702-289543 Hi there... I was following along the much loved thread indicated above and it was working fine for me but I ended up getting the same run-time error 2220 that "realflava" indicated on 12-Apr-04 6:25 Realflava seemed to have found what the issue was, but I can't seem to...

Another question related to Parameters.... Is there a way to have one parameter at the start up of a report, and then based on the selection to that parameter, bring up another parameter?? I am not using a subreport... but maybe that is the only way to do this?? Here is a bit of what I have...

Yeah, I would rather not have the selection done in the report.... isn't there just a wild card "*" that I can put into the selection???

Hi all...... I have been reading many many posts on this question, but I still can't get mine to work... it should be simple but I am trying many ways and not getting anywhere. I am using Crystal XI I created a paramater called {?BuildingName} and I want the user to ENTER text rather than...

Hi; I have created a report where I want to create a parameter that allows the user to select all records where a field is either not null... or null... I THINK I need to determine if the field is "empty".... so I am trying to create a selection using a parameter called Occ Class Entered? like...

Do I have to take all my fields out of the details sections (section a and b) and put them into two Groups?? Is that the idea?