Search results for query: *

Hi, SQL Server 2005 I've read through existing posts and used bits & pieces. Think I've got something close. When an Insert occurs on TABLE_A I want to perform an Insert on TABLE_B. I want to take TABLE_A.Value1 and insert it into new record TABLE_B.Value1. I also want to insert the value...

Please note. This formatting issue only occurs once published to CE. The report prints correctly in Crystal Reports. This is my post... http://www.tek-tips.com/viewthread.cfm?qid=1416335 Thanks.

Crytal Reports 10 CE10 I have 5 formulas. "Activity Date" date({View_Issue_Act_Log.time_stamp}) "Year" year({@Activity Date}) "Month" month({@Activity Date}) "Month Format" if {@month} in 1 to 9 then 0&{@month} else totext({@month}) "Year/Month" {@Year}&"/"&{@Month Format} I have a bar...

CR10 I need a formula that takes the Open_Date of a record and groups it into 1 of the 4 following date ranges. The Open_Date has always previously occured and I want the grouping to work like this. If Open_Date occurred in the last 7 days then "Last 7 days" else If Open_Date is older...

CR10 I have a bar chart which shows the number of records logged by location. I want to configure the graph to show the location with the higest number of records logged on the left and the lowest on the right. Please see thread thread149-1265140 for a similiar unsolved issue.

Hi, We are running Crystal Reports Server XI (an evaluation version) and would like to schedule our reports to export in HTML format, to an Unmanaged Disk destination. The only problem is that HTML is not a valid file format (It is with Crsytal Reports Developer which is what we are using to...

Crystal Reports v9 SQL 2000 Server Need to find a solution for the following; Every record has an 'SLA' column with a value of either 1. No Breach 2. Restore Breach 3. Fix Breach 4. All Breach Every record also has a 'Region' value (lets just say North, East, West, South) The business...

Crystal reports 9 - I have a subreport embedded in a main report - The report and subreport is connected to the same SQL DB - The report and subreport use different tables from the DB - The subreport has a distinct count on all records returned What I would like to do is pass this number...

Hi, I'm relativley new to Crystal and have been put in charge of daily reports. I have a large report which is made up of many subreports and is run daily (in the mornings to report on yesterday's data). The report has a date parameter which requires the user to enter a start and end date. At...