Search results for query: *

Hi there, I'm having difficulty getting a query to work. I have a query which returns a set of infringements. I'll explain: I work for an auditing company and if you fail at an item for more than two years you fail your audit. The results set I have is a query based on multiple table joins...

Hi There, I've got a problem with cascading combo boxes. First some background: I am using Access 2003 to write a little helpdesk app. I have a Table and form (tbl and frm Helpdesklog) which lists the bulk of the users details plus descriptions of the various requests. I have a second...

Hi There, I feel this must be a common problem yet I can't find much about it here or Google. I would like to chart some information based on a date field. Basically I want a running total per month. It's a chart of 'assessments'. X is the month, Y is the value. I have extracted the month...

Hello, I've sorted my query out toget me a bunch of records that are 16 months or older. Now I need to decide know which one is hhe last one. This is for a DB which records asessments. Thus you may have an entry for one user but he may have been assessed several times over the last few...

Hi There! I'm not sure if I am posting this in the right place. I have requirement to add a function that is supposed to look for dates that are 16 months or older in the past. I hate to say this but I cannot get my head round the date functions for this. This is what I tried...

Hi, I've got a question which seems to be quite simple but I cannot seem to get it to work,. I'd appreciate it if anyone can post any suggestions. I have a table (SR). There are a number of columns, of which, I am only interested in CompanyName, LogDate and Requests. What I want to do is...

Hello! I've a workbook. There are a number of worksheets. Each worksheet relates to a specific country (austria, Belgium, Croatia etc). I use VBA to plonk data on each sheet, however (and this bit varies from month to month) there is never data on all worksheet - this is expected. What I...

Hell guys, I've written a bit of VBA that takes the input from a multi-select, creates a string (the SQL query) and now I want to pass it to the server for processing. How do I do that? It doesn't seem to be too well documented. I prefer the SQL approach to the query builder as I can control...

Hi guys, I have a workbook that contains a number of worksheets. The first worksheet contains all the data that I want to split off and put into the other worksheets. The column that I want to use on data is "Country". So I imagine that the code will look something like this: Get list of...

Guys, I am running up several workbooks, each of which has several worksheets. Each of the worksheets has a table on it that I want to format with out having to go in and repeat the same keystrokes every single time. I've recorded a macro (and subsquently edited it to make it run better)...

Guys, I have a wee problem. I am using Excel 2000 and I want to get data using a stored procedure on a SQL server. I've read the help and it doesn't make any sense. I can find the stored procedure (going to file -> execute SQL....), I then paste the SQL into the window which proints...

I'm experimenting with an export to Excel. Previously I got a column header backgrounds in the cells on the spreadsheet to be given a colour - on the CR they still have the colour. When I export this has stopped happening. I can't figure out why ...

I'm trying to add a pie chart to a crystal report. The data I want to add to the pie chart is the grand total however I don't appear to be able to do this. Has anyone else come across this? If you have how did you get round it.

Guys, I need your help. I have several large spreadsheets (11 to be exact) which I need to prepare prior to distribution to a client. The problem is this. I need to split the large worksheet down to a number of smaller worksheets based upon criteria in the the large sheet. The first 2...

I'm testing a report that is to be exported to Excel and from CR 8.5 and I have a strange problem. I suspect that there is an issue with the paper size. The report is currently laid out on A1. When I export to Excel half of the columns disapear. Has anyone out there had the same problem?

I have a report (not a very complicated one either) that develops a really odd formatting problem when you export to DHTML. The details section has a formatting formula in it to alternate every 3 records as silver or white, when it is exported to DHTML a thin white line appears in the middle of...

Guys, I need your help. I've been running some reports based upon stored procedures in MS SQL server. The problem is that a new parameter has been added to these stored procedures and when I refresh the data (get prompted for new values) the report doesn't have them listed in the stored...

Hi guys, I'm relatively new to Crystal Reports and have spent the last wee while searching through the web for help converting strings to dates. I'm using CR 8.5. The dates look like this: "2003-07-11 09:22:00" [they are of the string type]. Other entries for the the column are...