Telerik Forums
Reporting Forum
5 answers
403 views

Current project uses the Telerik Report library.

I've been working with the Documents.SpreadsheetStream and Documents.Spreadsheet methods to by-pass the report templates. Finding my design plan has run into a design issue when exporting directly to excel. In the Templates can create a much richer view for the end-user.

However the customer wants to export directly to Excel with out having to view the report then click on the export button. (See the attach jpg file for screen shot of the current interface). I think I will add both options for the end user to select view or export,  just incase they rather not have the file. Or if another customer prefers the view...

My question, Can I run the process to run the Telerik report template I created and pass all parameter that will cause the export to Excel directly?

 

herb
Top achievements
Rank 1
Veteran
Iron
 answered on 18 Mar 2021
27 answers
2.0K+ views
Hi

In the web report viewer, I'd ideally like to limit the user to being to export to PDF, and remove .tiff and .mht export functionality. Ideally as well there'd be no drop down list with the formats in - just an export button.

I suspect I'm going to have to write this functionality myself (as I can remove the export stuff from the report viewer, and I can generate the PDF from a raw Report object into a byte array, and hence send it to the client) - but before I implement that I wanted to check if it was built in.

Thanks

Tom    
Neli
Telerik team
 answered on 18 Mar 2021
2 answers
1.0K+ views

As you can see in the screen shot, I have a table with values, but the one property is a collection of values.

I need to summarize the values in the nested collection in the "Payments" column of the report. If I try to reference the field "PaymentAmount" I get an error "The expression contain object 'PaymentAmount' that is not defined in the current context".

I understand I could add another table inside the field, but that doesn't work well in my case.

Here is my Inline Json Datasource:

{
    "value": [
        {
            "DocNumber": "952",
            "PaymentLinks": [
                {
                    "PaymentAmount": 1000.00
                }
            ]
        },
        {
            "DocNumber": "953",
            "PaymentLinks": []
        },
        {
            "DocNumber": "954",
            "PaymentLinks": [
                {
                    "PaymentAmount": 11.00
                },
                {
                    "PaymentAmount": 12.00
                },
                {
                    "PaymentAmount": 10.00
                }
            ]
        }
    ]
}

 

Tursunkhuja
Top achievements
Rank 2
Iron
Iron
Veteran
 answered on 17 Mar 2021
3 answers
466 views
Good day, I am designing a 4 x 6 Label for a Thermal label printer. I have a problem however trying to print this label via the label printer. All the fields get Top left aligned in the print preview. The focus Area for the printer is in the center. How do I get my report centered so that it will fit properly on to the label?
Todor
Telerik team
 answered on 17 Mar 2021
1 answer
272 views

One of the most recent report updates from business side requires me to change report layout to accommodate the following output(picture attached).

 

But since HtmlTextBox does not support embedding of images and PictureBox has to be fixed statically on a page I do not see a way to make the picture box to line up with a text content that is aligned to the right.

Is this possible to achieve by some other means?
 

Mads
Telerik team
 answered on 15 Mar 2021
2 answers
690 views

Hello everyone,

Please, I need a little help with Report Designer. I have 2 fields(Name and CompanyID) and I want to concatenate them. Some rows from column Name are populated with company name and other are blank. All rows from CompanyID are populated with guids. I tried something like {Fields.Name}{Fields.CompanyId}, but all rows which are populated with the company name, also added guids. I want all the rows that are populated with the company name not to add guids, too.

Thanks in Advance!

Marcel
Top achievements
Rank 1
Iron
 answered on 15 Mar 2021
3 answers
376 views

Hello,

I created an invoice template with the standalone report designer and I am able to programmatically export a pdf file.

Is it possible to disable copy / paste functionality in the created pdf file programmatically.

Best regards,

Alex

Alexander
Top achievements
Rank 1
 answered on 12 Mar 2021
6 answers
772 views

Hi..

I'm trying to print on Azure.. get the following error. I've read that you can't use a FREE plan cause it doesn't support GDI+.

I have a standard plan - paying.. but I can't print from the site (on Azure). Works great locally.

Any ideas?  thx

 

System.ArgumentException: Parameter is not valid.   at System.Drawing.Graphics.GetHdc()   at Telerik.Reporting.Pdf.PdfContext..ctor(String ownerPassword, String userPassword) in c:\temp\reporting\RBuild-2657\Reporting_Build\Source\Code\Telerik.Reporting.Pdf\PdfContext.cs:line 36   at Telerik.Reporting.Pdf.PdfDocument.InitCompleted(Stream stream) in c:\temp\reporting\RBuild-2657\Reporting_Build\Source\Code\Telerik.Reporting.Pdf\PdfDocument.cs:line 332   at Telerik.Reporting.ImageRendering.DocumentPdf.CreateDocument(PdfRenderingContext pdfContext) in c:\temp\reporting\RBuild-2657\Reporting_Build\Source\Code\Telerik.Reporting.ImageRendering\DocumentPdf.cs:line 68

Neli
Telerik team
 answered on 11 Mar 2021
5 answers
895 views

I am trying to create a comparative Profit & Loss with columns comparing the previous column with the current column. The Previous() function doesn't allow more than one scope as the Exec() does, but it appears that that is what I need.

As an example I'm using the following csv. See the attachment as well.

Year,Account,Amount
2000,50000,1000.00
2000,51000,560.00
2001,50000,1000.00
2001,51000,560.00
2002,50000,5000.00
2002,51000,60.00
2000,50000,1500.00
2001,51000,500.00

Note that there are two values for Year "2000" and Account "50000"

How can I get the Previous = Exec('year1','account1', Sum(Fields.Amount))?

Todor
Telerik team
 answered on 11 Mar 2021
6 answers
663 views

We are trying to access our own servers using Web Data Source and are having issues with 2 Step Authentication. I have attached the screenshot with this email on how we have set it up, and on final page when we click Download, we get 401 unauthorized.

The same Url and body parameters are working through Postman. I was wondering if you can please help us identify what maybe wrong?

Dimitar
Telerik team
 answered on 11 Mar 2021
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?