Recent content by partymong

No problem..Geoff Can't do it in RS2005 either :-( Is there any other way I could 'hack' it? Do you know if this will be available in RS2008? Thanks for your help P

Thanks Geoff, That is just what I need to do. However I can't seem to use an expression or code for the width or height in the Report Designer properties window for the chart. (property value is not valid error ...cannot be parsed because it does not contain numeric values) I can...

Geoff, I want to resize the entire chart objects. Example: Say I have some data with a "priority" field and a Status "Field" Say each of the 9 pie charts show status data for a particular priority. I want to change the size of each pie chart to show the amount (or impact) that priority...

Hi All, I am fairly new to reporting services. I want to create a report, whereby there are 9 pie charts which would need to dynamically vary in size dependant on the number of records returned for each pie chart data. (i.e. the pie charts size would need to be proportionate to the total...

Hi All, I am new to reporting services. Is there any way to launch a subreport that I have from a pie chart segment. (i.e. jumpto on pie chart segment rather than the whole pie chart?) Thankyou in Advance for your help! P

Hi, Ok thanks, but when I put my child grid in a template column of the parent grid I can't get my child grid events to fire. Here is the grid I want to be the parent. <asp:datagrid id="dgCRs" runat="server" ShowFooter="True" BorderStyle="Ridge" BorderColor="LightGray"...

Hi All, I would like to be able to create nested datagrids where I can add and edit a record of both the parent and child datagrids inline. I am able to add/edit the datgrids on there own i.e. Not nested - I have created a datagrid that I can add and edit rows. I am , however,unsure of...

Hi All, Is there a way of retrieving the name of the currently running function? i.e function x is running and within that function I want to return it's name. Return x (the name of the function) Thankyou in advance for your help

Hi Vongrunt, Thankyou! That works great!... I just changed the following line:- set @sql_update = N'UPDATE ' + @lasttable + N' SET ' + @sql_update Then added the following line:- EXEC sp_executesql @sql_update To execute the update statement Thankyou for your help! Regards P

Thanks Jay, I need to dynamically update all the fields, in 1000's of tables, where I may not know the field or table name. Can I get the datatype from syscolumns, i.e type 58, then update all the records in all the fields that have that datatype? Thanks, Regards, P

Hi All, I want to update(increment) the year in all smalldatetime fields in all tables of a database. Is there an easy way of doing this? There are 1000's of these fields. Can I use sysobjects to do this? Any help would be appreciated. Thanks in advance for your help! Regards, Peter

Hi All, I want to create a stored procedure to deal with a multiple word search (via an input box) but allow the search to be narrowed down via 3 drop down lists. I want to search for the inputted words, but where the values in drop down lists are met... I am sure I could be approaching...

Hi All, I have solved my problem. I am posting the solution, in case anyone else encounters the same problem In my stored procedure I put my code in a transaction and I now get the result from the temporary table in a resultset. Heres the example:- CREATE PROCEDURE sp_StoredProcName...

Hi All, I have the exactly the same problem as the initial post. Can anyone expand on Shaggs post? Any help would be gratefully appreciated. Thankyou! Regards, P

Sorry All, I've solved the problem... The "creation date" field contained 'rogue' values. Which I identified using... SELECT * FROM "ALL_CRs_MW" WHERE ISDATE("Creation Date") = 0 P