I'm  having an issue with the parameters for a report I'm working on.

The query which is the data source for the report is a fairly complex one:

SELECT sub.AssignedCity, SUM(sub.TotalIndividuals) AS TotalIndividuals, SUM(sub.SumOfBoxes) As TotalBoxes, SUM(sub.SumOfMealsServed) As     TotalMealsServed, SUM(sub.SumOf60AndOverServed) AS TotalOver60Served, SUM(sub.SumOf18AndUnder) AS Total18AndUnderServed
FROM(

SELECT EntryMonth, EntryYear, AgencyID, AssignedCity, SUM(IndividualsServed) AS TotalIndividuals, SUM(Boxes) AS SumOfBoxes, SUM(MealsServed) AS SumOfMealsServed,,SUM(Over59Served) AS SumOf60AndOverServed, SUM(Over59Served) AS SumOf18AndUnder

FROM AgencyBoxes

GROUP BY EntryMonth, EntryYear, AgencyID, AssignedCity
UNION
SELECT EntryMonth, EntryYear, HouseholdID, AssignedCity, SUM(IndividualsServed) AS TotalIndividuals, SUM(Boxes) AS SumOfBoxes, SUM(MealsServed) AS SumOfMealsServed,
SUM(Over59Served) AS SumOf60AndOverServed, SUM(Over59Served) AS SumOf18AndUnder
FROM Boxes
GROUP BY EntryMonth, EntryYear, HouseholdID, AssignedCity
) sub
WHERE EntryMonth = @prmEntryMonth AND EntryYear = @prmEntryYear
GROUP BY AssignedCity

I'm getting an error saying that I must declare a scalar variable for the two parameters. I've never seen this error before, and I have no idea what the issue is.

I'm attaching all relevant files detailing report parameters, data source parameters, etc. Any advice would be very much appreciated.

I have embedded Telerik report designer in angular application. I want to clone the existing report and create new report programmatically.  Can anyone provide pointer on how to achieve this? Closest I could find is this i.e. copy over all the report components one by one but I find it laborious and little risky if I miss anything while copying over. 

Thanks!!

I'm trying to accomplish what's been asked over in this question: https://www.telerik.com/forums/graph-datetime-axis-scaling without using Events (which according to the docs here: https://docs.telerik.com/reporting/embedding-reports/program-the-report-definition/report-events/overview, you should avoid and are not support on the .trdx reports that I am developing via the Stand Alone Report Designer). 

How can I dynamically set the MajorUnit and/or MajorStep as the final solution there describes without using the events as that solution does? (solution I'm referring to: https://www.telerik.com/forums/graph-datetime-axis-scaling#4445917 )

I am using Telerik.Reporting.Services.AspNetCore and Telerik Report Designer version 18.2.24.806. I am facing the following issue: In Telerik Report Designer, I set the font to 'Times New Roman,' and it displays correctly according to the design in the local environment. However, after deploying to the production environment, I encountered an issue where some text boxes are correctly using the 'Times New Roman' font, while others are not.

Telerik Report Designer:

Local:

Production:

In my Angular application, I'm using Telerik Reporting and have embedded report designer in web page. That works well i.e. I'm able to load the reports from my server and load them in embedded report designer. Now when user is done with designing the report, I need to save the report manually using the code and not using the save button available in the Menu. This is required because I need to store some of the report information to my backend as well. I have following UI design at the moment and I would like trigger the report save when user presses "Publish" button.

I I can't seem to find any way to achieve this. What I'm looking for is some kind of reporting api/hook kind of thing which will enable me to trigger the save report process from my code. Can any one pls help on how to achieve this?

Also, how I can hide the buttons from Menu i.e. I want to hide few buttons i.e. Save, Save As from embedded report designer menu so user can only save the report using the buttons which I'm providing to them in UI.

Any help on this will be much appreciated. Thanks!!

Updating this, my EAN 128 barcode prints but it doesn't scan 

Can anyone help please. This worked with a different reports designer package. 

Fields.labelBarcode = "94002155449000028921" (for example) 

Report Designer:

   <Barcode Width="6cm" Height="1.635cm" Left="0.4cm" Top="2.044cm" Value="= Fields.labelBarcode" Stretch="False" Checksum="False" BarAlign="Center" Name="barcode1">
              <Style TextAlign="Center" VerticalAlign="Bottom">
                <Font Name="Code 128" Size="10pt" />
              </Style>
              <Encoder>
                <Code128CEncoder />
              </Encoder>              
            </Barcode>

Thanks.

Hello

My team is currently investigating using Telerik Report Designer, both the web version and the standalone for reports planning.  Right now I'm trying to get the report designer to work with stored procedures and it's not working at all.

First, I cannot get a query to run with an EXEC command, and secondly, the drop down that's supposed to have all the stored procedures on the database won't populate.

The connection string is good, I can make basic select queries work. But I cannot get stored procedures to work.

If I do "EXEC [schema].[storedprocedurename]" as a query, I get "Could Not Find stoed procedure 'schema/storedprocedurename'" though it is a valid stored procedure that I can run in SQL server no problem.  

So I can neither access stored procedures from the drop down, or work around this by writing it in a query.  I have this problem with both the standalone and the web designer.  We're not doing anything weird in our database either, it's a basic SQL Server database with stored procedures stored in the Programmability/Stored Procedures folder.

Am I doing something wrong?  Is there some configuration that needs to be set on my database for the report designer to recognize the stored procedures?

Thank you

Jonathan Kuhl

I have a textbox containing a string built from a datasource value.

How to use the text of this box in a watermark ?

I tried without success things like :

Hi Telerik, 

I am having a problem using a multi-value parameter and i m using Standalone Report Designer. I am using a web service data source (2-step API) to show the table according to the ClientID as a parameter.

My requirement: 
Use the multi-value parameter as a ClientID and show the separate table for each selected ClientID on one page or separate pages.
Suppose: 
There are 1-6 ClientIDs, and each ClientID has different data.

For the ClientID 1 
Name       Address    phone   Email
abc            asddad      2123       asdas@abc.com
sdf            asdad          548        sada@abc.com

For the ClientID 2 

Name       Address    phone   Email
qwwe         qwe          222      qww@qwwq.com
zxxc            zxc            5768        vcv@zxc.com

So, if I select ClientID 1 in the filter, then it should show the table data according to ClientID 1, and when I select 2 ClientIDs, i.e., 1 and 2, 
Then the report should show the two tables just like above. But what I faced was 
I am getting all the data in one table like this:
Name       Address    phone   Email
abc            asddad      2123       asdas@abc.com
sdf            asdad          548        sada@abc.com
qwwe         qwe          222      qww@qwwq.com
zxxc            zxc            5768        vcv@zxc.com

 -- I have used grouping as Fields.ClientId and Multi-value for ClientID 
 -- Placed the table inside GroupHeaderSection 

Also tried another setup, but I am still getting data in one table; I need a separate table for the selected ClietID in on one page/separate page.
And when I try to use JsonDataSource, my requirement works, but in Web Service Data Source it doesn't work. Why?

-- Is there any way to fulfill the requirement?