October 4, 2013 at 6:04 am
Hi
I have a requirement where I need to show a column name in a SSRS report in the following format:
List of <Hazards.hazardCode> separated by ", "
<MaterialsItems.otherHazards>
Here, Hazards and MaterialsItems are table names and hazardCode and otherHazards are column names.
How to display this? Pls help me on this.
October 4, 2013 at 7:25 am
Junglee_George (10/4/2013)
HiI have a requirement where I need to show a column name in a SSRS report in the following format:
List of <Hazards.hazardCode> separated by ", "
<MaterialsItems.otherHazards>
Here, Hazards and MaterialsItems are table names and hazardCode and otherHazards are column names.
How to display this? Pls help me on this.
WOW talk about vague. I think you want to create a comma separated list of hazardCode?
Take a look at this link. http://www.sqlservercentral.com/articles/71700/[/url]
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 4, 2013 at 5:00 pm
You might be able to use JOIN() in SSRS, but Sean's right... more details, please!!!
If you want a good answer, ask a good question! (enough details so we can reproduce what you're seeing...)
October 7, 2013 at 12:16 am
I want to show the above column in a SSRS table, as an expression(as I have to join two columns from different tables.).
October 7, 2013 at 7:36 am
Junglee_George (10/7/2013)
I want to show the above column in a SSRS table, as an expression(as I have to join two columns from different tables.).
We can't see your screen, we have no idea what your project is supposed to do, we don't know your datasets. You have provided absolutely no details about what you want. We are really good at sql but we are terrible as mind readers. Look at what you have posted and ask yourself if you could provide an answer based on the details provided.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 9, 2013 at 11:49 am
Are the column names constant or dynamic?
October 10, 2013 at 12:23 am
The columns are constant columns in a table.
October 10, 2013 at 12:26 am
I am getting this error message when the JOIN() in ssrs is used.
[rsRuntimeErrorInExpression] The Value expression for the textrun ‘Textbox96.Paragraphs[0].TextRuns[0]’ contains an error: Overload resolution failed because no Public 'Join' can be called with these arguments: 'Public Shared Function Join(SourceArray As String(), [Delimiter As String = ]) As String': Argument matching parameter 'SourceArray' cannot convert from 'String' to 'String()'. 'Public Shared Function Join(SourceArray As System.Object(), [Delimiter As String = ]) As String': Argument matching parameter 'SourceArray' cannot convert from 'String' to 'Object()'.
Any help is appreciated.
October 10, 2013 at 7:52 am
Junglee_George (10/10/2013)
I am getting this error message when the JOIN() in ssrs is used.[rsRuntimeErrorInExpression] The Value expression for the textrun ‘Textbox96.Paragraphs[0].TextRuns[0]’ contains an error: Overload resolution failed because no Public 'Join' can be called with these arguments: 'Public Shared Function Join(SourceArray As String(), [Delimiter As String = ]) As String': Argument matching parameter 'SourceArray' cannot convert from 'String' to 'String()'. 'Public Shared Function Join(SourceArray As System.Object(), [Delimiter As String = ]) As String': Argument matching parameter 'SourceArray' cannot convert from 'String' to 'Object()'.
Any help is appreciated.
6 days into your issue, you haven't received any help. I have asked repeatedly for details and you keep posting anything but details. I generally request this information a maximum of three times...this is #3 in your thread. Give us some details and we can help you find a solution.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply