Search results for query: *

Firstly, thanks for time to look at this. I'm painfully aware of my VBA noobness right now so its much appreciated. Now for some context. I have a main form with multiple pages. The first page has search functionality, the search results are displayed in a subform. The functionality I am...

Hi All, I've got a strange problem (at least i think so). I'm importing the contents of a text file to a dataset, and the datatype of the destination column is changing from string to decimal for no reason that I can determine... When I pass a text file with 13 rows, the datatype of the first...

Hi All, First off, thanks for taking the time to educate me. This is my first foray into VB.NET, so I really appreciate your constructive feedback. I have a test file that I want to parse, segregating the first 13(ish) chars of each line from the remaining text in the line. eg...

Hi Folks, I've got a query that I'd like to create as a view... its necessary for it to perform some aggregations in some temp tables - - how can I go about this?? I've tried create tables, temp tables and table vars with no joy; I guess I want to know ifs its possible, and if so how? :)...

Hi Everyone! First of all, thanks in advance for the help! This should be an easy one, but I'm at a loss. I want to 'toggle' a toggle button based on results from a recordset. Heres the code I've been attempting to use: Select Case objRecordSet("PSsentBy") Case "Neil Watts"...

Hi Everyone, Just a quick 'n easy question today... What does placing " N " in statement do? eg. INSERT INTO Northwind.dbo.Shippers (CompanyName, Phone) VALUES (N'Snowflake Shipping', N'(503)555-7233') Thanks! Casey.

Hi, I’m hoping that I can get some guidance :) I have a table that I want to be in sync with a view in a separate (SQL2K) DB. I’ve never played with triggers, or had much to do with implementing referential integrity in SQL2K - - I’m pretty much ignorant! There seems to be several options that...

This is really weird... somehow security problem, but I don't know what. Have a several PCs that receive a subscription email from RS. All but one receive the subscription email ok. The one that doesn't receives all the data from the report, with absolutely no formatting what-so-ever. No rows...

Hi Folks, I'm trying to set up an ODBC connection in MS Reporting Services to an Excel file. The ODBC connection works from my client, but when I upload the report to the server to run I receive the following errors: An error has occurred during report processing. (rsProcessingAborted) Get...

Hi, I'm hoping to import some data from a Excel workbook to use in a report I'm developing. Is it possible without creating custom extensions? Thanks in advance! Casey.

Hi, Out of the blue I have lost administration rights to RS Report Manager. I can no longer access several reports (others do work). When I connect to the Report Manager the GUI is displayed, but I can't access all of the usual tabs (ie. under the properties tab I can only see the 'General' and...

Hello! Firstly - thanks for taking the time to read this post. The problem at hand is this. I have a large dataset returned by my SP that I want to filter to return a smaller subset of the data (for the purpose of creating multiple data regions). In RS BOL the method for creating a filter is...

Hi All, When trying to refresh the data in a excel pivot table based on an AS cube, it fails with the error msg... "Cannot connect to the server 'XXX'. The server is either not started or too busy." The excel file was originally created on the machine which the AS server sits on and was...

Hi, Complete newbie! I trying to customise the appearance of a couple of reports in MS Reporting Services (sp2) using its capacity to accept VB.NET expressions... I thought what I wanted to do was ridicously easy, but its not working! I have a resultset column that is either "EXPORT" or "NZ"...

Hi, I'm having huge problems with the run-time of a stored procedure from RS Designer (and from the server when the report is uploaded). I have a SP with about 6 parameters. When executed from QA the SP takes less than a second to return a result-set of about 1500 rows. When running the SP...

Hi, I'm currently in a bit of strife. Yesterday, for no apparent reason, our SQL Server crashed - about 3 times in the space of 15 mins. Today, the server crashed again after having been up overnight - - right in cue with the scheduled execution of the SQL Agent job. Coincidence - maybe, but...

Hi gurus... anyone come across this one yet?? I'm querying an ODBC data source for my report. The report runs fine in V.S., but once I import the report into report manager (hosted on a separate machine) the report fails to generate with the following error: An error has occurred during report...

Help Gurus! What options do I have at my disposal to identify the physical row location of a row in a table? Thanks in advance, Casey.

Hi Folks, I've added a data source as a linked server - - but I'm having problems figuring out how to query it. Heres the set-up of my linked server... SRV_NAME: CBA_linkedINMASTER SRV_PROVIDERNAME: MSDASQL SRV_DATASOURCE CBA ... I've tried using a linked server name, but that...

Hi Guys, As above - - I have an ODBC data source that I want to use in a query using T-SQL without having to import it in using DTS. Is this a can do or a can't do? Thanks in Advance!! Casey.