Telerik Forums
Reporting Forum
13 answers
1.6K+ views
From what I read I don't think it could be possible to pass a field value from datasource1 to be a parameter of datasource2 in a subreport, but could I filter datasource2 based on a field of datasource1.

I don't want to use your product groups example because datasource1 has a lot of fields.
Say I have stores and products and I want to list store information and the products each store carries.
Now I could write 1 query to join products and store, but then I'd be repeating 10 columns of my store data for every product and it would be a very large result set.

say I'd want the report to look like:

StoreID | Store Name| Store Hours| Store Owner| Store Street| Store City| Store State ... ( few more)
  1                MyStore1    8-10               Me     ...
                                                                                                Table Product List MyStore1
                                                                                                       Cookies
                                                                                                        Milk
                                                                                                        Eggs
    2             MyStore2    9-5                Joe     ...
                                                                                                Table ProductList MyStore2
                                                                                                         Steak
                                                                                                          Eggs
                                                                                                          Orange Juice

What would be the best way to accomplish this.  I have a large amount of data, so join the data in 1 query probably isn't ideal.
                                                                                               
Stef
Telerik team
 answered on 15 Oct 2015
1 answer
193 views
Seems like this would be an easy one to configure but I'm not seeing anything in the properties to show the time. All I'm seeing is the date. What am I missing?
Stef
Telerik team
 answered on 15 Oct 2015
3 answers
114 views
Hey,

We found that on some Win XP machines running Adobe Acrobat Pro - text on our Reports can be flipped and mirrored/reserved.
See attached.

One these same machines, if they open it with:
Adobe Acrobat XI (not Pro)
or Gmail PReview
or Google Chrome
.. the reports are fine.

Just with Adobe Acrobat Pro  this issue happens.

Any idea what to do?
Stef
Telerik team
 answered on 15 Oct 2015
3 answers
291 views
One of the important requirements for my project is the ability to automatically generate a report and have them e-mailed nightly as a PDF attachment. Is it possible to do this with Telerik Reporting? If so, could you give me an example or point me to a resource?

Thanks-
David Tosi
Nasko
Telerik team
 answered on 14 Oct 2015
4 answers
396 views

Hello together 

Recently, we switched to the HTML 5 report viewer and XML reports which are part of a web site project. Now I wanted to use a custom user function to get a list of recursive nodes for use in an SQL query.
Now, how to access this function inside our web site? I guess, since the reports / report viewer are running inside the web site project, this should be possible?
In which scope is the report / report viewer / report processor running?

When I try to access a function from a separate assembly, this is working. But then I'm unable to access the classes from the web site which are representing the node hierarchy to use.

Thanks for any advice on this!

Fridli Jacober
Top achievements
Rank 1
 answered on 14 Oct 2015
1 answer
383 views

Hello

we use MVC and Html5 and we use telerik report but our customer want to design report how can i do it??

In your demos isn't it Like StimulSoft

thanks a lot Telerik...

Abbas Mirzaee

Stef
Telerik team
 answered on 13 Oct 2015
1 answer
333 views

Hi,

 I've got a user defined functions which is included in a EncounterDatasource.dll below is the code

[Function(Category = "My Functions", Namespace ="My",Description= "Get array item")]
public static string GetArrayItem(string[] values,int index)
{
   return values[index];
}

My problem is upon deployment it cause error in the fields using the said functions. The error is

An error has occurred while processing TextBox 'textBox81': The expression contains object 'My' that is not defined in the current context.

On the Telerik Report Designer its working fine since I've able to add the dll reference in the Telerik.ReportDesigner config but not on the application its not working. I've also made a reference to the dll from my project and make sure it reside with the report. What would be the possible cause of this and how would I deploy report using user defined functions from external dll?

 

Regards,

Jordan

Stef
Telerik team
 answered on 13 Oct 2015
