I am returning an SQL dataset in SSRS (Microsoft SQL Server Reporting Services), which has many such relationships:
ID REE Event
6117B FTG-6 06A 6117B FTG-6A PMT 6117BGTI-4B6124A GBBI-406124AGTI-4B < Br> 6124 A GTD-04C-6136MGBi-40
6141CGBI-40
I displayed it in the previous column as a comma-delimited field I would like to do [Event] like this:
ID Rev. Event # 6117b FTG-06A, FTG-06A PMT, GTI-4B-6124A GB-40, GTI-4 B, gtd-4c
6136 m gbi-40
6141 cgbi-40
Is there a way to do this in favor of SSRs?
You do not want to do SSRs on the SQL side, in this way you stored one of these results Can be added to the procedure, and then send it to the reporting layer.
Remember the database to work with the data. The report should only be used for the presentation level, so there is no need to tire yourself as trying to get the function to parse this data.
The best thing to do at the SPACE level and push the data from the spray to the report.
Depending on your edit, you will:
Hold down the areas. Then you will find a string cons of all the values listed. Here's an example:
Use the Northwind @ Category list varchar (1000) Select @ Category List = Collages (@ Category List + ',', ') + Select Category from Category 'Results =' + @ CategoryList Now that you have an additional field i.e. id value, you can not only add to the values of the query, you must use the cursor with it otherwise You will get a notorious error about this one additional query Mr. includes additional fields.
Take a look for more help, make sure that the comment below has been posted by 'Alberto', as you do and you should do
Comments
Post a Comment