Recent content by jconway

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...