Recent content by Ice Rhino

Resolved by using WHERE (src_date >= CONVERT(varchar(6), @dt_src_date, 112) + '01') AND (src_date < DATEADD(month, 1, CONVERT(varchar(6), @dt_src_date, 112) + '01') - 1) Regards

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...

OK, noted and thanks

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...

Resolved by using TextBox3 syntax was:- =((ReportItems!TextBox1.Value)/(ReportItems!TextBox2.Value)) Regards

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 gone for this as the final solution to the problem. WHERE (src_terrier.datadate = @dt_src_date) AND (@chr_div is null or src_terrier.Areacode = @chr_div) AND (@vch_portfolio_no is null or src_centre_list.Portfolio_no = @vch_portfolio_no) AND (@vch_prop_cat is null or...

Currently my WHERE statements look like this; FROM src_terrier INNER JOIN src_centre_list ON src_terrier.siteref = src_centre_list.Site_Ref AND src_terrier.Areacode = src_centre_list.Division INNER JOIN src_div_mgr ON src_centre_list.Division...

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...

Think I might have solved this by leaving the field as an 'int' and set 'identity', 'identity seed', and 'identity increment'. I hope that this works and will solve my issue.

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...