Search results for query: *

Hi, I have a form that i'm trying to recreate in SSRS 2008 for our users, the form is 11 pages, with 5 pages in the middle of the report being landscape, the rest are portrait - due to a set of tables in the landscape pages. I've searched and found that SSRS doesn't support mixed orientation...

Hiya, the code has ben auto written in SSRS 2008, so where i had originally put left outer joins it seems to have swopped for right outer?!?!?? didn't spot that until you've mentioned it. As for the create table stmt, i didn't create it and its on a hosted database that i just write reports...

Hi all, hope someone can help! I have a query to look for duplicate records in our database. my duplicate query looks for any records that match on foename/surname/dob and ouptuts address details from the main table, then pulls out an extra reference from a 2nd table. My problem is that if a...

To add to my last comment - i commented on the post from the link supplied by DaveInIowa and since got a response that there is a service park released that is to cure the bug - Service Pack 2. I'm in the process of requesting it to be installed on our system (unfortunalty i work on a hosted...

Hia, many thanks for this - although it doesnt fix it it at least means im not imagining it, lol! I noticed that my report does this even before i add placeholders... will see if i can add that to the bug case Thanks again NickyJay Designs - for quality canvas images from your photos...

Hi Guys additional to this, i have also removed the padding that seems to be added by default to textboxes - now set to 0pt for all settings, and i have created a blank report with no datasource, therefore no possibility of the data causing the line wrap - my report STILL manages to alter the...

Hi All, I have a report in SSRS that replicates a form that is used by our database users, it needs to mimic as closely as possible with textboxes that are ediatble once exported to word. it all looks fine until it is exported - word seems to render the report oddly and adds space between...

Hi All, wonder if anyone has come accross this before - i sent out a meeting request to a member of staff in one office. I received a response 5 times - 4 of which it appears came from other members of staff on behalf of the invitee. It turns out the invite went to everyone in the office...

Hi, i wonder if this is possible? Basically i want to display a message to the user when a report is loaded up that they can then click away. no parameters on it, just a simple message. Is this possible? i have seen posts that suggest having a html page that is used as a pop up, but we dont...

Hi All, I'm not sure if this is the right place to ask this, but i'm stuck for what to do next. Myself and colleagues access a remote sql 2008 database server via a vpn connection through our employer's network. I have been assured by the it department that all connections have been allowed...

Hi all, in the SQL for my report i have used several case statements to display specific results as Y or N in 5 different fields. My problem is that where a record has a yes in more than one of the fields, that record is output twice or more according to the number of Y's. the reuslts are...

Hiya, Many thanks for this. I'm using 2008. I had a look at the CTE but got a bit baffeled - mainly in that i'm accessing a database that i can't write anything other than reports against so wasn't able to run the example. :( I have mananged to create myself a query but not have issues with...

Hi all, Hope some one can help me with this. I have a table of contacts, each record has (for simplicity) ContactID, Name, ManagerID. I am able to get staff that work for a manager, and have this working as a drilldown reports, but need to arrange it from the top manager level, where a top...

Hiya to you both, and thanks for responding :) I went through the w3schools sql test with my colleagues, it does cover part of what we need but as its focused specifically on sql and not any sort of theory of databases, it's not quite what i need, and as for the M358 couse at the OU, i did this...

Hi all, Happy 2010 to everyone! I have been tasked with identifying training for myself and 3 colleagues and am a little lost! A bit of background first - I have 5 years DBA experience but no official training, I've used MySQL, Access and SQL server 2000/2005 in that time and am experienced...

Perfect, i had something almost identical from continuing my google search :) Many thanks for your help - think i need to get em on a training course asap! Nicola

Hi All, I hope someone can help me. I have a table of clients that stores in 4 fields their jobchoices - each client has upto and including 4 areas of work. I have a vacacny table with records the job type of a vacacny recorded. I need to list all vacacnies for a clients where any one of the...

Hi All, Just started using the visual studio 2008 module - report writing in particular, and have a few queries. Can anyone point me in the write direction for some tutorials or help on writing parameters? I have to add several to a report for users to be able to filter the data BUT need...

Can anyone help? Using visual studio 2008 on 4 pcs to connect to a central db server, have also got a shared report folder for our report projects to sit in. If one person has opened a project, none of the other pcs seem to be able to load the report up - is this how it works? Even when the...

Hi all, I have two fields in my table, one is a varchar field populated with dates input via a coldfusion page (there were issues with the page inputting the date in the correct format to a datetime field so this was a work around!) The format is dd/mm/yyyy. I have a second field that a query...