March 6, 2006 at 4:57 pm
I've created an Excel template with a graph that I use to create a report once a day from my database.
The issue is that I need the data to start printing below my graph and under my heading. I noticed that if it starts inserting new records in the line where its no data....In the beginning I used some test data and got the graph working, but if I deleted the text without "moving the cells up" on delete the DTS inserts the data on the line below where I had my data before deletion (did that make sense?)
So now I got everything working except for one thing. I got my header on line 40. Line 41 got nothing in them...I deleted that line over and over, but my DTS always start at line 42 which makes the graph calculation one line short.
Does anyone know a way to force DTS to start on a certain line, or how do we ensure that the line is empty. Can I check the source code of excel somehow?
thanks for any help on this...
March 9, 2006 at 8:00 am
This was removed by the editor as SPAM
May 8, 2006 at 7:36 pm
What I guess i'd try is a second sheet in the workbook. Load from DTS to that second sheet and have a region in the final sheet that displays the appropriate cells from the second sheet.
Let's say you wanted c1 to display the first field from the DTS load into sheet 2. Set C1 as "=sheet2!a1"
If you've looked at the other Excel topics here, you know you can create sheets and via SQL tasks on your Excel connection.
HTH.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply