Using Q3 2008 version

I have a report with a variety of user functions. These have worked fine. Today I made some changes in the functions so that they would take more parameters. After recompiling the report preview gives an error message "The expression contains undefined function call..." This is only on the functions that have the added parameters.

Also, and I figure this is related, none of the functions (working or broken) appear  in the "Edit Expression" Editor Instead I get "ReportsClassLib" and ReportsClassLib.My"

I have tried building, cleaning, and rebuilding the solution in various combinations but no luck. What should I try?

Thanks,

Matthew

 I am using Visual Studio 2008 and Telerik Reporting Q3 2008 SP2.  We are using MySQL as the database backend.


I have pasted this in the query builder, which I can run in MySql with no problems(when I substitute the parameters for real data):

SELECT     oc.GroupOffense, uc.category, SUM(CASE WHEN i.CommittedDt > @StartDtThisYear THEN 1 ELSE 0 END) AS ArrestsYTD,
                      SUM(CASE WHEN i.CommittedDt BETWEEN @StartDtLASTYEAR AND @EndDtLastYear THEN 1 ELSE 0 END) AS ArrestsLastYTD
FROM         analytics_incident i JOIN
                      analytics_IncidentCrimeInfo ci ON ci.incidentid = i.incidentid JOIN
                      ucroffensecategory uc ON uc.categoryid = ci.ucr_crime_category JOIN
                      ucroffensecode oc ON oc.categoryid = uc.categoryid
WHERE     oc.GroupOffense = @GroupAB
GROUP BY oc.groupoffense, uc.category

and when I click on Execute Query it gives me this error:
SQL Execution Error.
Executed SQL Statement : SELECT     oc.GroupOffense, uc.category, SUM(CASE WHEN i.CommittedDt > @StartDtThisYear THEN 1 ELSE 0 END) AS ArrestsYTD,
                      SUM(CASE WHEN i.CommittedDt BETWEEN @StartDtLASTYEA...
Error Source: MySql.Data
Error Message: Fatal error encountered during command execution.

The sql statement runs fine in mySql so why not in the report?

THanks
Christel

Hi
I need some help making a report design of this

*                                    Months
Project name                Jan    Feb    Mar    Apr    May    Jun    Aug    Sep    Okt    Nov    Dec
Project 1 fuse                *        *                            *         *         *
Project 2 start                         *        *                                        *        *
Clean rum something                                        *        *             *        *           *        *         *       
Make Asic design            *      *        *            *                

*                                    Days
Project name                1        2        3       4        5        6        7        8        9        10    11    ...    andso    ... 31
x1                                  *        *                            *         *         *
x2                                  *        *                                                *        *
x3                                  *        *        *        *        *        *            *        *
x4                                  *       *         *            *                

I know that there is a Gantt diagram and I thing that is the way to make it, but how ? I have to make this in programming not in design time, because the page size can be A4 or A3 or something else.

Janus S. Andersen

Hi Steve,

        We have purchased Telerik Reporting Tool from your website, i have downloaded the related softwares and documentation and source code. All works fine. But the issue which i am facing is that all source code are in C#, i kindly request you to send me the link where the source code will be available in vb labguage.
        
        We have Purchased both RadControl for ASP.NET Ajax and now Reporting Tool, so i believe you would help us on the above issue.


With Regards

Koshy

Hi,

I am working on a project and having to do a lot of reports, I want to keep the reports the same appearance in term of keeping the same margins and keep logo and title the same places in each report, is there a way I can create my own report template?

Thanks,

Scott   

I have a Telerik Report and want to bind data to the report by using a stored procedure.  I can accomplish that easily with a select statement or calling a stored proc that has no parameters.  When I try passing a parameter I get the message "The EXEC SQL construct or statement is not supported". 

I defined a report parameter called @UserID and call the stored proc like this: EXEC get_data @UserID.  This appears to be inline with the sample syntax shown at the bottom of the wizard when I am creating the connection (SELECT ColumnName1, ColumnName2 FROM TableName WHERE ColumnName1 = @ParameterName). I can even call the procedure with a hard coded value and it works like so: EXEC get_data 'myparm'.    

Thanks for any help

Good Day,

I was wondering if you could lend me a helping hand?

I had a report set out like people do in spreadsheets, heading, followed by data underneathe.

I was using a page header as I wanted the heading to be displayed for each page the data flows onto, the only problem was, once the columns exceeded a certain number, the headings were truncated and further not displayed and then the data on the next page didn't have a heading.

Next I decided to use a report header, which appeared to be the answer to my solution at first but the headers were only displayed once, thus the remaining pages didn't contain any headings for the data they represented. Using a Group Header gave me the same result.

Basically for each column display the results for A, B & C, for instance, I would like "A", "B" & "C" to be displayed above their respected columns of data.

Is there a way this can be achieved?

Any help will be greatly appreciated.

Thankyou,

David

Hi all,

I am using Visual Studio 2008 and Telerik Reporting Q3 2008 SP2.  We are using MySQL as the database backend.

I created a report and put it on a report viewer on a windows form.  I put this in the code behind of the form

 

private void reportViewer1_Load(object sender, EventArgs e)

 

{

LETGReportLibrary.

 

rptMasterAddress MyReport = new LETGReportLibrary.rptMasterAddress();

 

MyReport.AddressID = 8164;

reportViewer1.Report = MyReport;

reportViewer1.RefreshReport();

}

When I run the windows application, no data shows on the report.  I know when I run the query, 14 rows come back.  Why doesn't the data show in the windows application?