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

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

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

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

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

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

Hi all Wonder if i can make enough sense of this for anyone to help! I have an admin page with a list of links to view careers leaflets. From the list the user has the option to open the leaflet, print it, delete it or tag it as completed ready for viewing on the main website. The page...

Hi all, have just implemented a simple recordset paging element to a section of a form i have that is split into div's that are displayed via a tab across the top of the page. Problem is, now when i click to view the next lot of records, the page always refreshes displaying the first "tab" of...

Hi all Simple question , i hope! I have an events database that i am producing tickets from. I want to be able to loop an event record x number of times, showing the count on each instance - i.e. ticket no. 1, 2, 3, etc. I can get the record to output the first time, but for the subsequent...

Hi all, I realise i'm asking two things here, but they relate to the same page! output from my database is to produce a poster, all details show ok and my css is fine, except when i acctually print. I get the headers and footers and no background! Has anyone done this kind of thing before? I...

Hiya, Can anyone point me in the right direction of a tutorial or something that can show me where to start with this? I need to create a guestbook in flash that has a page flip, have downloaded one that i thought would fit the bill from macronimous but not as customizable as i need and it...

Hi All, i have a calendar app on my site that displays a users diary of events, i've hit a problem on how to get this to show a block of dates with the same event - holiday for two weeks, the user would have to add this event to each date individually instead of just a from and to date. I have...

Hi All, i have a form that outputs a record from my database for editing. I have a couple of dropdown options on there and want them to display the CURRENT value in the database record so they can alter it if needed. Im able to do this no probs in Coldfusion but am struggling to transfer the...