Recent content by diane55

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...