Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: NickyJay
  • Content: Threads
  • Order by date
  1. NickyJay

    Workaround for mixed orientation on a report?

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

    SQL 2008 exclude parent records in results where multiple child records exist in 2nd table

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

    Exporting report to Word - text boxes resizing!

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

    Outlook 2003 - Meeting sent to others not on invite list!

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

    Pop up Message on deployed report

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

    SSRS - intermittent connection via vpn :(

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

    case statements returnin duplicate results.

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

    Recursive report based on manager of managers...

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

    Advice needed - looking for training course for variety of levels

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

    help with joining 2 tables - multiple fields on one relate to primary

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

    SSRS for 2008 Help Tutorials Advice!?!

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

    SQL 2008, Visual Studio and opeing project on multiple pcs?

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

    Convert date in Varchar field to datetime field - help please!

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

    Need to jump back to link clicked on page

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

    Recordset paging insied tabbed form?

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

    show record x number of times

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

    Printing from page with background but without headers and footers

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

    New to Flash, need to create database driven Page Flip

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

    showing date range in php calender

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

    Simple question - i think!

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

Part and Inventory Search

Back
Top