Search results for query: *

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

...= patindex('%' + @separator + '%' , @array) select @array_value = left(@array, @separator_position - 1) Insert into #result SELECT * FROM datasets WHERE isNew = @flavour and lastModifiedDate = @blah and datasetVersion = @version and (datasetDesc LIKE '%' + @array_value + '%' or...

...TRAN SET NOCOUNT ON CREATE TABLE #tempTable(Field1 varchar(10), Field2 int) INSERT INTO #tempTable(Field1 varchar(10), Field2 int) Values(@Param1, @Param2) SELECT * FROM #tempTable DROP TABLE #tempTable SET NOCOUNT OFF COMMIT TRAN GO I did not need to change any of my vbscript...

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

...The "creation date" is a varchar field.... I have tried using cast with the same problem... Any Ideas?? Thanks in advance for your help P /* Declare the variable */ Declare @NumCR as int Declare @Open as int Declare @Closed as int /* Add more months here to make a rolling 12 */ Declare...

sleipnir214, I still can't get the code to work. Refrerring to the following.... If the actual machine and directory where the file exists is visible from the Win32 PHP host machine What do you mean by 'visible'? What 'user' would need access to the file? Thanks, P

Hi All, I have searched through the forum but have not currently found a full solution to my problem. I want to be able to create a multiple word search on various fields in a database table and page the results. I can page a one word search.. I can multiword search without paging...

Hi All, Ok ignore my post about mssql.... I've got it working.... A note of caution for anyone else having problems with MSSQL and php... You must make sure you have the 'right' php_mssql.dll in the php directory.... P

Hi Westbury, I'm new to php... What I need to do is transfer the filename between php and asp...(don't ask...) I have found that the only way to do this is via a cookie.. Any other suggestions would be appreciated... Ideally I would like to add the filename directly to MSSQL...