Hello Nayyer,
As you said, Aspose.Pdf for Reporting Services 2.5.3 have support for SQL Reporting Services 2012 so we have updated our project and i am developing my reports with SQL Server Data Tools from Visual Studio 2010
I have several needs and doubts but let’s start with the most basic…
What i have done doesn’t seem to work so i need urgent support…
1 - Install Aspose.Pdf for Reporting Services to Visual Studio Report Designer
Step 1 - Opened the C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies folder.
Step 2 - Copyed Aspose.Pdf.ReportingServices.dll (downloaded from here and extracted from bin\ReportViewer2010) to that folder.
Step 3 - Register Aspose.Pdf for Reporting Services as a rendering extension. For that i’ve open the file C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies RSReportDesigner.config and added the following lines into the element:
<Extension Name=“APPDF” Type=“Aspose.Pdf.ReportingServices.Renderer,Aspose.Pdf.ReportingServices”/>
Step 4 - Give Aspose.Pdf for Reporting Services permissions to execute. To do this, i’ve located RSPreviewPolicy.config in the folder, open
it and added the following as the last item in the second to outer element:
<CodeGroup class=“UnionCodeGroup” version=“1” PermissionSetName=“FullTrust”
Name=“Aspose.Pdf_for_Reporting_Services” Description=“This code group grants full trust to the AP4SSRS assembly.”>
<IMembershipCondition class=“StrongNameMembershipCondition” version=“1” PublicKeyBlob=“00240000048000009400000006020000002400005253413100040000010001000734cc24bfcebd7aa8c6e2bf8af5c2b95c7a7e6092abb60d68a7d9efde285cf7dce7f354b44cf3064e8ad85bddfe405ad1e51855d9a1367c15cb34529988feeee0c3279caecdb6dfd7f94c5364d2bd282c4f93493d56d33df36f97da8fd71bb7dc4b0e7f1428b926291cdea7cec1085aa9cc0f6771e4fc2f5772603eee3afaaa” />
Step 5 - Reloaded Visual Studio.
After reload Visual Studio 2010, when i preview a report gives me an error:
***Could not load type ‘Aspose.Pdf.ReportingServices.Renderer’ from assembly ‘*** <b><i>Aspose.Pdf.ReportingServices.Renderer, Version=2.5.3.0, Culture=neutral, PublicKey=716fcc553a201e56’.</i>
2 - Install to Report Server
How can i do this working with Sql Server 2012, SQL Server Data Tools from Visual Studio 2010.
3 - License Aspose.Pdf for Reporting Services
I’ve bought Aspose.Pdf Product Family and in my project i am working with aspose.pdf for .NET and aspose.pdf for Reporting Services, so my doubt is how many times do i have to load my license?
In other words check out this example:
My report have a textbox with FullJustify Text Alignment (aspose.pdf.reportingservices).
So i will render the report in my code with something like this:
public List<byte[]> RenderReportUsingWebRequest(string reportPath, Dictionary<string, string> reportInputParameters, string format, string outputFormat)
{
List<byte[]> listArrayBytes = new List<byte[]>();
const string persistStreams = “&rs:PersistStreams=true”;
const string getNextStream = “&rs:GetNextStream=true”;
//Build the initial request for the reoprt server to render the report.
string requestUri = string.Format("{0}?{1}&rs:Command=Render{2}&rs:Format={3}&rc:OutputFormat={4}",
“http://wbf:8090/ReportServer2012/ReportExecution2010.asmx”,
reportPath,
BuildStrParameters(reportInputParameters),
“APPDF”,
“APPDF”);
Console.Out.WriteLine();
//Create a HTTP request which notifies the server to process the page 1 and
// keep rendering the rest of the pages in the server.
CookieContainer cookies = new CookieContainer();
WebRequest request = WebRequest.Create(requestUri + persistStreams);
(request as HttpWebRequest).CookieContainer = cookies;
//Breaks from the loop only when we read an empty stream marking the end of pages.
while (true)
{
//Authenticates the request with the current logged in windows user credentials.
request.UseDefaultCredentials = true;
// Get the corresponding web response for the request object.
WebResponse response = request.GetResponse();
//Read the response stream.
Stream s = null;
MemoryStream ms = new MemoryStream();
int count = 0;
byte[] data = null;
s = response.GetResponseStream();
data = new byte[1024];
do
{
count = s.Read(data, 0, data.Length);
ms.Write(data, 0, count);
} while (count > 0);
// Set the memory stream position to beginning so we can read it from the start.
ms.Seek(0, SeekOrigin.Begin);
if (ms.Length == 0)
{
break;
}
//If not end of pages then add the current stream to the list.
listArrayBytes.Add(((MemoryStream)ms).ToArray());
//Request for the subsecuent pages.
request = WebRequest.Create(requestUri + getNextStream);
(request as HttpWebRequest).CookieContainer = cookies;
}
return listArrayBytes;
}
After this i convert the listArrayBytes to a stream and use the aspose.pdf for .net to replace some text from the pdf. For that i load my license like this:
Aspose.Pdf.License license = new Aspose.Pdf.License();
license.SetLicense(“Aspose.Pdf.Product.Family.lic”);
So, my doubt is, before i call the method RenderReportUsingWebRequest() do i have to load a license like this?
Aspose.Pdf.ReportingServices.License license = new Aspose.Pdf.ReportingServices.License();
license.SetLicense(“Aspose.Pdf.Reporting.Services.lic”);
I hope it was clear with my questions, otherwise we can talk via skype or something. I think it would be easier to clarify my doubts.
Thanks in advance.
HugoPacheco: