Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. partymong

    Re-size Pie Charts dynamically

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

    Re-size Pie Charts dynamically

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

    Re-size Pie Charts dynamically

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

    Re-size Pie Charts dynamically

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

    Generate sub report from pie chart segment

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

    Add/edit records to parent and child nested datagrid

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

    Add/edit records to parent and child nested datagrid

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

    get current function name

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

    Update smalldatetime fields in all tables

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

    Update smalldatetime fields in all tables

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

    Update smalldatetime fields in all tables

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

    Stored proc to search multiple words and dropdowns

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

    Retrieving temp table data from MS SQL using ASP

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

    Retrieving temp table data from MS SQL using ASP

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

    varchar to datetime...out-of-range

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

    varchar to datetime...out-of-range

    Hi All, I have the query below which doesn't seem to work, I get the following message: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. NOTE:- The "creation date" is a varchar field.... I have tried using cast with the same...
  17. partymong

    File_exists

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

    Search multiple words with paging

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

    spaces in filename cookie

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

    spaces in filename cookie

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

Part and Inventory Search

Back
Top