Search results for query: *

Hi All, I searched the forum and didn't find this question being asked, so I hopefully it hasn't been yet! I'm relatively new to Teradata (most of my database related work has been done in SQL Server 2000/2005/2008) and was wondering what the best place to get started would be. I've done some...

Hi All, We're using Filemaker Pro and Filemaker Server for a variety of different databases where I work. We're also taking advantage of the external authentication features of Filemaker so that we can get single sign on for our Windows machines (we use Active Directory too). We recently...

Hi All, I've been asked to do some try and find a solution to a printing problem we've been having here (and from what it sounds like, it's a problem everyone's dealing with) - postal image transfer. The envelopes go out fine, but once the constituents get them, they're smudged or the letters...

Hi, First, thanks for any help I get in advance. I have been playing with Instant Web Publishing. It's pretty cool, and I've been playing with the Open URL script step to jump between database files. I was just wondering - it seems like the default behavior for this step is to open the link in...

Hi All, First, thanks in advance for any help I may receive. I have a database full of job applicants and the application process consists of several steps. My boss has asked me to put together a form that will allow the HR people to track this process using FileMaker Pro. I put the form...

Hi All, I was checking out some of the documentation tools for Crystal Reports (Report Miner and Report Analyzer) and just wondering if anyone had used either product (and if so, what did you think of it?). I'm also considering making up my own app in Visual Basic - has anyone given this a...

Hi All, I'm creating a web application using JavaScript and have created a function that returns a recordset based on the contents of one of the parameters - a SQL statement. To get the recordset to work properly after it's been returned from the function, I've had to leave the database...

Hi All, I'm creating a web application using Javascript and have created a function that returns an recordset based on the contents of one of the parameters - a SQL statement. To get the recordset to work properly after it's been returned from the function, I've had to leave the database...

Hi, I have an Access database that serves as the database for a website. It is an Online Community type website, where users can update their information, search for other users, etc. Each morning, a data entry person will come in, run some reports (in Access) and get a list of all the...

Hi All, This is more of a general question but I was just wondering if anyone had read any books on general report design (things like how one should layout data, what elements to emphasize, repeat, etc)? If so, can you recommend any? I am finding that at times, my reports, although they...

Hi all, I have an Access database that is password protected that I need to update every night. I want to use DTS to do this, but was wondering how I could set it up so that I only update certain rows, how do I go about this? It looks like, at least on the surface, that the only thing I...

Hi, I'm having issues with a database frontend (connects to a remote SQL Server DB) that uses IIS to 'present itself' (all of its pages are done in ASP/HTML). We run reports through this package, in PDF format, and every so often a user will not be able to delete an old report and/or the...

Hi, I have a SQL Server 2000 box that is attempting to connect to a local Access 2003 database. When setting this database up as a linked server, where do I fill in the credentials? This database is not set up for multiple users; it is just password protected. Thanks, Doc Tree

Hi, I'm working on a report that will be used to print a set of 3.25 in by 4 in labels (6 labels per page). There's approximately 1 inch of pre-printed text at the top of each label. To account for this text, I have added an additional section (Detail A) above my initial data section...

Hi, I have a report that lists people according to their country. I have given the country its own group, and due to the way the report is set up, I have put the person's name and address in the details section. For some countries, there is only 1 person, and at times, the report will put the...

Hey All, I'm a newbie when it comes to FileMaker and have been recently inherited a database where I work. One of the forms has a text field that handles variable length strings, and when the text wraps, the size of the field does not grow accordingly. How can I go about setting up the field...

Hey, in my office I have several users who export from our current report writer (R & R Report Writer version 6.5.x) to Excel, and then use that data to do a mail merge. The cool thing about this is that the field names were exported (in the first row) along with the data. I've tried to same...

I'm trying to print a report 3 times on a single page (its a receipt type report), and was wondering if this was possible in Crystal, or if I should just duplicate the report 3 times (recreate all the sections, place the appropriate fields in them, etc). Any help/advice is much appreciated. Doc...

Hi, I'm trying to write a query that will return the list of all stores that have had a specific type of sale 2 days in a row. For example, if store x sold 3 red dresses yesterday and 2 today, I'd want it returned, whereas if it'd only sold 3 yesterday I wouldn't care. I've tried using a...

Hey all, as usual, thanks for any help/advice. I am going through an old application I built in Access 2000, which relied heavily on VBA. I'm moving a lot of the functionality to Access (hey - I'm a newbie, its ok to reinvent the wheel, right :) ), and have a question regarding constant...