יום שלישי, ינואר 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 + ' , ' +...
יום שלישי, אוגוסט 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 :)
יום שני, אוקטובר 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...