Search results

I have two entries in a table site_ref src_date budget_rent budget_occ AE 01/04/2006 123456.0000 69 AE 01/05/2006 371540.2432 74 When I run the following query SELECT site_ref, budgeted_net_rent...

Is it possible in RS 2005 to have linked fields on a report. I have one dataset that contains one section on information, I then have a seperate dataset which contains some different information. site_ref is the common link between the two datasets. I will write the sort of syntax I would...

Greetings I am using SQL 2005 Reporting Services and I have a problem with parameters. If I leave 3 of the 4 values as non queried in the Available values section and mark them as a Default Values: of NULL, then the report works fine. However if I set the Available values to a query I have...

I am not sure whther I am allowed to post this in here but I could not find anywhere else on the board. Apologies if incorrect Textbox Calculations I have 2 text boxes on my report that contain values. I want to be able to divide one by the other and the result placed in a third. I have try...

I have a function that is based aounr the input of parameters. The last remaing issue is that I am required to enter the data into the parameter field as mm/dd/yyyy. I want to be able to enter the data as dd/mm/yyyy. I have tried to use WHERE (CONVERT(datetime,src_terrier.datadate,103) =...

I have a number of functions that require the input of parameters in order to ultimatly create a report under Reporting Services by making use of a Stored Procedure. All the functions etc work as does the stored procedure, but it only works if I specify data that I know exists e.g. DECLARE...

I have a function that uses the following statement in it SELECT src_terrier.Areacode, src_terrier.siteref, src_terrier.estatename, src_terrier.Securitised, src_terrier.unitref, src_terrier.unittype, src_terrier.unittype_count, src_terrier.tenantname...

Morning Campers, I have two tables src_monthly_terrrier and src_weekly_terrier. Both of these tables consists of 10+ columns. As the table names probably suggest, I import weekly data into one and monthly data into another. All the source data comes from an Excel spreadsheet via straight...

Greetings, I have a INSERT sp that just copies a few lines from one table into another. The problem I am hitting is that one of the fields in the target table is an ID field (this is from when the table started its life in MS Access and used Autonumber). Obviously this field does not accept...

I have a function that compiles a number of different aspects of a Select query and then creates some high-bred fields based on the result. The problem I have is that some of these values contain a zero or Null and therefore I am getting a divide by zero error. The three sums I have are as...

I am writing a set of functions and then a stored procedure to allow me to view some data in Reporting Services. I have written the first part of the function as shown ; set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[fnWTRTerrierData] (@vch_site_ref nvarchar (3)...

I have a field that contains data such as 'ACB00/02'. How would I write into a function that gathers a load of data together for me a peice of code that will grab only the first 2 chars of the afore mentioned value, So the result would be in the new created colum in a temp table 'AC'. This is...

I have a dataset in Reporting Services that basically just populates a report parameter field automatically for me. The small peice of SQL that I run is SELECT MAX (src_date) AS LatestMonth FROM dbo.tbl_src_date The problem I have is a visual one in that it all works but the output...

I am currently writing a report in SQL 2005 RS and have a problem with the format of a currency field. I am creating the report through the 'SQL Server Business Intelligence Development Studio' In the report preview (and live) it shows the prefix for the field to be $, and yet when I look at...

I posted a similar sort of question this a little while back although I was much greener then in 2005 than I am now(still green though, just not as green). I apologise if anyone classes this as a double post but it is not really. My problem is this. I have a MS Access 2003 database that hooks...

OK, I have just purchased the tutorial book Micorsoft SQL Server 2005 - Reporting Services (ISBN 0-07-226239-7). I have read it from the beginning to page 95 where I am now and it keeps referring to Galactic Delivery Services sample reports are going to be used for the rest of the book. Where...

Historically I have an Access 2003 Frontend talking to a SQL2000 backend. It is quite a complicated process which I shall attempt to explain here. I have a report on Access that has a record source of 'spSixMonth' and Input Parameters of @vch_Site_ref = [Forms]![frmdashboard]![cbxSiteRef]...

I am slowly working my way through the tutorials for 'Reporting Services' in SQL 2005. I am on Tutorial: 'Creating a Data-Driven Subscription' and currently in Lesson 2 which is 'Modifying the Report Data Source Properties'. It says, and I quote 1. Click Start, point to Programs, point to...

I have a Small peice of code I run in Query Analyzer, I then have a DTS I execute and then a further peice of Insert Into code which again I run in query anaylzer. What is the best way to run the code, do the DTS and then run the further peice of code in such a way that someone who is totally...

I have a form that runs a few querys and requerys based on a set of criteria. How can I make it so that if the value returned is Null in a certain field on a query then the contents of the List box displays 'No Records Found' rather than being blank Kindest Regards Toni