reportviewer issue

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - remove SQLserver2005 problem hi all, what is the best way to remove SQLSERVER2005 from my computer running XP-sp2 when i try to remove from tha ADD and Remove program from the control panel it's start the wizard but going to stuck.. thankx Tag: reportviewer issue
  - 2
    - insufficient access rights error when doing backup Thanks a lot. It fixed my problem. Tag: reportviewer issue
  - 3
    - FileProperty and sp_spaceused Hi All I am trying to execute the following set of commands: select fileproperty('master','SpaceUsed')*8; select sum(reserved)*8 from master.dbo.sysindexes where indid in (0,1,255); exec sp_spaceused ; I am getting different values from fileproperty and the sp_spaceused. I am wondering why this is happening. I am sure that there is a valid reason behind this. Can anyone explain why this is happening I also tried using DBCC updateusage('master') with count_rows and sp_updatestats. Thanks Vijay Tag: reportviewer issue
  - 4
    - Vista SQL 2005 SP2 client to Windows XP SQL 2005 (non-sp2) workstation. (Take 2 w/ Workaround) This issue has not been "resolved" as I can tell. But there is a workaround w/o using sql authentication (hate sql authentication) http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1528018&SiteID=1 I found out that it doesnt matter which combination you use for the server as long as the client is Vista... If you are using a windows account, lets say "jondoe" on your vista box acting as a sql management studio client to a sql server on an xp or w2k3 box using windows authentication.... IT WILL work if both the vista box and the xp/w2k3 box BOTH have "jondoe" accounts, and both "jondoe" account passwords are the same!!! SOOOooo.... Apparently when vista runs the program under jondoe (when you launch the shortcut) it runs it under that context (no-duh) but EVEN if you establish a network connection (using net use) beforehand with alternate credentials (lets say on the xp/w2k3 box the user is jonsmith) and then use sql management studio you are assuming that it will just use those trusted credentials.... you are wrong... it wont anymore in vista by default. WTF Why because apparently sql management studio 2005 no longer is allowed to retrieve stored credentials to impersonate jonsmith when connecting to the xp/w2k3 box.... this is where the infamous "no user is associated with this trusted connection". I also got this error with Visual Studio 2005 Web Express Edition... hmmm... a correlation i see SOOOoooo... Workaround 1 (more secure): Create the windows account "jonsmith" on your vista box, set the password to the same exact password for the server's user account. then run the sql management studio application under the jonsmith account using "runas". Result: it works just as it supposed to... using windows authentication. Workaround 2 (less secure): Create the account "jondoe" on the xp/w2k3 box, set the password to the same exact password for the server's user account. then run the sql management studio application under the jonsmith account using "runas". Result: it works just as it supposed to... using windows authentication. Workaround 3: Use sql authentication. works like a charm but not as secure as 1 and 2. FYI: these apply to workgroup connections. domain computers are exempt cause security is handled by domain controllers. I think there must be a security setting (registry option) that would allow this process to work w/o the workaround, but I have yet to figure it out... I'm like a pitbull sniffing around for clues and the only leads i have is that its vista SSPI and that if there is an option, it would be in local security policy AND/OR undocumented registry option. Note: I hate workarounds unless there is a clear cut reason why we have to do it this way. Either because there was a design oops or security consideration when accounts are hijacked.... either way anyone from Microsoft have an explanation of this Oh... firewall enabled/disabled doesnt matter, all systems patched up the yinyang and what nots do not change the end result. All I did was create matching accounts on both ends (using either workaround 1 or 2) and it worked just fine. SOOOOoooo... my question is..... why can't SQLM2K5 MS and VSWD2K5 express grab the existing alternate credentials that i've established (through net use) and run with the ball BTW: I've tried using that "Alert Me" option below. Doesn't work. page takes a nose dive on the POST. Tag: reportviewer issue
  - 5
    - Unable to create maintenance plan When i tried to create a maintenance plan for my db - it's just a full db backup task, it gave a weird error "Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)." Any idea what is wrong is there anywhere i can find details about the error Tag: reportviewer issue
  - 6
    - SP2 Report Builder and default save location Sorry if the information I gave you does not work. I don't have a better answer for you, but I can give you some more information. The "SAVELOCATION" parameter is only supported in Sharepoint mode. It is the argument that is passed to report builder when you launch Report Builder from the "New" menu in sharepoint, and is intended to be the initial location where reports are to be saved at. "SAVELOCATION", "MODEL", and "REPORTITEM" parameters where intented to be mutually exclusive. When a Model or a Report Item is passed in as an argument, then their location is used as the initial save location. Tag: reportviewer issue
  - 7
    - Create Subscription For Rpt Service with Windows integrated security !!! Yep, it sure does. A big pain. You could have multiple copies of the one report and change the data source of each report. Then secure the report via user groups. A pain, but if you only had a few users it might be ok. If you have hundreds however...... Tag: reportviewer issue
  - 8
    - Problem Configuring Reporting Service Hey there, im having a problem that a few people seemed to have had already. The problem is again related to the Web Service Identity. Windows Server 2000, IIS 5.0, SQL Server Express 2005 Adv, and Microsoft.Net 2.0 after installing SQL Server Express 2005 when i launch the Reporting Service Configuration it could not connect to the Server as the Reporting Service was not running. In order to get the Reporting Service running i had to modify the rsreportserver.config file in the C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer directory. Here i modified the added the following <WebServiceAccount>IWAM_SKYREV</WebServiceAccount> this was due to no SKYREV\ASPNET account being available on the server machine. (based on this article http://support.microsoft.com/default.aspx/kb/911846 ) Once i changed this i could now get the Reporting Service running and access the configuration tool. So now we come to my current problem. In the Web Service Identity it shows an exclamation. Here the ASP.net as SKYREV\ASPNET and when i attempt to apply this i get the following error: ReportServicesConfigUI.WMIProvider.WMIProviderException: The account name is not valid. Specify an account in the form domain\alias. at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool) Any one have any ideas for me... Tag: reportviewer issue
  - 9
    - How to return multiple values from stored procedures thanx Tag: reportviewer issue
  - 10
    - Cannot see Local Database template in Add New Item Dialog box Per MSDN instructions I downloaded the folliwng: .NET Framework 2.0, SQL Server 2005, SQL Server Compact 3.5, and Visual Basic Expess Edition. When following the tutorial to create a database, I was never able to see the Local Database template. I am taking the programming lessons in VB, and I am up to Creating Your First Datatbase. It is a requirement that SQL Server Compact 3.5 be installed. Which I have done. Tag: reportviewer issue
  - 11
    - SqlDataSourceEnumerator.Instance; not returning all instances Hi, have a look in the registry key: and if all instances are mentioned here. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server There is a know issue if SQL Server Express is installed in the machine. Is SQL Server Express installed HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: reportviewer issue
  - 12
    - Drillthrough (beginner) I have created two reports. One links to the other with a drillthrough. The linking works fine, but no values show up in the fields besides the group titles and column titles. Why is this happening The user is given a list of Counties with values. The Counties(in a matrix) are clickable for a drillthrough of Ages and Genders in the Counties. Looks something like this: Years Counties Total Crashes Fatalities Cook 85 98 Manchester 2850 258 Sagamon 987 526 So when a user clicks a county, such as "Cook", this is displayed Years Age Gender Total Crashes Fatalities 0-8 Female 25 8 Male 55 15 9-15 Female 850 258 Male 185 35 16-22 Female 87 526 Male 10 35 But I am getting this in : Years Age Gender Total Crashes Fatalities 0-8 Female Male 9-15 Female Male 16-22 Female Male Whats going on Can anyone make any suggestions Just to let you know its based off of an Analysis Services Cube and not relational tables. Tag: reportviewer issue
  - 13
    - DBCC TableResults Anyone know where I can find the "TableResults" table definition in order to create a table for the DBCC command I can't seem to find it in BOL... Tag: reportviewer issue
  - 14
    - How can I get AS 2005 to use more than 2GB? AS should be able to see and use 3Gb even in Standard Edition 32-bit, once you've set the /3Gb switch. See: http://technet.microsoft.com/en-us/library/ms175672.aspx and http://support.microsoft.com/default.aspx scid=kb;en-us;291988 What is your TotalMemoryLimit server property (for details see http://www.microsoft.com/technet/prodtechnol/sql/2005/ssasproperties.mspx ) set to I have a vague recollection that there might be something special you have to do to get AS to use the extra memory, but that could be my imagination. Alternatively, the error message you're seeing might just be wrong about how much memory AS can see. You can stop the error by altering the MemoryLimitErrorEnabled server property (see the previous link) but it sounds like you do need to upgrade to 64-bit to process whatever it is you're trying to process. HTH, Chris Tag: reportviewer issue
  - 15
    - AS2005 Cube Excel 2007 Filtering Issue Hello Mosha. It would be interesting to know about the features in Excel 2007 that are disabled before SSAS2005 SP2 Is this something that you have mentioned in your Blog(multiselect) or something else Do you mean internal features like the MDX being generated from Excel2007 Are these new features being enabled by an update on the client Kind Regards Thomas Ivarsson Tag: reportviewer issue
  - 16
    - Apparent Memory Leaks in ODBC We have created a multithreaded application that reads result sets from MS SQL Server (both 2000 and 2005). The MS SQL Server app and our app reside on the same machine. We are using the latest version of ODBC32.DLL (3.526.1830.0) and SQLSRV32.DLL (2000.86.1830). Our application is written in C++ using the Visual C++ 6.0 compiler and libraries. Our app runs as a service, therefore the apparent memory leak is a real problem. Our app needs to run on a server in a closet without human intervention. We are kicking off many user threads that each can read from the database tables. Each of the reads from the database occurs within a critical section to minimize the threads stepping on each other. The ODBC interface class follows all the steps defined in the ODBC application developers documention (see code below). We see or app memory steadily increasing over time (we used PerfMon to monitor Private Bytes and Virtual Bytes, per ODBC documentation). If we terminate the threads which are retreiving the result sets, the memory drops back to the level noted prior to starting the threads. The code below is admittedly inefficient, however, it should not leak memory when accessing the database. Note that it works very well, returns the result sets that we expect exactly. SQLHENV henv = SQL_NULL_HENV; SQLHDBC hdbc = SQL_NULL_HDBC; SQLHSTMT hstmt1 = SQL_NULL_HSTMT; SQLRETURN retCode; SQLSMALLINT sColCount = 0; CODBCInterfaceColumnList lColumnList; CString strDSN; CString strUID = _T("AccountName"); CString strPWD = _T("Password"); CString strServer; CString strDatabase; CString strDebugMsg; if(!CreateDSN( pRecordList->m_strDefaultODBCConnect, strDSN, strDatabase, strUID, strPWD, strServer)) { strExceptionMsg.Format( _T("Cannot create DSN from connect string %s"), pRecordList->m_strDefaultODBCConnect); bReturn = true; return bReturn; } if(pRecordList->m_strDefaultODBCConnect.IsEmpty()) { bReturn = true; return bReturn; } // Allocate the environment handle retCode = SQLAllocHandle(SQL_HANDLE_ENV,NULL, &henv); if(retCode != SQL_ERROR && retCode != SQL_INVALID_HANDLE) { // Set the environment to ODBC Version 3.0 retCode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, SQL_IS_INTEGER); if(retCode != SQL_SUCCESS) { GetErrorMsgs(hdbc, SQL_HANDLE_ENV, strDebugMsg); } if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { // Allocate a ODBC connection handle handle retCode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { retCode = SQLConnect( hdbc, (UCHAR*)(LPCTSTR)strDSN, SQL_NTS, (UCHAR*)(LPCTSTR)strUID, SQL_NTS, (UCHAR*)(LPCTSTR)strPWD, SQL_NTS); if(retCode != SQL_SUCCESS) { GetErrorMsgs(hdbc, SQL_HANDLE_DBC, strDebugMsg); OutputDebugString(strDebugMsg); } if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { // Allocate a statement handle retCode = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt1); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { // Fixup the select statement retCode = SQLPrepare( hstmt1, (UCHAR*)(LPCTSTR)pRecordList->m_strSelectStatement, pRecordList->m_strSelectStatement.GetLength()); if(retCode == SQL_SUCCESS) { retCode = SQLExecute(hstmt1); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { retCode = SQLNumResultCols(hstmt1,&sColCount); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { if(sColCount > 0) { if(lColumnList.DescribeColumns(hstmt1, strExceptionMsg)) { if(lColumnList.BindColumns(hstmt1, strExceptionMsg)) { int i = 0; while((retCode = SQLFetch(hstmt1)) != SQL_NO_DATA) { if(retCode != SQL_SUCCESS) { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); break; } else { // Class to hold the result set. CTableColumnList* pColList = new CTableColumnList(); lColumnList.PopulateColumnListObject(pColList); pRecordList->AddColumnListRecord(pColList); } } } } } } } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } retCode = SQLFreeHandle(SQL_HANDLE_STMT, hstmt1); } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } retCode = SQLDisconnect(hdbc); } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } } retCode = SQLFreeHandle(SQL_HANDLE_DBC, hdbc); } } retCode = SQLFreeHandle(SQL_HANDLE_ENV, henv); We are at our wits end, not sure what to do next. Any help in sorting this out will be very, VERY much appreciated. Tag: reportviewer issue
- Next
  - 1
    - From and Thru Date parameters When I get those types of errors, it's usually from a dataset up the chain which automatically got a parameter slapped onto it by the IDE and is not getting the value from anything. You could search the rdl file in notepad to better find that specific section and dataset name, then go into the dataset and remove parameters from all areas: details, parameters tab, and in the designer, the query parameters toolbar button. It may also help to close and reopen the solution after this has been done to ensure there's no more sh going on from the IDE. Tag: reportviewer issue
  - 2
    - Case expressions may only be nested to level 10 This is a little hoakie, but here we go: Code Snippet declare @a int , @b int , @c int , @d int , @e int set @a = 0 set @b = 0 set @c = 1 set @d = 0 set @e = 0 select coalesce ( replace ( convert ( char ( 1 ), nullif ( @a , 0 )), '1' , 'A' ), replace ( convert ( char ( 1 ), nullif ( @b , 0 )), '1' , 'B' ), replace ( convert ( char ( 1 ), nullif ( @c , 0 )), '1' , 'C' ), replace ( convert ( char ( 1 ), nullif ( @d , 0 )), '1' , 'D' ), replace ( convert ( char ( 1 ), nullif ( @e , 0 )), '1' , 'E' ) ) Tag: reportviewer issue
  - 3
    - conditions in where clause when i try this i get the error message, where is of none boolean type Tag: reportviewer issue
  - 4
    - Stored Proc creation script in T-Sql OJ has come up with the something similar in the following thread. Brilliant. http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=2218957&SiteID=17 HTH! Tag: reportviewer issue
  - 5
    - Report Builder and optional parameters What Filter tab are you uys talking about I have RS2005 and I don't see the "prompt" option. Is this in the data filter section Tag: reportviewer issue
  - 6
    - Error - SQL Server requires Encryption On Thank you John, that was it. I apologize for taking so long to respond but my sales person is in L.A. and I am in Florida and with the long weekend we couldnt connect until late yesterday. Would love to know how that got set in the first place though. That was a tough one to find. Thanks again. Jack Tag: reportviewer issue
  - 7
    - Applying snap shot at subscriber from DVD on SQL 2000 Connect to your subscriber in SQL Server Management Studio and pull it there. Tag: reportviewer issue
  - 8
    - How can i encrypt or mask a column in the database You can find encryption information on Books Online. Here are a couple of links to get you started: http://msdn2.microsoft.com/en-us/library/ms189586.aspx http://msdn2.microsoft.com/en-us/library/aa337557.aspx My blog also has several encryption examples. If you get stuck on anything specific, post on this forum. Thanks Laurentiu Tag: reportviewer issue
  - 9
    - Maximum size of the SSIS String Variable? jwelch wrote: 4000 is the limit on expressions. I'm not sure what the limit is on strings. This is all true. Technically, I'm not sure there's a limit on the string variables. Though you can't really use that variable anywhere without the 4000 character expression limit applying. (Most of the time the variable is used in an expression SOMEWHERE...) Tag: reportviewer issue
  - 10
    - Enterprise Manager returns [MS Visual Database Tools] - The parameter is incorrect when returning all rows Yes you need to have service pack on client tools, that helps too. I do on all of my client tools too without any issues. Tag: reportviewer issue
  - 11
    - DataFlow Update? We have recently changed our data flow to update with an OLE DB command. It will update approx 3,000 rows. When I attempt to execute the entire package, it gets hung up on this data flow task. (The box turns yellow - when I look at the data flow itself, the boxes never turn yellow, and you do not see the row count.) We didn't think updating 3,000 rows would cause it to perform much slower. Do you think the OLE DB command is the cause I can execute that task alone and it will be done in mere seconds. Tag: reportviewer issue
  - 12
    - New Log or append? I think that the problem with your original script is that you are creating the backup command when you create the job rather than dynamically creating and executing the command when executing the job. Try the re-worked version below. Chris Code Snippet USE msdb IF EXISTS ( SELECT Name FROM sysjobs WHERE Name = 'jobDBBackupWedb_1Log' ) EXEC sp_delete_job @job_name = 'jobDBBackupWedb_1Log' GO DECLARE @cmd NVARCHAR ( 3201 ) SET @cmd = N'DECLARE @sql VARCHAR(8000) DECLARE @now char(14) -- current date in the form of yyyymmddhhmmss DECLARE @dbName sysname -- database name to include date-time-stamp SET @now = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(50), GETDATE(), 120), ''-'', ''''), '' '', ''''), '':'', '''') SET @dbName = ''Wedb_1_'' + @now + ''_.trn'' SET @sql = ''BACKUP LOG Wedb_1 TO DISK = '' + CHAR(39) + ''\\SERVER1\D$\SQLDatabases\Backup\WebEoc\'' + @dbName + CHAR(39) EXEC(@sql)' EXEC sp_add_job @Job_Name = 'jobDBBackupWedb_1Log' , @Description = 'Run Wedb_1 DB Backup Transaction Log Every 15 Minutes' , @Category_Name = 'Database Maintenance' EXEC sp_add_jobstep @Job_Name = 'jobDBBackupWedb_1Log' , @step_name = 'DB_Backup_Log' , @step_id = 1 , @Database_Name = 'Master' , @subsystem = 'TSQL' , @command = @Cmd /* Start time for the Transaction Log backups is seven and one half minutes after midnight to not conflict with the Full database backups run every 6 hours starting at midnight. The Transaction Log backups are to be run every fifteen minutes. */ EXEC sp_Add_JobSchedule @Job_Name = 'jobDBBackupWedb_1Log' , @Name = 'schedDB_BackupLog' , @Freq_Type = 4 , -- Daily @Freq_Interval = 1 , -- Each day @Freq_Subday_Type = 0x4 , -- Interval in minutes @Freq_Subday_Interval = 15 , -- Every fifteen minutes @Active_Start_Time = 000730 -- Start Time is seven and one half minutes after midnight --@Active_End_Time = 235959 -- End Time is next midnight EXEC sp_Add_JobServer @Job_Name = 'jobDBBackupWedb_1Log' GO Tag: reportviewer issue
  - 13
    - JIT Debug HELP See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at HP.CUE.Video.PlaybackControl.UpdateProgressBar() at HP.CUE.Video.PlaybackControl._ProgressTimer_Tick(Object sender, EventArgs e) at System.Windows.Forms.Timer.OnTick(EventArgs e) at System.Windows.Forms.Timer.Callback(IntPtr hWnd, Int32 msg, IntPtr idEvent, IntPtr dwTime) ************** Loaded Assemblies ************** mscorlib Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll ---------------------------------------- hpqimzone Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///C:/Program%20Files/HP/Digital%20Imaging/bin/hpqimzone.exe ---------------------------------------- hpqiface Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqiface/4.0.0.0__a53cf5803f4c3827/hpqiface.dll ---------------------------------------- System.Windows.Forms Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll ---------------------------------------- System.Drawing Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll ---------------------------------------- System Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll ---------------------------------------- hpqcc2 Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqcc2/3.0.0.0__a53cf5803f4c3827/hpqcc2.dll ---------------------------------------- hpqutils Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqutils/4.0.0.0__a53cf5803f4c3827/hpqutils.dll ---------------------------------------- hpqfmrsc Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqfmrsc/4.0.0.0__a53cf5803f4c3827/hpqfmrsc.dll ---------------------------------------- hpqtray Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqtray/4.0.0.0__a53cf5803f4c3827/hpqtray.dll ---------------------------------------- hpqovskn Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqovskn/3.0.0.0__a53cf5803f4c3827/hpqovskn.dll ---------------------------------------- hpqimvlt Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqimvlt/3.0.0.0__a53cf5803f4c3827/hpqimvlt.dll ---------------------------------------- hpqimgrc Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqimgrc/4.0.0.0__a53cf5803f4c3827/hpqimgrc.dll ---------------------------------------- hpqntrop Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqntrop/4.0.0.0__a53cf5803f4c3827/hpqntrop.dll ---------------------------------------- Interop.hpqcxm08 Assembly Version: 3.0.0.0 Win32 Version: 53.0.13.000 CodeBase: file:///c:/windows/assembly/gac/interop.hpqcxm08/3.0.0.0__a53cf5803f4c3827/interop.hpqcxm08.dll ---------------------------------------- System.Xml Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll ---------------------------------------- LEAD Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead/13.0.0.113__9cf889f53ea9b907/lead.dll ---------------------------------------- LEAD.Wrapper Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.wrapper/13.0.0.113__9cf889f53ea9b907/lead.wrapper.dll ---------------------------------------- LEAD.Windows.Forms Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.windows.forms/13.0.0.113__9cf889f53ea9b907/lead.windows.forms.dll ---------------------------------------- LEAD.Drawing Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.drawing/13.0.0.113__9cf889f53ea9b907/lead.drawing.dll ---------------------------------------- interop.hpqimgr Assembly Version: 3.0.0.0 Win32 Version: 53.0.13.000 CodeBase: file:///c:/windows/assembly/gac/interop.hpqimgr/3.0.0.0__a53cf5803f4c3827/interop.hpqimgr.dll ---------------------------------------- hpqthumb Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqthumb/3.0.0.0__a53cf5803f4c3827/hpqthumb.dll ---------------------------------------- hpqasset Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqasset/4.0.0.0__a53cf5803f4c3827/hpqasset.dll ---------------------------------------- hpqmirsc Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///C:/Program%20Files/HP/Digital%20Imaging/bin/hpqmirsc.DLL ---------------------------------------- hpqedit Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqedit/3.0.0.0__a53cf5803f4c3827/hpqedit.dll ---------------------------------------- hpqvideo Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqvideo/3.0.0.0__a53cf5803f4c3827/hpqvideo.dll ---------------------------------------- LEAD.Windows.Forms.DrawingContainer Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.windows.forms.drawingcontainer/13.0.0.113__9cf889f53ea9b907/lead.windows.forms.drawingcontainer.dll ---------------------------------------- hpqmdmr Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqmdmr/4.0.0.0__a53cf5803f4c3827/hpqmdmr.dll ---------------------------------------- LEAD.Drawing.Imaging.ImageProcessing Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.drawing.imaging.imageprocessing/13.0.0.113__9cf889f53ea9b907/lead.drawing.imaging.imageprocessing.dll ---------------------------------------- hpqimlib Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqimlib/3.0.0.0__a53cf5803f4c3827/hpqimlib.dll ---------------------------------------- hpqglutl Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqglutl/4.0.0.0__a53cf5803f4c3827/hpqglutl.dll ---------------------------------------- Interop.hpqvideo Assembly Version: 3.0.0.0 Win32 Version: 53.0.13.000 CodeBase: file:///c:/windows/assembly/gac/interop.hpqvideo/3.0.0.0__a53cf5803f4c3827/interop.hpqvideo.dll ---------------------------------------- ************** JIT Debugging ************** To enable just in time (JIT) debugging, the config file for this application or machine (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the machine rather than being handled by this dialog. Tag: reportviewer issue
  - 14
    - Displaying member name instead of key in query In the tools that I have used for getting generated MDX queries (Query Analyzer, Proclarity, Excel) the query always seems to show the key value instead of the member name. Is it possible or is there a query tool that will generate queries with the member name instead See example: [Organization].&[152551] Should read [Organization].[By Division] thanks, Andrew Tag: reportviewer issue
  - 15
    - Simple select statement gone wild!! Try: ... WHERE (People.BirthDate BETWEEN '19001001' AND '20071215') BTW, the result you posted matched correctly with the range you specified. Can you post some rows not matching the range AMB Tag: reportviewer issue
  - 16
    - Missing DLL during installation XP PRO SP2 I downloaded and installed SQL Server 2005 Express with Advanced Services (9.0.3042.0). The installation appeared to complete successfully and I looked at various options of Management Studio. After exiting, rebooting, and restarting Management Studio, I got the message, (paraphrased) Management Studio failed to initiate - terminating. After using Add/Remove to remove all installed components, I reran the installation. I got two error messages indicating that xpstar90.dll is missing. Did not see these messages during the first install. Log SQL0003_mycomputername_SQL contains these errors: Error Code: 17750 MSI (s) (94!58) [18:24:53:031]: Product: Microsoft SQL Server 2005 -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).. Refer to the server error logs and Setup logs for detailed error information. Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).. Refer to the server error logs and Setup logs for detailed error information. SQL_ERROR (-1) in OdbcStatement::execute_batch sqlstate=42000, level=16, state=1, native_error=17750, msg=[Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.). sqlstate=42000, level=16, state=1, native_error=14658, msg=[Microsoft][SQL Native Client][SQL Server]Failed to retrieve SQLPath for syssubsystems population. Error Code: 0x80074556 (17750) Windows Error Text: Source File Name: lib\odbc_statement.h Compiler Timestamp: Wed Jun 14 16:28:15 2006 Function Name: OdbcStatement::execute_batch@sysdbupg.sql@113 Source Line Number: 91 Log SQL0003_mycomputername_Core reported: Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 17750 Aborting queue processing as nested installer has completed Message pump returning: 17750 Log SQL003_mycomputername_Core(Local) reported: Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchMSDE2000" failed due to a precondition. Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run: Action: "UninstallForSQLAction" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchLibertySql" failed due to a precondition. Skipped: UninstallForRS2000Action Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis: Action: "UninstallForRS2000Action" will be skipped due to the following condition: Condition "Action: InstallRSAction was skipped." returned true. Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run: Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition: Condition "The Clustered SQL Server instance that hosts is installed." returned false. Running: ReportChainingResults at: 2007/8/11 18:27:5 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 17750 Error Code: 0x80074556 (17750) Windows Error Text: Source File Name: sqlchaining\sqlchainingactions.cpp Compiler Timestamp: Thu Nov 16 20:31:57 2006 Function Name: sqls::ReportChainingResults: erform Source Line Number: 3521 ---- Context ----------------------------------------------- sqls::HostSetupPackageInstallerSynch: ostCommit sqls::HighlyAvailablePackage: reInstall led due to cancel code received from cancel source: 29539 Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_DCHJL761_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0003.cab" Error Code : 2 Running: UploadDrWatsonLogAction at: 2007/8/11 18:29:5 Message pump returning: 17750 No other log contained a related error message. A third attempt to install resulted in a Failure to create database files. Tag: reportviewer issue

Gess Man

I am using the reportview in vb2005 to run a report that is on our report server. It just keeps says its processing and does not come up with any results. Any thoughts why this is happening and how I can fix

Top

Re: reportviewer issue

Dinesh Asanka

Check whether your data sets are correct. Some time data sets may be running without stoping.

Are you getting any memory errors

Top

Re: reportviewer issue

Gess Man

I am taking the sets from a report on the report server. The report on the server runs fine, but when I try to run it on the reportview it just keeps running and never shows any results

Top