Search results for query: *

I already have a crosstab with the columns and a total at the right (SUM). I just want to add another column AVG. Exactly the same as this old thread thread149-766735. That thread is around 4 years old and possibly using an older version of CR, so I'm wondering if anyone has any brilliant tips...

I am hunting down a solution which works for this seemingly easy problem, but is massively difficult. I have seen the question asked on several forums, including here on tek-tips but nothing is working for me. I have a CR invoice layout. It has a few page header sections with company logo...

As a general rule, I like to keep my databases reasonably efficient by running a Maintenance Plan to Rebuild Indexes and Update Statistics. Generally do it weekly. I was forgetting about FILL FACTOR, and the default for the instance is set to 0, which is what the Maint Plan job uses, so I...

Been a looooong time since I've posted here! I am a user & vendor of a ERP/financial application. The developers use Crystal runtimes as the reporting engine, so any hardcopy output is done via Crystal. Just about all reports display as print preview first, inside a CR Viewer window. A new...

I have a trigger which needs to update a field into my table only for an INSERT. My trigger reads thus... CREATE TRIGGER MyTrigger ON MyTable FOR INSERT AS DECLARE @SerialNo varchar (20) --Get the 6 char date SET @SerialNo = CONVERT(char(20), GETDATE(),112) SET @SerialNo =...

Simple question but I don't know the answer... I'm just inserting a picture into a report. It's a company logo, but it's a bit too big. I just want to proportionally resize it dy dragging a handle, but it doesn't do it proportionally. I've tried dragging with Crtl & other keys, but hasn't...

Hi all, I have a stored procedure which returns 1 or 2 rows. No more than 2. I have a table which I want to pass a value to the stored proc for every row in the table. My table only has about 30 or 40 rows. Each time the stored proc runs with the current table.field value, I want the output...

Hi all, I have a stored procedure which returns 1 or 2 rows. No more than 2. I have a table which I want to pass a value to the stored proc for every row in the table. My table only has about 30 or 40 rows. Each time the stored proc runs with the current table.field value, I want the output...

Aim: To get a customer price list. I have a stored procedure which finds a price for an item given a customer and itemID. All items are grouped (not in Crystal, I'm getting to that soon) by a description. Lets say the items are screws so I have "Coach screws", "Wood screws", Metal screws"...

Gday all, I am writing a stored procedure which gets a value from my database & pops it into a variable @MyVariable (varchar(20). I need to run different stored procs based on the value of @MyVariable. The stored procs need values passed thru to them which I already have set further up in my...

I have a few parameter fields. They're not doing any record selection, not a part of any formula. They just merely display the entered value in the report, in this case in the report header. I create the parameter & stick it in the header section. I run the report from my application, but I...

Gday, I install MSDE at many clients of mine. As part of the database I'm creating, it is essential that I get data from another database (non-SQL, but a ODBC DSN exists to get it). Ideally I use the DTS Import/Export wizard which is excellent. Then I need to schedule the DTS package for a...

Gday all, I have 4 address fields in my customer table. The last 4 characters in either addr2, addr3, or addr4 is the postcode. I need to get a single postcode field . Sample data: addr2 addr3 addr4 SuburbXX 1234 Level 12 14 Main St SuburbYY MA...

Gday all, I've just been browsing this forum but cvan't find the appropriate answer. I need a view to combine multiple rows into a single row. My table is thus: Key Field 1 AAA 1 BBB 2 CCC 2 AAA 3 BBB 3 AAA 4 DDD 4 CCC and need it...

Gday all, Much has already been asked and explained about why a DTS package can run successfully when manually executed, but fails when scheduled as a job. The bottom line always seems to be a permissions issue, whether it be the context of the SQL Agent service logon account, the user who...

Gday all, Probably the wrong forum...I have a proprietary database with proprietary DSN software which creates a User DSN. No option to create a System DSN. I have logged in to my PC as an account which SQL Agent is using to log on with. It's not logging on with Local System. This allows me...

Gday all, Is it possible to change the owner of a DTS package? cheers Danster

Gday, I've changed the datasource of my report so it is pointing to a different database. When I refresh my data, it is still showing the data from the old datasource. Looking in the Show SQL Query, it is pointing to my old database, but when I look in Database Expert it's pointing to the new...

Gday all, I'm writing a long formula which needs to be on a single line. What is the character in the formula editor which will allow me to continue the code on the next line? Or is their a word wrap function like Notepad? Thanks

I'm logged into my XP Prof PC as local administrator. The TCP/IP Properties button is disabled. How to re-enable? It's hard to diagnose network connectivity issues when we can't even get into the IP Properties!! cheers Danster