Recent content by MColeman

In this case, couldn't the subreport be linked to the main report using a field value in the main report? The subreport is in the list data region of a main report. In the subreport properties, parameters tab, use a parameter to associate the subreport with the main report list data region by...

Isn't there a KeepTogether property of the table? ...on the custom properties dialog box, general tab

We had a similar problem that we could not solve in Crystal Reports. We ended up using a sql stored procedure to regroup the data using a temp table. In a sql temp table, you could put the tasks that will print on a line together into a row. Task1 would go in the first field, task2 into the...

sure have... allow additions and allow edits both set to yes on the main form and the subform also tried changing from dynaset to dynaset - inconsistent updates and checked the version of Jet and MDAC and looked for possible updates that needed to be applied and made sure the table has a...

I'm working on a problem in an Access2003 database. A subform is bound to a simple query (no joins or unions) that reads from a table linked to an SQL2000 database table. The new record button of the navigational control is greyed out. The query works outside the form and I can add a new...

Parameters that have multiple values can be displayed in the header with: Join({?mystringparameter}, ', ') The result would print like value1, value2, value3, etc. I tried this on a number parameter and got an error message that said a string was required. Below is a solution I worked out...

Thanks, that really cleared this up for me!

I'm learning Visual Source Safe, and I'm a little confused about it works. I've read that: When you check out a file, a copy is created in your working directory where the development work is done. When you check in a file, VSS maintains your source code directory. This source code directory...

Does anyone know if there is a way to tell when a stored procedure last ran?

have default values for the parameters like zero: if (parameter2 <> 0 and (constitunent = "P" or constituent = "I") and lookup = 2) then true else if (parameter1 <> 0 and (constitunent = "C" or constituent = "A") and lookup = 1) then true else false

put it together with the rest of the record selection depending on how you want it to fit in if ({S_CUST_SURVEY.LAST_UPD} = {?WhatDates}) and ({?WhatSites} = "ALL" or ({?WhatSites} <> "ALL" and {S_CONTACT.SOC_SECURITY_NUM}= {?WhatSites})) and (trim({S_CONTACT.LAST_NAME}) & ', ' &...

{productcode} like '*L'

Maybe the mm is NULL or empty.

You can't set the default values for the other parameters based on one parameter, unless you're using VB to get the parameters. But you could setup some special record selection logic to ignore what is put into the other parameters.

if trim({S_CONTACT.LAST_NAME}) & ', ' & trim({S_CONTACT.FST_NAME) = {?nameparameter}