You searched for the word(s): userid:666354

More Search Options

RSS Available

• Re: Reporting Services 2005 Date format Bug

  Ah that's great, thank you very much - that explains why it works on some computers and not others. Thanks for taking the time to reply :) Dom

  Posted to SQL Server Reporting Services (Forum) by dominicshaw on 4/24/2008

• Re: Missing Data in a Report

  Thanks to those who took the to read through all this, and to Alex for his suggestions - I've found out why it was happening. The report groups on surname, so the missing records were when the surnames were the same. I've changed it to group on the identifier for the order and now everything works. I feel quite the idiot and hope that if anyone else ever hits this they skip all the rubbish I've been thru to find out what caused it! Thanks, Dom

  Posted to SQL Server Reporting Services (Forum) by dominicshaw on 4/14/2008

• Re: Missing Data in a Report

  You can have the whole thing! It's nothing too clever. Excuse the naming conventions - i take no responsibility SELECT tblUniversities.UNName, tblOrders.ORAdditionalGownMaterials, tblOrders.ORDateTime, UPPER (tblOrders.ORLastName) Surname, UPPER (tblOrders.ORFirstName + ' ' + tblOrders.ORInitials) Firstname, ISNULL (ORAddress, '' ) + ' ' + ISNULL (ORCity, '' ) + ' ' + ISNULL (ORCounty, '' ) + ' ' + ISNULL (ORPostCode, '' ) + '

  Posted to SQL Server Reporting Services (Forum) by dominicshaw on 4/11/2008

• Re: Missing Data in a Report

  Hiya, Thanks for your reply. I'm afraid there are no nulls, and no TOP command. The recordset is as follows: University of Brighton 1 2008-04-09 00:00:00.000 WHITE ELIZABETH EW 26 **** 0 1 0 1 0 1 Bachelor of Science (B.Sc) 5' 4 2008-07-29 10:15:00.000 34 21 1/4 #fbb565 33.00 University of Brighton 1 2008-04-09 00:00:00.000 WHITE NICOLA H 13 fryern close **** 0 1 0 1 0 1 PRDN (Pre Registration Diploma in Nursing) 5' 6 2008-07-30 15:15:00.000 32 21 1/4 #fbb565 33.00 The first one shows

  Posted to SQL Server Reporting Services (Forum) by dominicshaw on 4/11/2008

• Missing Data in a Report

  Hi everyone, I have been working with RS for a couple of years now and this is the first time I've had this... I'm probably being stupid but I can't see what it is. The problem is that data is simply missing straight out of the report. I am working with a relatively simple report - one page per record in a list control. There data returned is nothing complicated - a few tables joined together. If I run the data in the data tab, I get 112 records. If I watch what is happening in SQL Profiler

  Posted to SQL Server Reporting Services (Forum) by dominicshaw on 4/11/2008

• Re: Reports show up blank, there should be data

  Hiya, Some basics to try; have you tried running profiler and checking what is actually being run by report server? And ensured that its the same database you are running it on? RS should never return different data to what you get when you manually run the SP - and ive never seen it do so. Check out profiler (in the tools menu on management studio) and look to see what is really happening. Dom

  Posted to SQL Server Reporting Services (Forum) by dominicshaw on 3/19/2008

• Re: Reporting Services 2005 Date format Bug

  Hi Mark, I have this same (or very similar) problem - when I deploy my entirely british report (set in parameters, set on the db, set on the server), the report parameter date time picker that is shown to the user is in american format. My client has complained about it but there doesn't seem to be anything i can do with it - if i format it then it is a string type and therefore errors, but if i just leave it CDate'd then it comes out in american format. It doesnt seem like there is an choice

  Posted to SQL Server Reporting Services (Forum) by dominicshaw on 3/19/2008

• Re: Create Cookie With Keys Using GetAuthCookie?

  Hiya, The user should remain logged in as long as when you create the cookie you set the isPersistant parameter to true. As for added the user ID to this cookie - I don't think you can do this. You can add other, none formsauthentication, cookies and read from them instead - or simply add it to the session and read it from there as and when you need it. Cheers, Dom

  Posted to Security (Forum) by dominicshaw on 10/2/2006

• Re: Access denied

  Hi Jay, We recently needed Impersonation to do something very similar - writing files to a network share. The ASPNET user account couldn't do it so we turned Impersonation on for that folder of the application. However, in our application, the connection string was stored in the registry on the server, and generated (too often, I'm sure) by reading from the registry and creating the connection object. The user that we were impersonating, however, did not have permissions on the registry on

  Posted to Security (Forum) by dominicshaw on 10/2/2006

• Bouncing Forms Authentication

  Hi everyone, I am having a problem with a ASP.net 1.1 web application. First some background: The app runs forms mode to handle the authentication. In web config it reads: < authentication mode ="Forms"> < forms loginUrl ="login.aspx" name ="adMyAppAuthcookie" timeout ="60" path ="/"></ forms > </ authentication > The login routine simply verified the login details with the database and creates the authorisation cookie as appropriate

  Posted to Security (Forum) by dominicshaw on 10/2/2006