I have problem with retreiving data source columns defined for my report by clicking data explorer option in telerik reporting menu .
I have a class library project and inside it I create a new telerik reporting class . then I cancel it's wizard and I put a sql data adapter into my report and set my connection string and after that select my desire stored procedure in sql data adapter wizard from the list and then finisih. After doing all of the mentioned steps I select my report and then set it's data source to sql data adapter / datasource1 , but when I refer to data explorer option and select it report designer say : procedure or function sp_GetDailyOrders expected parameters @cmp_Id which was not supplied and then no data source column will retreive for me .
If go to select command property of my sql data adapter and then select it's sub property parameters and the assign a default value for my @cmp_Id then data explorer will retreive my data source columns .
Ok, may you please tell me what is the problem ! I don't want to set default value for my paremters .
Please help me .
I am having trouble using an exported StyleSheet in from Telerik Reporting in a WinForms application. I created a report using the wizard that utilized one of the standard styles. Then I customized the styled to match a theme and exported the style for reuse. I created all the reports I needed, now I am having trouble importing the exported style and have it applied to the existing reports (I used the same StyleNames for the selectors as I used the same default theme each time, with the assumption I would be able to apply the custom stylesheet later).
· I clicked on StyleSheet (there were 4 StyleRules defined)
· Selected the 4 styles then clicked export to save the .xml file
· Then I imported the .xml file as an Existing Item to the project and changed the Build Action to “Embedded Resource” and Copy To Output Directory to “Copy Always”
· When I add the External Stylesheet to the report object as a relative object none of the styles are being inherited by the rendered reports.
Is there something I’m missing?
I used http://www.telerik.com/help/reporting/styleexportingandreusingstylesheets.html as a reference.
I am trying to create a parameterized report using the following data source:
SELECT SITE, COUNT(SITE) AS #EVENTS, SUM(WORKTIME) AS WORKTIME, SUM(TOTALEVENTTIME) AS EVENTTIME
FROM EDB_RECORDS
WHERE RECEIVEDDATE BETWEEN '2008-10-01' AND '2008-10-31'
GROUP BY SITE
ORDER BY SITE
I can get the report to display with the WHERE statement as written, but I need to change the WHERE statement to: WHERE RECEIVEDDATE BETWEEN @BDATE AND @EDATE. The intent is to have the user enter the beginning date and the ending date.
I set up a web page to pass the values to the report, but was having trouble putting in the code to check for the parameters using an example I found in the forums.
Any assistance will be greatly appreciated.
I’m using VS2008 using VB, MS SQL Server 2005 and .NET 3.5
Thanks,
Doug