Hello Vladen,

I was testing your code. Where did you get the Deleted and Inserted tables from?

Thanks!

Hello SSRS Dev,

Thank you for your suggestion but the iif statement does not work in the Visibility expression. It still shows that empty cell.

Any other suggestions on how i can...

To reiterate my example:

NAME1

ADD1

CITY1

STATE1

ZIP1

NAME2

CITY2

STATE2

ZIP2

NAME3

ADD3

STATE3

ZIP3

For this given example i want the rows in the output to show like this:

NAME1

ADD1

CITY1

STATE1

ZIP1

NAME2

CITY2

STATE2

ZIP2

NAME3

ADD3

STATE3

ZIP3

Thanks!

Hello Nigel,

Thanks for you reply, but what do you mean by exclude it from the data set. I was hoping there would be a visibility option where i can may...

Gsquared your suggestions sounds wonderful.

But either way human intervention would be needed periodically to track holidays.

i wish there was some way of eliminating that.

I was thinking about writing a function with exception, where i can set the time/day start and end.

Any thoughts on this.

Hello,

A simple example to explain what i am trying to achieve is:

Example:

This is how a sequence would look in ssrs:

1

2

3

4

5

6

7

8

9

10

And this is what i am trying to achieve:

1 ...

Thank You! It works perfect!

Tried doing a variety of things but it does not work.

Example:

1. SELECT LEN(cast(CdLstName as char(30))) FROM dbo.abc

2. SELECT DATALENGTH(cast((CdLstName) as char(30))) FROM dbo.eCapDetail

Thank you for the quick reply Dan. I do have some experience in SSIS and SSAS however never quite tried to convert anything from ms access to sql. Well i...

Hi All,

I am using SP 3 and i am still getting the same problem.

This is the error i am getting:

"Unable to cast oject of type 'Microsoft.Sqlserver.Management.Smo.SimpleObjectKey' to type

'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'.(Microsoft.SqlServer.Smo)"

I added a variable for the file path and called it in the for each loop container.

Hi Emma,

It is indeed possible mentioning the file name in Collection in the foreach Loop editor.

Hello,

The expression is working and everytime i run the data flow i do see a new file come up with the current date. Now i have placed this data flow...