Some I end up using a lot.

isc ->

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = ''

isr ->

SELECT *

FROM INFORMATION_SCHEMA.ROUTINES r

WHERE r.ROUTINE_DEFINITION LIKE '%%'

ra->

RANK ( ) OVER (PARTITION BY $CURSOR$ ORDER BY )

rai ->

RAISERROR...

I always forget you use an aggregate window function on an existing aggregate function

USE AdventureWorks

SELECT

SalesPersonID,

YEAR(OrderDate) AS [Yr],

SUM(TotalDue)...

Have you validated that all the date values in the file follow this same format?, and are you sure oracle is accepting the dd/mm/yyyy format, and is not expecting mm/dd/yyyy?

I...

Shaun2012 (11/21/2013)

---

For following date im using

10/15/2013 10:17:26 am

Data going in Oracle:

(DT_STR,75,1252)((SUBSTRING(Date,1,4) + "-" + SUBSTRING(Date,5,2) + "-" + SUBSTRING(Date,7,2) + " " + SUBSTRING(Date,9,11) + ":" + SUBSTRING(Date,11,13) + ":"...

Bids doesn't allow you to create a folder.

You can Create a separate project for each folder, and then set your target server URL to that folder.

http://ReportServerName/ReportServer/MyFolder

or manually deploy...

2 Ideas.

1st. Get your data source to return 1 row with all blank values, that way the values can still be placed on the form, but it just wont show...

In SSRS you cannot specifiy optional parameters in this way.

You can allow nulls in all 3 parameters. and then the user has to know what to put in or not.

Or...

Your sure your table does not have characters in column2 where column1 <> 'abc' ?

Same issue with IE 10 and SSRS 2008 and 2008R2. Must use compatibility mode and it loads, but looks terrible.

Not sure if there will be a fix.

I think its the same.

But here's what I have referenced.

http://msdn.microsoft.com/en-us/library/ms156511(v=sql.105).aspx

Yeah,

See image.

In the row groups section, RightClick -> Group Properties. Change the name to what you want.

In the properties Pane.

Left Click any part of the Yellow.

Look at the properties pane.

The Data only Section.

See image.

That will make all items element centric.

and you can control individual items by...

jbalbo (5/6/2013)

---

Hi Ray

Sorry I really didn't work it correctly

What I really want is just the data on the output

with tags

<name>joe</name>

with no other stuff.......

If I could get it vertical even better(I...

Check out the DataElementName Property for each text box.

They are set to Auto by Default, Change the name here.

Nevermind, Didn't read your question. Hold Please

No I was right, Clicking on...

Are you grouping by Something else? Feels like something is missing.

Check the attached test Report1, on a row by row basis, the expression is reflecting the amt correctly, so...