Search results for query: *

Hi, I’m struggling with a Running Total problem. I’m attempting to create a view so I’m typing a PL-SQL statement that I think requires the use of ‘Oracle Analytics functions’ like Sum() Over and/or maybe even Lag () Over?. It can't be a stored procedure - the result needs to be a view so I...

Hi, I have a view and I'd like to turn it into a Stored Procedure so I can add a parameter. I will then pick the Stored Procedure as a source for a Crystal Report that I'm creating instead of the view that I currently use. At the moment the view is: SELECT * FROM JOB I'd like the stored...

Hi there, I have to use a sub select statement (or perhaps this is referred to as an inline statement) within a main statement and have come across the missing right parentesis issue when using an Order By clause in oracle PL-SQL. Heres a example to explain: SELECT EmpId, HireDate ( SELECT...

Hi there, MS SQL Server has some nice diagrams that can be added in Management Studio. Do we have the same options with Oracle SQL Developer. Any guidance would be great. Thanks Gordon Gordon BOCP Crystalize

Hi there, I have created a Pivot query in Oracle 11g SQL developer and it runs great. I now want to save as a view (I have rights to do this) and when I get an error I check for erros with the same SQL (I'm just copying and pasting). I'm just copying it and pasting it so I'm puzzled. Am I not...

Hi there, Wondering if anyone has made a connection with CR to Bloomberg data. Is there an ODBC perhance? Appreciate if anyone can share their experienes with reporting on Bloomberg data. Tx GOrdon Gordon BOCP Crystalize

Hi, I'd like to change the default date parameter prompt from dd/mm/yyyy to mm/dd/yyyy. I've tried changing any date settings I can find on Crystal Reports under File, Options, Fields and in my Control Panel. I even looked into the registry to see if I could find an entry that controlled this...

Hi there, I'm trying to conditionally format my details so that if the ticket number changes then the record will change to silver. So I end up with a banded report. Silver/white/silver/white etc. My report is sorted by ticket number and tickets can be listed more than one time. For e.g.: 1...

Hi there, I sometimes get this error when applying a template (on different versions of CR XI R1 R2 and CR 2008) and I can't figure out why its comes up sometimes and not other times. I've restarted CR 2008 today and it still comes up. Has anyone figured out why this sometimes comes up when...

Hi here, I have a cross tab in CR XI and I need to add an extra row. My CrossTab looks like this: Joe Tony New York 20 30 Toronto 30 60 Miami 70 90 The CrossTab column is filtered for Joe and Tony however they never have sales in Chicago and I would...

Hi, I have enable repository refresh selected when I save my report to my Crystal Reports Server. When I reopen this report from the CR Server in Crystal Reports XI R2 it always gets the latest version of the custom functions in my repository. So my reports are up to date with the changes I...

Hi there, Is there an random function in Crysal Reports XI that would help generated a series of random numbers between 0 to 100? I need a different random number for each record. If it could be uniform random that would be great. Thanks Gordon BOCP Crystalize

Hi there, I'm having some export problems with a particular report. It's a multi-grouped report with column headings in the page header area. The column headings label the detail. The problem is that when I export to Excel using data only I'm getting say a couple of headings in the middle just...

Hi there, I'm trying to determine fiscal periods. The fiscal periods end on the last sat of the month. The following period would then start on the following day (so they can cross over months). My first step is to determine (I think) which day of the month is the last Saturday - is this a...

Hi there, Is there a function in VBSCript that will convert a date to a string and allow me to have it in the format I want for example 04-11-2009 i.e. dd-mm-yyyy. A couple of functions I've tried haven't worked. The format function which works in VBA doesn't work here. Cstr doesn't allow me...

Hi, I'm trying to find the position of an item in array, say for example "Alley Cat Cycles" in an array of customers say ["Blazing Saddles", "Acme Bikes", "Alley Cat Cycles", "Barry's Bikes]. I want to get the answer 3 here as it's the customer is the third element in the string array. I can...