Search results for query: *

Thanks for all of your assistance Markros. I'll search for threads on ID field generating and see if I can make use of.

Does it matter where I place it? Did the following; USE [mdb] GO /****** Object: Trigger [dbo].[TR_DF_ci_hardware_workstation] Script Date: 12/07/2009 10:12:35 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET IDENTITY_INSERT dbo.ci_hardware_workstation OFF GO ALTER TRIGGER...

Previously I replaced table\column names with 'A', 'B', '1', '2', etc to simplify it. USE [mdb] GO /****** Object: Trigger [dbo].[TR_DF_ci_hardware_workstation] Script Date: 12/07/2009 10:12:35 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER...

Hi Markros, Thanks for your prompt reply. I've played around with your suggestion and suspect I didn't explain myself as well as I could of. I'm pretty sure the following will do the trick; USE [mdb] GO /****** Object: Trigger [dbo].[TR_DF_ci_hardware_workstation] Script Date: 12/07/2009...

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

Thanks groggle. Did the trick.

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.

Anyone? Am I making any sense?

Thanks Madawc, My defaults are for no decimal points or commas (-1123 in the 'Number' defaults). Unfortunately I need the date to be a number so the months order themselves correctly when printing the chart. The annoying thing is these display correctly when previewing in Crystal Reports...

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

Yeah, I was trying to spell out the problem in structured english rather than crystal syntax. The following worked; If {@OpenDate} in last7days then "Last Week" else If {@OpenDate} >= minimum(last7days)-7 and {@OpenDate} <= maximum(last7days)-7 then "Last 14 days" else If...

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

I take it all back lbass. Right you are. Thanks.

lbass, This will just sort the locations alphabetically as in the mentioned thread. I would like the graph to have the location with the highest number of records on the left (this is a group summary / distinct count on number of records) descending to the location with the lowest on the...

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.

From memory I had the same arror mssg and found that I had to configure the SMTP settings to the following 4 servers: 1) Destination Job Server 2) Reports Job Server 3) Web Intelligence Job Server 4) Program Job Server

Thanks again. Will follow up with BO and tinker with the print to HTML driver.

Thanks for the prompt reply Synapsevampire. Can see this is a limitation with Crystal Reports Server. Have searched the BO website and failed to find if this is possible (scheduling reports to be exported in HTML format to an unmanaged disk) utilising BO Enterprise XI R2. Are you able to shed...

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

No unfortunately I don't, but thanks for your advice anyway Mo.