1 answer
364 views

 Our requirement is to show excel icon and pdf icon for easy access, ability to pass parameter directly instead of dropdown similar to print icon

 <li><a data-command="telerik_ReportViewer_print" title="Print" href="#"><i class="fa fa-print icon-print"></i></a></li>

we need to show excel and pdf similar to print icon in template.​

what data-command do we use, i dont see one.

http://www.telerik.com/help/reporting/html5-report-viewer-data-attributes.html

 also if we have export in dropdown list how do we control the styles..need to update z-index and its not working for us. 

<div class="k-animation-container" style="width: 82px; height: 27px; margin-left: -2px; padding-left: 2px; padding-right: 2px; padding-bottom: 4px; overflow: visible; display: block; position: absolute; z-index: 10002; top: 29px; left: 0px;"><ul data-command-list="export-format-list" class="k-group k-menu-group k-popup k-reset k-state-border-up" role="menu" data-role="popup" style="display: block; position: absolute; font-size: 12px; font-family: abc-regular; font-stretch: normal; font-style: normal; font-weight: 400; line-height: 15px;"><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="PDF" data-command="telerik_ReportViewer_export" href="#" class="k-link"><span>Acrobat (PDF) file</span></a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="CSV" data-command="telerik_ReportViewer_export" href="#" class="k-link"><span>CSV (comma delimited)</span></a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="XLS" data-command="telerik_ReportViewer_export" href="#" class="k-link"><span>Excel 97-2003</span></a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="XLSX" data-command="telerik_ReportViewer_export" href="#" class="k-link"><span>Excel Worksheet</span></a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="PPTX" data-command="telerik_ReportViewer_export" href="#" class="k-link"><span>PowerPoint Presentation</span></a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="RTF" data-command="telerik_ReportViewer_export" href="#" class="k-link"><span>Rich Text Format</span></a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="IMAGE" data-command="telerik_ReportViewer_export" href="#" class="k-link"><span>TIFF file</span></a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="MHTML" data-command="telerik_ReportViewer_export" href="#" class="k-link"><span>Web Archive</span></a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="DOCX" data-command="telerik_ReportViewer_export" href="#" class="k-link"><span>Word Document</span></a></li><li class="k-item k-state-default k-last" role="menuitem"><a data-command-parameter="XPS" data-command="telerik_ReportViewer_export" href="#" class="k-link"><span>XPS Document</span></a></li></ul></div>​

Nasko
Telerik team
 answered on 13 Oct 2015
1 answer
533 views

Hello,

Printing from Microsoft Edge doesn't look promising in general right now.  Microsoft and thousands of users seem to indicate that it doesn't work correctly.

That being said has Telerik looked into getting the print dialog to come up in Edge?  As of now the print button causes a PDF to download much like it did with Firefox some years back.  I'm wondering if there is a similar workaround for Edge.

Thank you!

Nasko
Telerik team
 answered on 12 Oct 2015
1 answer
291 views

Hi all,

have an assembly with some user-defined functions. To use it in our another project (and in VS designer) i had to add this snippet to my config(s):

 

    <Telerik.Reporting>

        <AssemblyReferences>
            <add name="MyAssemblyName" version="1.0.0.0" culture="neutral" publicKeyToken="null" />
        </AssemblyReferences>
    </Telerik.Reporting>​

 

All this worked fine until we decided to have real version numbers for all assemblies in our solution. So, one day, we replaced

[assembly: AssemblyVersion("1.0.0.0")]

with

[assembly: AssemblyVersion("1.0.*")]

 in the AssemblyInfo.cs file of MyAssemblyName project. Now Telerik Reporting cannot resolve MyAssemblyName because of the wrong version number.

 

So, my question is: is there any way to have an AssemblyReference without specifying the exact version number?

Thanks in advance.

 

P.S. I've tried omitting "version" altogether, specifying version ranges, wildcards etc. Nothing helps :-(.

 

 

 
Stef
Telerik team
 answered on 12 Oct 2015
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
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?