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!

  • Congratulations bkrike 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: *

  • Users: checkai
  • Content: Threads
  • Order by date
  1. checkai

    Conditional Visibility of Top Group

    I am converting from 2005 to 2008 and have a report that does the following and is not working: 1. User selects a parameter denoting how they'd like to view the report (B or R values). 2. If "B" then hide the top group and show the second group and allow expanding into groups 3,4 3. If "R" show...
  2. checkai

    Export All Report Objects from BOE XI

    Is there a way to export all .rpt objects from Business Objects Enterprise?
  3. checkai

    Query Performance

    Is there any huge issue with the following SQL? This should be getting timesheets for only one week and it is a DOG!! select s.surname + ', ' + s.forename EmpName ,b.businessunit BusinessUnit ,r.region Region ,case when isnull(c.firstname,'') = '' then c.searchname else c.searchname + '...
  4. checkai

    Equivalent to Crystal's "Data Only" export.

    Is there an equivalent to Crystal's exporting to "Data Only" for excel?
  5. checkai

    Report Performance

    I'm trying to create a report that shows the performance of each, but getting some results that I'm not sure are correct. Please review my statement to see if I'm manipulating the milliseconds appropriately. Thanks! LEFT('0' + convert(char, CONVERT(int,(x.TimeRendering/3600000) % 24)),2) + ':'...
  6. checkai

    Getting Data source (stored Procedure) from Reports DB?

    Is it possible to read the report definition of where it is grabbing data from, from the Reports database? All of our reports are based on stored procedures and it would be nice to be able to query that database to see all stored procedures in use. any ideas? Thanks.
  7. checkai

    Filtered Snapshot

    Is it possible to filter a report snapshot with cascading parameters? I have been unable to accomplish this.
  8. checkai

    Usage Report for Stored Procedures

    Is there a way to tell how many times a stored procedure has been run and when?
  9. checkai

    Replication and Trigger

    We have Transactional Replication pushing data to our Reporting Database once a day. I am thinking of putting a trigger on one of the tables that gets hit by the replication. WHat the trigger would do would be to insert the ID of the table into another table. Basically, showing me all the IDs...
  10. checkai

    Background Image doesn't show up anymore

    We had a background image on each report and after a SQL Server 2005 Service Pack it no longer shows up. Any fixes for that?
  11. checkai

    Replication Question Can I find IDs of updated rows only?

    I have two databases. A production and a reporting db. The reporting db gets a transactional snapshot applied to it nightly for many tables. An example is tblWIP. Is it possible to pull the wipIDs that were updated by that snapshot and put them into a db table or access them in some way? Thanks!
  12. checkai

    Interactive Sort Image Disappear

    I have a report that has two images on it. One is set to the report background (no repeat) and the other is just in an image control listed as External source referencing an image in the project. When I bring up the report everything looks fine, however, when I use an interactive sort, both...
  13. checkai

    Visual Studio 2005 Font Recognition

    I just installed a font to my computer and rebooted. However, VS 2005 is not recognizing the new font in any of it's font drop downs. Any idea how to get this working? Thanks!
  14. checkai

    Visually appealing reports

    Any resources out there to help create very business like, visually appealing reports? Thanks. "...your mom goes to college..."
  15. checkai

    TSQL Changes/Upgrades in 2005

    I'm trying to find a document online that shows all of the new features within SQL Server 2005 T-SQL...anyone have this? Thanks. "...your mom goes to college..."
  16. checkai

    Help With Regular Expression

    Can someone help me determine what the values are for the below 3 variables? $server_pos = preg_replace('/^(.+?:\/\/)(.+)$/i','$2','http://www.mydomain.org'); $server_pos_base = preg_replace('/^(.+?)\/.+$/i','$1',$server_pos); $server_pos_flag = preg_replace('/^.+?(\/.+)$/i','$1',$server_pos)...
  17. checkai

    Regular Expression: Non Blank Integer

    I'm looking for a regular exp forcing a user to enter a non blank, integer between 0 and 100. Thanks! "...your mom goes to college..."
  18. checkai

    Replace throwing error with <> symbols

    I'd like my link to show <> symbols on hover and then remove them on mouse out... here's what I have so far. onmouseover="this.innerText= '< ' + this.innerText + ' >';" onmouseout="this.innerText = replace(' >', replace('< ',this.innerText));" "...your mom goes to college..."
  19. checkai

    Regular Expression Max Length

    I am looking to use an asp.net regular expression validation control on a text box. I would like to allow any character in the box, but a length of 0 to 200. Ideas? Thanks. "...your mom goes to college..."
  20. checkai

    File System Read Domain Controller Error

    Just started getting this error after the application has been working for 7 months. The application reads and writes to a file server under an account that has access to the specific location. Any ideas? Server Error in '/Workflow.NET.Prod/AuditLock' Application...

Part and Inventory Search

Back
Top