Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Special Characters in Column Name - WildCard in SSRS Expand / Collapse
Author
Message
Posted Monday, October 21, 2013 4:07 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 12:05 PM
Points: 20, Visits: 126
Hello Folks,

I got into something interesting last week when i was working on SSRS 2008 R2 reports. So i need to clarify on that.

I have a table with around 1000 records and one of the column name is ITEM_NAME. The datatype is nvarchar(80). I built a SSRS report based on that table. I have 2 parameters. Country and ITEM_NAME. ITEM_NAME is wildcard parameter. Everything was running fine until i got some new data for ITEM_NAME like 'Pre order #1' , 'Pre Order #2' and so on. When i ran the report, i am not able to see the records with ITEM_NAME consists of '#'.

For EX: For country Mexico, i have two item names. 'Pre Order' and 'Pre Order #1'. If i select Mexico and view the report, i am seeing only 1 record with item_name 'Pre Order'. The ITEM_NAME with '#' is not showing up in the report.


My Question is, is this a BUG or any SSRS limitations that when we use wildcard parameter on any column, that column should not contain special characters like '#'.

Thanks,
SS
Post #1506899
Posted Thursday, January 23, 2014 6:05 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:12 PM
Points: 827, Visits: 342
Are you sure about this?
I tried replicating this in SSRS 2005 (unfortunately I don't have SSRS 2008 installed on my machine).

With a dataset like:

Select 'Pre Order #1' as Text
union
Select 'Pre Order' as Text

And setting it for a table, I get two rows as expected.

Well, I've seen a case where if column name or alias contains #, it is replaced with an underscore.
Post #1534310
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse