TSQL: Concatenate Column from Multiple Rows into String

יום שלישי, ינואר 24, 2012

Ok , So I had a problem related to concatenation of a single Column into one ( same ) column when using GROUP BY . The Problem came from a Reporting Services perspective and there might be other solutions ( like coding in VB.NET in the report ) I have found a very nice samples : Option 1: use Northwind declare @CategoryList varchar(1000) set @CategoryList ='' select @CategoryList = @CategoryList + ' , ' +...

Exporting/Saving RDL files from http://server/reports

יום שלישי, אוגוסט 11, 2009

Exporting/Saving RDL files from http://server/reports Here are the steps: 1. Go to Report on Report Manager 2. Click "Show Details" 3. Click "Properties" of the report you need to Export 4. Under "Report Definition", click on "Edit". You will be able to either "Open" or "Save" the RDL file. … And in Pictures ;) That simple :)

Crystal Reports Redistributable Runtime

יום שני, אוקטובר 15, 2007

Some of us ( not me , i'm more a SSRS ) still use Crystal Reports as a platform for reporting :'( , so if you're looking for the runtime ( without installing VS ), here are the links: Crystal Reports for .NET Framework 2.0 Redistributable Package (x86)http://support.businessobjects.com/communityCS/FilesAndUpdates/cr_net_2005_mergemodules_mlb_x86.zip.asp Crystal Reports for .NET Framework 2.0 Redistributable Package (x64)http://support.businessobjects.com/communityCS/FilesAndUpdates/cr_net_2005_mergemodules_mlb_x64.zip.asp Crystal Reports for .NET Framework 2.0 Redistributable Package (ia64)http://support.businessobjects.com/communityCS/FilesAndUpdates/cr_net_2005_mergemodules_mlb_ia64.zip.asp From Business Objects' WebSite comes:Crystal Reports for Visual Studio 2005 Walkthroughs ...which in the end helped me in the x64 bit by specifying that C:\Program Files\Microsoft Visual Studio 8\Crystal Reports\CRRedist\X64\CRRedist2005_x64.msiAnd/Or C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\CrystalReports\CRRedist2005_x86 Which helped me in the...
30 תגובות