Recent content by jjefferson

Create a ForEach Loop Container. Set your "collection" property to xxxxx_.* Then put all your processing within this container. It will pick up each file matching the collection pattern and put it through the tasks.

If you are able to modify your dataset query and it is acceptable to have a space where this CrLf is in your data, you might also try something like: REPLACE(yourColumnName, CHAR(13)+CHAR(10), ' ') This will put all your text into one "line" by replacing a CrLf pair with a single space. You...

Don't know if this will help or even if it answers the question, but here is what I do when I want to clone a report in a project. From VS, in the Solution Explorer, right-click "Reports" and choose Add -> Existing Item... In the dialog that is displayed, scroll to the original report RDL...

Not sure this will help, but give it a try. This assumes that column 4 in the flat file will only have one character. Right-click and edit your source file in the Connection Managers. Select the "Advanced" topic in the left pane. In the middle pane, select column 4. In the right pane...

Steve: If you simply want to show "This Month", etc in the dropdown, you can add a parameter and just load in those values. The stored procedure could then receive that as a parameter and make the date range calculations based on the text. Another option may be to add a dataset and populate...

This is pretty crude and not sure your data will lend itself to this technique, but maybe it will spark something to get you to your answer. I'll create a temp table (table var in this case) and load in the first few months of your data, in reverse order to illustrate your data does not need to...

To just get rid of the decimal, you could use REPLACE: REPLACE(CONCAT((CAST(id AS VARCHAR(15))), (CONCAT((CAST(package_size AS VARCHAR(15))),(package_unit)))), '.', '')

I'm thinking I would leave the "and comm.type = 'xxx'" out of the JOIN. Even if you have userID's duplicated between SER and EMP, your CASE is going to get the name from the correct table.

You should be able to right-click the textbox that contains your column data reference, select "Text Box Properties...", in the dialog select "Number" in the left pane, then select "Time" in the right pane under "Category:", then select "13:30:00" in the "Type:" section. This should establish...

I should have mentioned that SEQUENCE is only available on SQL Server 2012 and up. So you won't be able to use this on earlier versions. If that is the case, I don't know how to do this on an INSERT but it can be done in an UPDATE. If you were to insert these rows first with some unique tag...

Check out the CREATE SEQUENCE syntax. That might do what you want, but it won't work with TOP so you'll have to work around that. But some fiddling might yield the desired results.

Does this do what you want? INSERT INTO ExistingTable (KeyCol, FirstCol, SecondCol, ThirdCol) SELECT TOP 500 '12345' ,'Testing' ,'Testing' ,'Testing' FROM sys.all_objects

These options are not currently available in any version of SSRS Report Manager so far. Sorry. I have seen requests for this on Connect but no feedback from Microsoft yet.

The Report Manager has a "Download" option which will let you drop the RDL into a folder somewhere, and then use "Add Item" to get it into your project. -Jim-

Not sure I fully understand your requirement, but here is a quick shot at what I think you are asking. SELECT TOP 500 '12345' AS Column1 ,'Testing' AS Column2 ,'Testing' AS Column3 ,'Testing' AS Column4 FROM sys.all_objects This gives me 500 rows of 12345, Testing, Testing, Testing -Jim-