I've created a Telerik report and my datasource is pointing to a stored procedure in sql server.  However, when executing the report I get the following error:

Procedure or function '​ABC123' expects parameter '@CustomerLocationID', which was not supplied.​

When going through the "Configure" option for the datasource, the correct report parameters are mapped to the stored procedure parameters.

When testing the stored procedure call through the "Configure" option, the resultset is returned, as expected, but when running the report through the application, I get the above error.  See the attached images for parameter mapping.

 Thanks.

TLDR - Is there a way to set the minimum number of pages for a report to print on, just so that the page header and footer will print a known number of times?

More detail:  I've got an issue in that I have two distinct sets of data to integrate into one report.  One is a list of invoice lines, and one is a list of shipping labels, both to be printed on the same page(s).

The simplest solution I have that is almost workable is to put a picture box in the page footer.  I have set the image URL to: = ReportItem.Report.ItemDefinition.Transaction.OrderNumber + "-" + PageNumber + ".png".  If there is only one shipping label and one page worth of transaction lines, then it will work fine.  If by some stroke of luck there are two shipping labels and two pages of transaction lines, then it will also work.  In most other cases, the user will get one shipping label and will have to open up the shipping software to "reprint" the other labels.  This isn't the worst thing in the world, because the vast majority of the orders they ship have exactly one shipping label, and just combining the shipping label and invoice/packing slip onto one page is a huge improvement in their workflow.  Is there, by chance, a way to specify a minimum number of pages for the report?  If so, I could programmatically set the number of pages equal to the number of shipping labels.  There will be some pages with no invoice lines printed, but the report would happily reprint the page header and footer and it would work perfectly for my purposes.

Alternately, if someone would like to enlighten me on the actual proper way to do this (a report with two sets of data with different page count requirements), I'd be happy to hear it.  However, it would be much easier if I could just set the minimum number of pages...

I am trying to use telerik report viewer version 7.1.13.612.

I am encoutering the followig issue at run time.

Please help

Invalid report type
Value cannot be null.
Parameter name: type
at Telerik.Reporting.Processing.TypeReportDocumentResolver.Resolve(IReportDocumentResolverContext context, TypeReportSource rs)
at Telerik.Reporting.Processing.ReportDocumentResolver`1.Telerik.Reporting.Processing.IReportDocumentResolver.Resolve(IReportDocumentResolverContext context, ReportSource rs, Boolean loadParameters)
at Telerik.Reporting.Processing.ReportDocumentResolver.<>c__DisplayClass1.<Resolve>b__0(IReportDocumentResolver r)
at Telerik.Reporting.Processing.ReportDocumentResolver.Bind[T](ReportSource source, Func`2 func)
at Telerik.Reporting.Processing.ReportDocumentResolver.Resolve(IReportDocumentResolverContext context, ReportSource source, Boolean loadParameters)
at Telerik.ReportViewer.WebForms.ParametersPage.ResolveReportDocument(ReportSource reportSource)
at Telerik.ReportViewer.WebForms.ParametersPage.get_ReportDocument()
at Telerik.ReportViewer.WebForms.ParametersPage.get_ParamsManager()
at Telerik.ReportViewer.WebForms.ParametersPage.CreateChildControls()
at System.Web.UI.Control.EnsureChildControls()
at Telerik.ReportViewer.WebForms.ParametersPage.OnPreLoad(EventArgs e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Hi Team,

I am new to telerik controls usage. I want to create a report and need your help here, if you can provide me any solution which has simple reports created .

Suppose my table has column EmpId,Name,Age,Salary and

in Report also we need to show this in table.

I have a button , when i will click on button , this report should be opened.

Can you please provide me any demo of these kind of telerik report design/devopment ?

Hi,

Say I have two reports, one that is a list of companies and one that is a list of staff, from the company report I want to click one of the rows and open the staff report to show all people in that company. I have got the click action working fine ie. I can run the staff report by clicking a company name but I can't figure out how to filter the data.

I would imagine that the staff report needs a parameter "company" that would get passed to it when a company is clicked but I can't see how to do this - is it possible?

Hi - We're a product company and are evaluating a new reporting platform.  There's a few questions I can't seem to clearly resolve via documentation.  I'd appreciate it if you could clarify!

1)  Our product needs to provide a runtime report designer to our customers.  So, in ref to your stand-alone report designer:
  a.  Can we extend / customize display controls and offer them as part of the stand-alone designer?  I've already seen that data providers are customizable.
  b.  Can users load / edit / save reports in the stand-alone designer via in-memory structures only, i.e. no files / file system involved at all?  We need to move report definitions in and out of our database with no file system involvement.
  c.  Is it possible to customize other parts of the stand-alone designer?  I.e. toolbars, toolbar event handlers, etc.

2)  Can your reports be exported to native DOCX?  I'm not referring to RTF that'll open in MS Office, etc.  Referring to native DOCX here.

I need to determine the basics here before dedicating some time to an eval, so thanks for any info!

Hi Guys,

 

I have a data structure like this:

 

Headers

ID  Desc
1   Head1
2   Head 2

------------------------------------------

Lines

ID   HeadID
1    1
2    1
3    1
4    2

 

Etc. is there a possiblity to handle this inside on report so that it shows the header + the lines for this header and then breaks the page and continues with the next header?

Also is there a way to show the page no not based of the total pages but based of the "sub documents" e.g. page per Header in my case?

 

Cheers

 

We are evaluating the Telerik reporting products and one requirement is that the stand-along designer must be able to connect directly to a SQLite database.

Not knowing whether the report designer is only compatible with a particular version of SQLite , we have installed various versions of it but cannot find any option within the designer to allow us to connect to the database. Searching the forum we found a post for a similar request dated back in 2012 that suggested changing the exe 'config' file but that did not appear to work in our case.

Any help would be greatly appreciated.

 

Chris

 

Hi,
is it possible to bind a report controls value to an index value like

In my report I have a table that is bound to an objectdatasource. I want to bind some of the tables columns to a list of values in the objects using an indexer. Can that be done? I haven't found a way so far.

Thx

I am using Windows 7, 32 bit Operating System
Microsoft Visual Studio 2010 Premium
and have installed Telerik Q1 2011 SP 1

I've run Visual Studio as an administrator.

While following the instruction in the first telerik getting started video, where we were to create a new Class Library and report, everything went well until I was to insert a text object.

On the video, there were Telerik objects listed in the Toolbox.  All I see are Windows Forms, Data, Components, Printing, and General.  No Telerik category.

I don't have long to see whether Telerik would be an adequate solution for our reporting needs.  Please help.