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

    My report manager's icon and command buttons are gone!

    I would check to make sure the directories with these icons, etc still exist and IIS has access to them. I would also check that the asp.net code for SSRS in IIS is correct as well. I'm not aware of any "setting" for this, but there just may be. Let us know what you find out. Good luck! ~Brett...
  2. bburnell

    VS Standard edition

    Dave is correct. The SSRS part of VS (BIDS) is installed with any version of SQL Server. It does not come with VS (VB, C#, etc.). SQL Express may be all you need, but you need the SQL Express version with the SSRS component in it. ~Brett -------------------------- Web/.net Programmer & DBA...
  3. bburnell

    Runningvalue on calculated field

    Have you thought of doing a subreport for this total value and calculating it in an SQL query? Just a thought. ~Brett -------------------------- Web/.net Programmer & DBA Central PA
  4. bburnell

    SSRS and DBase III Files

    Hi, Has anyone had any luck with getting DBase III files/directories to work correctly in SQL 2005? The connection and queries run fine in VS/BIDS, but when I deploy them to the server I get the following: The Microsoft Jet database engine could not find the object '<TABLENAME>'. Make sure the...
  5. bburnell

    SSRS Account

    Hi all, Running SSRS 2005 on a Windows 2003 server. We are having a problem getting a report to run in SSRS when it seems to run fine locally (in VS 2005). It is using a DBase III database to connect to, but my thinking is that the SSRS account does not have access to that folder. Does anyone...
  6. bburnell

    SSRS report -- how to make in blackberry compatable

    I don't have any experience with SSRS, but I have converted Visual Studio solutions to smartphones. The biggest problem is the size of the screen. A normal computer will have 800x600 or 1024x768, but I smart phone is usually around 230x230 or so. You will have to try and limit the size of the...
  7. bburnell

    Where is customers.xls

    Are you sure that the DTS does not create the customers.xls file earlly on in the package? ~Brett -------------------------- Web/.net Programmer & DBA Central PA
  8. bburnell

    vb.net 2005 need help with saving to SQL database

    I don't have time to rewrite your code, but here's some sample code I have that I know works. I took out some of the parameters to shorten it up. Hope this helps! ~Brett Public Sub SP_NW7316_Insert_Services(ByVal ins_MNMmbrno As String, ByVal ins_MSVsrvno As String, ByVal ins_MSVeffec As...
  9. bburnell

    Report Manager URL setup

    I use the following similar URLs (in SQL 2005. I would think they would be the same/similar in 2008): http://server:8080/Reports$myinstance/Pages/Folder.aspx https://server.domain.local:8081/Reports/Pages/Folder.aspx That will get you to the "home" directory. From there you will have to set up...
  10. bburnell

    Upsizing access 2007 db to SQL 2005: ODBC connection failed

    Have you tried converting the Access DB to 2000/XP/2003 standards and trying that instead? I am wondering if it doesn't recognize the 2007 standard(s). Hope that helps! ~Brett -------------------------- Web/.net Programmer & DBA Central PA
  11. bburnell

    PDF Render Looks Different Than Onscreen Version (SSRS 2008)

    Yes, VS2005 and VS2008 create 2 different report types that are different in SQL 2005 & SQL 2008. ~Brett -------------------------- Web/.net Programmer & DBA Central PA
  12. bburnell

    PDF Render Looks Different Than Onscreen Version (SSRS 2008)

    What Rose said is what I've heard as well. I didn't realize SP3 corrected it though. Great! ~Brett -------------------------- Web/.net Programmer & DBA Central PA
  13. bburnell

    PDF Render Looks Different Than Onscreen Version (SSRS 2008)

    Have you tried adding the font to your project? ~Brett -------------------------- Web/.net Programmer & DBA Central PA
  14. bburnell

    Query runs fast in SQL Developer but slow in SSRS

    Maybe you can post the SQL for us to analyze? ~Brett -------------------------- Web/.net Programmer & DBA Central PA
  15. bburnell

    Help with Excel file in DTS

    Nevermind. This works perfectly... http://support.jodohost.com/showthread.php?t=1192 -------------------------- Web/.net Programmer & DBA Central PA
  16. bburnell

    Help with Excel file in DTS

    Hi all, I'm using Excel XP with SQL Server 2000. I have a DTS that creates an Excel file via data from the SQL Server. In the past we have used the "Close Connection" checkbox at the end of the step, but this will also close the SQL connection and drop the temp table(s) we need to complete the...
  17. bburnell

    External Table Not in Expected Format

    Does your supervisor's machine have Office 2003/2007 installed as well? I am wondering if it is getting confused. ~Brett -------------------------- Web/.net Programmer & DBA Central PA
  18. bburnell

    where to look up security at the reportserver.table ?

    The best way to do it is to go on the actual server and log in to the "Reporting Services" in SQL Server Management Studio. Under there, go to home and then find your report. Right click on the report you are interested in seeing the security for and click the "Permissions" page. I don't think...
  19. bburnell

    Using SSRS for our company's website.

    RiverGuy's answer is definitely your best bet. It should also be the cheapest. ~Brett -------------------------- Web/.net Programmer & DBA Central PA
  20. bburnell

    Where are reports stored on Server?

    In 2005, the edit button is under the properties tab of the report. -------------------------- Web/.net Programmer & DBA Central PA

Part and Inventory Search

Back
Top