Search results for query: *

I am working with MSSQL RS 2008 working with the new app for 6 months or so...migrating Crystal reports. I need to display a line to seperate a change in the group header 2 data. I have done several searches via google ect without result...any thoughts or direction would be appreciated. Thanks...

SantaMufasa - I need to copy the contents of the crdba.idnt.Last_Name column into the crdba.idnt.Company_Name column when the crdba.case.ofic_cd is equal to P50 and the crdba.idnt.first_name and the crdba.idnt.company_name is null and crdba.idnt.idnt_id is equal to crdba.pty.idnt_id and...

Thanks ahead of time for your review! I am on Oracle 9i trying to write an update query. Below is the query that returns an error: ORA-00913: to many values When I remove the p.case_id I get the following error: ORA-1427: single row query rturns more than one row. What i am trying to...

({@FetchID} <> {OfcrCmd.SUP_ID} The above is the criteria for supression. The fetch formula is based on the maxvalue largest_id of the record - returns the id thru a subreport. The compare is then to the coulmn in the suptable on the ids. If not equal the record is supressed. When the record...

thread767-1068492 I need to inquire more on the response posted in the thread noted above by lbass. What if I want to supress the group header and there are records in the group they are just supressed? Crystal X Any thoughts D Thanks! :)

ok LB You have done it again! I had to re-do my set-ups twice to get CR to save it. Weird. A final tweek - I also pulled your thread on counters, as I need to set them up also. I have the inits, accums and show formulas in place. However, I can't seem to get the counter to not increment...

I did hide the sections in the sub except the section that has the sub in it, font size 1, and as small as I could make the space but I still have white space. Problem is that the sub is in Detail a as a fetch and store. So what I have done is turn font white now I have all white space. Where...

Thanks LBass - You helped me solve the reporting issue for the max function - Kudos to you! I do have one more question - I had to place my sub in details a in order to get my fetch in details b to work The problem is now - I can not supress details a or i lose all of the detail b records -...

The {Table.DateTime} is of the type DateTime so in using a numbervar dec - I get a message that I need a number. I tried to wrap toNumber but now I get a string msg - shared numbervar maxdt := toNumber(maximum({table.dateTime})) I believe I am missing part of the formula construction.

First, thanks for taking time to read my post. I am not sure I have provided enough detail so let me know... I need to compare DateTime result in SubReport to Date Time in Main Rpt. I am using CR Dev. 10 Oracle Database I need to take the resultant Max Date from the subreport and compare that...

ok lbass I would like to further this discussion But what if the field (Group Header) is an event time that needs to appear only once. For instance I am grouping my records on event code and then event time. 9:00 am shows up twice then 9:30 once. How do I eliminate the suplicate 9:00 am...

lbass Thanks for the reply. In the page header I have @schedDt weekdayname(dayofweek({@currentDt})); the above returns Friday 02/23/2007 So this is good. Thanks again. Diana

Formula: //{@ScheduleDt}: weekdayname(dayofweek({JDGBLKTM.BLK_DT})) Yes I did place the formula in the Page Header. That is how I know that the value that returns is Wednesday rather than Thurday - When I compile the report. Thanks for looking. D

I am running Crystal 10 on an ODBC database. My question - In the Crystal Report I am creating I have created a formula and placed it in the page header. The formula is "weekdayname(dayofweek({tableName.columnName}))" The outcome of this formula is "Wednesday". The columnName (date) of...

Yes, My grouping is for the date range of 02-21-7 thru 02-25-07. as a parameter entered prior to the report run. I am not using a group by date weekly ( I may not be communicating the functionality of CR correctlly - pardon my lack of CR speak. Either way that makes sense to me. Thanks so...

Crystal 10 Oracle Database ODBC connetion I have a report that has a parameter prompt for the Date Range (Begin and End) I enter the Date Range the report pulls the correct records using the date entered. The issue is that when I display the report via the Display tab on the record tree (on...

I am developing a report in CR10 - I need to suppress a field in my main report based on if the subReport is suppressed (via no data being returned from subReport). Is there a function/command to check if the Suppress Blank subReport (checked in the format Editor subReport tab) is true. Any...

lbass That option on my toolbar is not availiable and is greyed out. Thanks - Do you know of any other options that I could control? Diana

I have a SQL procedure that returns a record set that is passed to Crystal 9.0. The record set from my procedure includes two records that appear to be duplicate, but are actually different. However, the defining element is not a part of the actual SQL record set; therefore it is not passed on...

Thanks lbass. I am a new programmer to Crystal and I was able to solve a logic issue using your Oct 6, 2004 response to tmozer! What a great forum! I have this bookmarked and I'll be back! Again Thanks! dlk