Search results for query: *

I have a list of reports in our business and what i want to do is send out a survey to every user asking them a set of questions per report. For each report we want to ask the following questions: Do you use the report? Y/N How often do you use it? Daily/Weekly/Monthly/Quarterly/Annually Is...

SQL Server 2008 Hi I have an issue where i have two of the same accounts which i would like to merge together, the list looks like below: AcctID AcctType AcctSubType Curr TransType Amount 1 CCY SET EUR Opening 1000 1 CCY SET EUR BUY...

SQL 2008 I've created a script which returns a list, however when i want to pass a field from my select in @Worktable into a parameter of a function which is linkted to @Worktable i get the error: "The multi part identifier 'pos.alt_curr_cde' could not be bout" My script is: Use...

SQL 2008 Report Builder 3.0 Hi This is probably going to be a stupid question. I'm converting a load of Crystal Reports over into SSRS. All of the reports are based upon SQL stored proc's. I have this stored proc USE [InfoPortal] GO /****** Object: StoredProcedure...

Excel 2010 I've got a list of reports which give the report number, report description and the stored proc which goes with it. example below: RPT_NUM RPT_NME SP_NME 1 Report1 SP1 2 Report2 SP2 3 Report3 SP3 4 Report4 SP1 5 Report5...

I have created a temporary table and i wish to aggregate the maket value into two columns called Total Fund Value and Cash/Cash Equivalents. Fot Total Fund Value i've created this in the select: SUM(p.valval_alt_cmb_amt) OVER (PARTITION BY RTRIM(a.acct_id)) AS [Total_Fund_Value] However for...

Crystal 2008 I want to Coalesce a formula like in SQL but I am having trouble with the syntax. Below is how i would think it could be written but i'm getting errors: IF ISNULL(COALESCE({tblPolicy.QuoteDate}),{tblPolicy.CreationDate}, {tblPolicy.CoverFrom}),’’) <> ‘’ AND {tblPolicy.Status} in...

Crystal 2008 Hi, i'm trying to create a report which will show premium's for a date period selected by the user, but also show the period selected for last year. I decided to create a main report with the user selected data, and then i'd create a subreport which would show same period last...

Crystal 2008 Hi I have a report which is grouped by SchemeID. Within this group are transactions grouped by TransID, so obviously this lists the transactions in TransID order beneath SchemeID. What i want to do is for a particular SchemeID, say 715, instead of it grouping and listing in...

Report Builder 3 i'm currently creating a report using Analysis Services cubes and so i'm creating the report using the mdx query designer. I have two data sets, one looks at premium splits by fiscal calendar and the other is policy count split by entry date. I wish to create one parameter so...