Search results for query: *

Crystal 10 connecting to MSSQL 2000 (sp3a) via ODBC (MDAC 2.8) I am attempting to send command parameters to a UDF but keep getting a rowset error. I start out with hardcoded dates and after confirming the query works in the command, added parameters and replaced the hardcoded dates. The UDF...

Using Crystal 10 connecting to MS SQL 2000 via ODBC. I could do the following with subreports but would prefer to not deal with the complexity and the performence hit involved. The desired group hierarchy is as follows: child | |--appts | |--parties | |--presents with...

Using Crystal 10 connecting to MS SQL 2000 via ODBC. I am trying to find out if the value of a field is all caps. I was hoping the following formula would work, but it returns 1 with an o3_name of '275 Main St.' if {SiteAddress.o3_name} = uppercase({SiteAddress.o3_name}) then 1 else 2...

Using Crystal 10 connecting to MS SQL 2000 via ODBC. When I create a subreport and open up Section Expert, this is what I see. Report Header Report Header a (this is supressed) Report Header b Details Report Footer Report Footer a (this is supressed) Report Footer b Any...

Using Crystal 10 connecting to MS SQL 2000 via ODBC Is there a way to use existing parameters (created in field explorer) in a query in add command or modify command window? thanks, damon

Using Crystal 10 connecting to MS SQL via ODBC. Basically, I'm looking to do a 'distinct sum.' I am trying to calculate average age across groups that can contain the same persons more than once. As an example, Chone Figgans plays both the infield and outfield for the Angels and shows up in...

Using Crystal 10 connecting to MS SQL via ODBC. I am working on converting the printing of CMS form 700 (http://www.cms.hhs.gov/forms/cms700.pdf) to crystal. A few of the boxes (12, 20, 21) can contain more data than can physically fit inside the allocated space. I would like to continue...

Using Crystal 10 connecting to MS SQL via ODBC. The following formula doesn't calculate for the last record. If I use previous, it doesn't calculate the first record. It just leaves a blank field. Any idea why the NextIsNull isn't working as expected? thanks, damon if {CommOut.contact_id}...

Using Crystal 10 connecting to MS SQL via ODBC. How do I find, display the hierarchy level of a group? How about manipulating group based upon the level? Obviously, my Hierarchical Group Options is set to Group Data Hierarchially. thanks, damon

I am working on a report in Crystal 10 running against MS SQL via ODBC. The following scenario simplifies the situation. Any suggestions on how to accomplish this task? I have three pizza parlors, two diners and three theaters. My employees can work at any or all of them at the same time or...