Search results for query: *

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}

Maybe with two subreports that pass data back to the main report with shared variables. One looking for transaction 1531 and one looking for transaction 1518.

Convoluted? I absolutely agree. There is probably a way to use the count table from Excel. That would get me around the dba not letting me create the count table. When I get time, I think I'll go back and try to redesign my label report.

Crystal is driven by the details of the report. You are going to need to give Crystal a dataset that has one record for each time you want to execute the label report. You could create a stored procedure to create the dataset. For each SOP10200, create a temp table record with an entry for each...

My house sits near the highway. My house is located near the highway. I would rephrase the sentence to remove 'sits'. 'Sits' does not seem to be an appropriate verb for 'house'. What do you think?

RodKnowlton: I'm in Oklahoma, too. I live and work in Tulsa. Where in Oklahoma are you?