Search results for query: *

Trying to build an investment query where I drill down from a fund or a company and find all underlying funds of investee companies. In reality this is unlikely to go down more than 3-4 levels but could go further. A company can invest in another company or fund and a fund can invest in another...

We have a Balance table which various balances, however, balance is only updated when there is a movement. Previous balance filed has its enddateid updated and a new entry is created with an end date set 100 years in future. Following query finds balance on a specific date. I need to produce a...

I am trying to create TVF with an Index. However, I get the error Msg 444, Level 16, State 2, Procedure FN_BFS_TransactionTypeGroups, Line 29 [Batch Start Line 0] Select statements included within a function cannot return data to a client. Line 29 is where the With Statement is (see below)...

I need to get Month End Dates in a flexible date range. These dates are then converted to DateIDs for use in my main query. Code below works fine as standalone, but I f I try to convert to another CTE or use as a Subquery it get an error associated with OPTION. Is there a way around this, or a...

We have a Guest Account on our Crystal report Server with 5 licences SAP BusinessObjects BI Platform 4.1 Support Pack 2 Version: 14.1.2.1121 We never use Guest but some mornings we find Guest as somehow been allocated all 5 licences and we have to clear sessions so that other users can log in...

When I update reports on Crystal Report Server I use save as from Crystal Reports to over write any existing report. This enables me to preserve Schedules and any saved instances. In most cases this works fine. However, a couple of reports seem to cache design in scheduler. That is when a...

Is it possible to query a whole schema and find which tables if any do not have a primary Key. Thank you Ian

I have a report with a subreport. The main report runs against SQL server, but then needs to look up data on an Oracle database using a subreport. All works perfectly well in Crystal Developer but when I load onto Crystal Reports Server The database configuration dialog box only allows...

I am trying to test a stored Proc used in a report. The procedure has a date input parameter and a cursor result set as output create or replace PROCEDURE "OLY_NOSTRO_PROJECTION" (pStartDate IN DATE, pResultSet OUT TYPES.cursorType) as Procedure runs perfectly OK in report and...

I have built a report (CR2013) with a command on Oracle 11. All working fine with exception of string Parameters. I can use the parameter builder inside the command function box to add in parameters and they work fine for Numbers and dates. However, when I try to add a string parameter I get...

I am trying to create a dynamic parameter to show a list of Branches. This subquery generates what I need including an ALL option and when I join to my data I can enter 0 for All or a specific branch number Query built on Oracle 11 select ID BRANCHID, NAME BRANCHNAME, SHORTNAME from...

I am using another Application (Crystal Reports) to generate a CSV file which has a header comprising a String of data 52 characters long. Crystal Reports Server then exports file with an automatically generated file name which includes DateTime in seconds when file is created. Due to timing...

MS SQL Server 2008 Within a larger query I am looking up an Introducer, in rare cases a client has two introducers and this is duplicating the rest of the data. I could modify my query to only bring back 1 introducer, however, I would like to look at the possibility of listing the Introducers...

I have a PIVOT query which works fine for Year to date. However, users now want a rolling 12 months pivot In simplified form my current query looks like Select 'DAYS_COUNT' as Measure, [1] as Mth1, [2] as Mth2, [3] as Mth3, [4] as Mth4, [5] as Mth5, ..... from (select ID, CalYearNo...

CR2011 on Oracle 11 I have a very complex cross tab report where data has mix of % and non % data. I have managed to suppress the % as required using the following conditional formula on the Currency symbol tab if currentrowindex in[19,22] then crNoCurrencySymbol else crFloatingCurrencySymbol...

CR2011 on Oracle 11 using a command I am trying to build a chart which shows growth of an investment over 10 years by month. However, I only want to see the years as markers on the X axis, however, crystal insists on showing the months making axis too crowded and unreadable I am using a simple...

This is my failed attempt at a Where clause where (case when @SelectGL = 'Client Account' then TXN_GLCODE_FK = 211 else TXN_GLCODE_FK in (353, 355) end) and TXN_AMOUNT <> 0 and cast(TXN_CREATED_DATE as date) >= @StartDate and cast(TXN_CREATED_DATE as date) <= @Enddate I know the use of case is...

I have a function which works 99.99% of the time, however, we have discovered another exception but I can not work out how to add it in. This is current function create or replace Function FCIM_Start_Of_Risk_Period_RH (Polno Genpolicy.Policy_Key%Type, Eff_Date...

I have to export some telephone numbers to Excel, but when I do that excel sees it as a numbers and removes the leading zero I am want to try a couple of solutions I can pad the number with a space and that allows the leading zero, but that is not Ideal as number now looks like 01234 678987...

I have two datasets and the only way I can join them causes the first set to duplicate on date. I need to sum the first set of data but only on change of date eg 31/07/2012 207.31 31/07/2012 207.31 03/09/2012 177.31 03/09/2012 177.31 I want to see a total of 384.62 How do I do that please...