<iframe id="ifPDF" src='@Url.Action("GetHtmlReport", "StandardReports")' class="resultPDF">
public ActionResult GetHtmlReport()
{
byte[] result = null;
string mimeType = "application/pdf";
result = popstreatmernt;
return File(result, mimeType);
}
private void GetReportInfo(StandardReportsListViewModel stdReportsFilters)
{
try
{
RequistionParameters ReqParams = new RequistionParameters();
RequisitionCheckListbase ReqchkParams = new RequisitionCheckListbase();
RequistionChecklistReport reportRequistionChecklist = new RequistionChecklistReport();
reportRequistionChecklist.ReportInput = ReqchkParams;
byte[] pdfbytesReport = GetPdfBytes(reportRequistionChecklist);
popstreatmernt = pdfbytesReport;
}
catch { }
}
public byte[] GetPdfBytes(Report rpt)
{
Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
//set any deviceInfo settings if necessary
System.Collections.Hashtable deviceInfo = new System.Collections.Hashtable();
Telerik.Reporting.Processing.RenderingResult result1 = reportProcessor.RenderReport("PDF", rpt, deviceInfo);
byte[] result = result1.DocumentBytes;
return result;
}
DECLARE
@Empty
TABLE
(ROW_NUM
INT
);
DECLARE
@iCount
INT
SET
@iCount = 1
WHILE @iCount<=10
BEGIN
INSERT
INTO
@Empty
VALUES
(@iCount)
SET
@iCount = @iCount + 1
END
SELECT
DETTAGLI.*
FROM
@Empty RF
LEFT
OUTER
JOIN
(
SELECT
ROW_NUMBER() OVER (
ORDER
BY
SEQ)
AS
RIGA,
FD.SEQ,
UM.CODICE
AS
UM,
FD.PREZZO,
FD.QUANTITA,
FD.IMPORTO,
FD.DESCRIZIONE,
I.DESCRIZIONE
AS
DESC_IVA,
I.ALIQUOTA,
I.CODICE
AS
CODICE_IVA
FROM
vend.T_FATTURE_DETTAGLIO FD
INNER
JOIN
cont.T_ALIQUOTE_IVA I
ON
I.ID_ALIQUOTA = FD.ALIQUOTA_IVA_ID
INNER
JOIN
magaz.T_ARTICOLI ART
ON
ART.ID_ARTICOLO = FD.ARTICOLO_ID
LEFT
OUTER
JOIN
anag.T_UM UM
ON
UM.ID_UM = ART.UM_ID
WHERE
FATTURA_ID = @prmIDFattura
) DETTAGLI
ON
DETTAGLI.RIGA = RF.ROW_NUM
private
void
chart1_NeedDataSource(
object
sender, EventArgs e)
{
Telerik.Reporting.Processing.Chart procChart = (Telerik.Reporting.Processing.Chart)sender;
procChart.DataSource = ChartExample1;
}