Recent content by JC442

An interesting wrinkle in this problem is that the table designer Used a Yes/No Format and combined it with a validation ="No" Or "Yes". Since Yes/No fields normally hold values of 0 or -1 this may be the problem. Because of the Validation rule / Format Combination True, or Yes, or "Yes' or 0...

Dear Wonderful Person Who Can Help, I have to populate an access table that has fields with Yes/No Format. If I want the value to be checked "Yes" what value should be used in the append data query. Using "Yes", 1, and -1 have not worked. Software is Access 2003. Thanks, JC

Robert D. Schmidt puts out a line of instruction books for BO Desktop and WEBI. I won one in a drawing the other day at the BONYMAUG. So far it has been very helpful.You can reach him at www.schmidtink.com. Best, JC

I am a new user of BO desktop 6.1 and I need some help understanding how to determine where the datasources for a unviverse are located. In Crystal I would look use Set Data source Location. Is there a similar function for BO? I'm working on the front end of a system that has dev, uat and prd...

Thanks to both of you. Actually the report required the data be grouped by ID and sumarized. Following your suggestions I used a combination of both a single text box to hold each row and formulas and formatting to get the final formatting to work. Crystal had an obsession about adding comma...

Im running CR 10 on CE10 and trying to produce a pipe delimited txt file. I do not want to have any quotes or additional spaces in the output. a sample row would be prog_id|Date(MM/DD/YYYY)|Comment for example 1000515|12/01/2007|OVER LIMIT| Is there a combination of txt output options...

Hi There, What you are looking for is called a cascading parameter and it is available in CR XI R2. There may be a way to build your own cascading parameter in earlier versions, but it will take some doing.

Thanks All Great information!

Dear All, Any Suggestions on where in the North East US one can find Business Objects training? I'm looking for Business Objects Classic Report development rather than Crystal. Any suggestion would be appreciated. Thanks

Dear All, In CE10 I want to allow users to copy a report to their favorites and schedule the report so that the next time they run the report, the parameters are filled in with whatever they chose the last time. Granting the rights to let the user copy the report is not a problem. Getting the...

LB, Thanks Again for asking the right question. The solution here was to group the events by speaker and startdate/time in the main report. Then supress events with start dates within 24 hours of the previous event startdate/time in the main report. Then insert a subreport at the...

LB, Excellent question. The data should be grouped first by speaker and then by 24 hour period beginning with the first event date/time and moving forward 24 hours, then beginning again and taking the events in the next 24 hours. To use your outstanding example: 3/7/06 8am 3/7/06 10am 3/7/06...

Report Purpose: show speakers with 3 or more events in a 24 hour period. Data: Speaker_ID, Event_ID, Event_DATETIME. It is very easy to Group the report by Speaker_ID and Event_DATETIME (day) and supress Event_DATETIME Groups with less than 3 Events. The problem is how to do the same thing...

Thanks, regedit works like a charm.

How does one turn off the automatic linking feature in the Crystal Report 10 desktop so that CR does not try to automatically link new tables?