Search results for query: *

Good morning, I am trying to add a List of Dates to be used as Parameters in an SSRS 2005 Report. The reason for this is that the Report is quite resource heavy and I only want the end user to use a weeks worth of data only at any one time. I created a dataset (script at end of post) and used...

Hello, I have created a report that has four datasets all looking at the same stored procedure using the StoredProcedure Command type. All are parameterised by a single date. The difference between the four is a static integer parameter that I have manually set in the Parameter tab for each...

I've come across the same problem. I am a T-SQL programmer and have just moved into PL/SQL using PL/SQL Developer. If you are using version 6.0.6.946 (like I am), then indeed this is only possible in a command window. However, if you are using version 7.1 (possibly 7.0) then this is available...

Hi, I am trying to find a way of evaluating whether the elements of a given string are either numeric or alpha characters In T/SQL I would simply do the following:- SELECT * FROM Table WHERE UPPER(Field) LIKE('[A-Z][0-9][0-9][0-9][A-Z][A-Z]') Can't seem to find a simple way to replcate this...

Hi, Thanks for this, and your constructive comments (no offence taken). I am a T-SQL Programmer and am extremely new to PL/SQL. I am sure that the function will only ever return one row as the join is a one to one relationship. Not sure what you mean by 'fails to perform a return' as the...

Hi, I have writen a function that will return a specific field from a table. I want to be able to re-populate one of the parameters in the function as it executes, depending on what the user has entered as the parameter using the following, but simple cant find where in the function to add the...

Thanks BJ, There is a way of doing this having looked at the support forum, simply:- select * from table1 where rownum < 2 / select * from table2 where rownum < 2 / This will return the results to seperate tabs, but allows multiple queries to be executed at the same time. Cheers

Hello, I am a TSQL Developer and am new to PL/SQL and PL/SQL Developer. I would like to know whether it is possible to run two queries at the same time in one window. In SQL Server Query Analyser you could do the following for example:- select top 1 * from table1 go select top 1 * from table2...

Hi Guys, Thanks for your help, but none of these options seem to work. The first one doesn't seem to do anything and the second one still gets rid of the hyperlink property !! Would be good if you could control the spacing between objects in the report a little easier, especially when you have...

Sorry... am using Crystal Reports Developer V.X1

Good morning, I have created a formula field that contains an email address and hyperlink and am trying to bolt it on to the end of some text in another formula field, the problem is however that when I do this, the email part loses it's hyperlink capability. The reason I need to do this is...