Search results for query: *

Hello all, I have a notes table that records every note for an account as a separate entry. I want to create a view that has all the notes in 1 field to make it easier for reporting. So I have: Note ID Acct # Note NoteDate 1 555...

Have it working. Thanks for the help!

I get the following error when doing that: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "B.Status" could not be bound.

I have a folder that includes very detailed file names. Each day I need to look at this folder and populate a table by parsing out the file name and looking at the owner, date, pages, etc. As a relative newbie to SSIS, I'm unsure of how to do this. Any steps people could give me in getting...

I have account transactions grouped on Account Number in my report. There can be anywhere from 1 to 10 transactions for each account, with different dates. I want to show all transactions for any account that has at least one transaction in the past week. I'm trying to come up with the best...

We're using Business Objects Enterprise 11. Is this an upgrade I will have to look into? Do you know of anywhere I can learn more about packages and publications?

I'm running into 2 issues currently, generating blank reports and sending them to clients and putting multiple reports in an email for clients. Any solutions that involve Crystal or another application would be welcome. My first problem is that we often have reports where no data qualifies...

I have a report I've created on legal size paper. When I run it and export it to pdf through the designer, it exports perfectly. However when I generate it through Enterprise and export it to pdf, it ends up on regular letter sized paper and truncates half of my report. Does anyone know how I...

I have a report I'm creating that the users want to drill into. However, they are very specific about what they want to drill into. The report lists clients and Ageing buckets, so looks like the following: 0-30 Days 31-60 Days 61-90 Days Etc # $ #...

I have my dates in the format YYYYMMDD. I need to calculate the datediff. I have always converted in the past to do so, but am looking to find out if there's a calculation I can use in this format. Thanks!

SOLUTION: (DT_STR,4,1253)YEAR(GETDATE()) + RIGHT("0" + (DT_STR,2,1253)MONTH(GETDATE()),2) + RIGHT("0" + (DT_STR,2,1253)DAY(GETDATE()),2)

I'm trying to create today's date as a variable in the format YYYYMMDD. In my expression I'm getting errors with everything I try. I've tried: cast(convert(varchar(12), getdate(), 112) as int) select cast(convert(varchar(12), getdate(), 112) as int) select FullDate from dim_Date where...

I'm just putting it to a folder with ftp in the name. The server this report is running on (scheduled) has full rights to the server it's writing to. I can get to it without a problem from the server when I manually go in and try to write to the folder.

I'm running into an issue when I try to write a report to a folde ron my network. I've been working with the network guy and my permissions are fine, yet I keep getting an access denied error. One thing I do notice though, is the path I am trying to write to is...

I have a report I've created that has a command for one of the tables. This command is not joined to any other table and holds 2 fields: CurBusDay BusDayinMnth I want to use these fields throughout my report, but I was told to create a static variable in the header and use that in the...

I am trying to concatenate the last 5 notes on each account in my database into one string field. My DB looks like: Acct# Note RowNum 1 Note 1 1 1 Note 2 2 1 Note 3 3 2 2 Note 1 1 2 2 Note 2 2 3 3 Note 1 1 4 4 Note 1...

Hello, I'm pretty new to this DB2 SQL and am having trouble putting together the code for the following items. I need to grab the first and last of the previous month in the format YYYYMMDD. If anyone has this lying around somewhere or could give me some quick insight, I'd appreciate it. Thanks!

I'm looking to get a listing of my report distribution. I've done this before through query builder, but I can't for the life of me find the query builder now. Can someone walk me through the steps of finding it? Also, I've read that it's under samples, I'm wondering if I somehow hid it? Any...

I worked through it. No need for replies now!

I have a huge master package that runs 40 packages daily. I want to add a package, but only have it run on Mondays. I know I need to create a SQL task and a variable somewhere, but I just can't get it to run correctly. Would someone walk me through the steps of creating this the right way...