Hi -
I'm trying out Telerik Reporting for the first time (I have used SSRS for a few years before).
There's a few useful expressions that I've used in SSRS, which I have trouble reproducing in Telerik reports...
1) Referencing a dataset with the Exec() function:
- I have a table "TableA", and a TextBox outside of the table
- I would like the TextBox value to be the Sum() from TableA = Exec('TableA', Sum(Fields.Column1))
- unfortunately this is not supported... Any plans to have it in the future? What's the cleanest workaround?
2) Referencing the value from another TextBox:
- I have 2 Textboxes, "TextBoxA" and "TextBoxB"
- I would like TextBoxB value to equal the value from TextBoxA (in SSRS I would do: ReportItems!TextBoxA.Value )
- this doesn't seem to be supported... Any plans to have it in the future? What's the cleanest workaround?
3) ColumnNumber() function:
- I was trying to use ColumnNumber() in a header for some business scenario
- the function always returned "1"...
thanks for your help!
- bash
I'm trying out Telerik Reporting for the first time (I have used SSRS for a few years before).
There's a few useful expressions that I've used in SSRS, which I have trouble reproducing in Telerik reports...
1) Referencing a dataset with the Exec() function:
- I have a table "TableA", and a TextBox outside of the table
- I would like the TextBox value to be the Sum() from TableA = Exec('TableA', Sum(Fields.Column1))
- unfortunately this is not supported... Any plans to have it in the future? What's the cleanest workaround?
2) Referencing the value from another TextBox:
- I have 2 Textboxes, "TextBoxA" and "TextBoxB"
- I would like TextBoxB value to equal the value from TextBoxA (in SSRS I would do: ReportItems!TextBoxA.Value )
- this doesn't seem to be supported... Any plans to have it in the future? What's the cleanest workaround?
3) ColumnNumber() function:
- I was trying to use ColumnNumber() in a header for some business scenario
- the function always returned "1"...
thanks for your help!
- bash
16 Answers, 1 is accepted
0
Andrew
Top achievements
Rank 1
answered on 13 May 2011, 04:04 PM
Bash,
I think you can use the binding even to assign the value to textbox B to that from A. I am just speculating, as I have never tried it. I believe it would be as simple as TextBoxB.value = TextBoxA.value in the event.
I think you can use the binding even to assign the value to textbox B to that from A. I am just speculating, as I have never tried it. I believe it would be as simple as TextBoxB.value = TextBoxA.value in the event.
0
Andrew
Top achievements
Rank 1
answered on 13 May 2011, 04:07 PM
After thinking through my last answer I realized that probably wouldn't work, since it would just get the value in the textbox and not the rendered value. The only way to achieve this would be the exec function in order to execute the same equation within the scope of Textbox A.
0
bash
Top achievements
Rank 1
answered on 13 May 2011, 04:33 PM
"After thinking through my last answer I realized that probably wouldn't work, since it would just get the value in the textbox and not the rendered value."
You're right - it's not particularly straightforward...
On the "ItemDataBound" event of TextBoxA, I had to save its rendered value in a private member.
And finally on the "ItemDataBound" of TextBoxB, I copied the value back from the private member...
In a complex business report - this became kind of messy...
The use of Expressions on the report-side would have been my preference in this scenario...
0
Hi Bash,
Thank you for your interest in Telerik Reporting and up to your questions:
All the best,
Steve
the Telerik team
Thank you for your interest in Telerik Reporting and up to your questions:
- According to the Expression scope help article, you must specify the current scope or a containing scope; you cannot specify a scope that is lower or at the same level in containment order than the current scope. It is in our plans to extend this functionality to cover such scenario as well for subsequent versions of the product. The current workaround is using events like you have found out in last post.
- Indeed there is no counterpart for such expression, but it is in our plans to extend this functionality to cover such scenario for subsequent versions of the product. The current workaround is using events like you have found out in last post.
- The ColumnNumber function can accept a parameter which specifies the scope. For static column groups, the ColumnNumber would always be 1 and this is expected. If you would like to count those as well you have to set as scope an upper non static column group or the table item itself.
All the best,
Steve
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items
0
bash
Top achievements
Rank 1
answered on 13 Jun 2011, 05:01 PM
Here's another related scenario that I can't seem to make work:
Simply using a basic Exec() expression in a Table.
The help article says:
"According to the Expression scope help article, you must specify the current scope or a containing scope; you cannot specify a scope that is lower or at the same level in containment order than the current scope."
Well even though I refer to the Report as the scope, which is the highest scope level, the Exec expression returns an error...
Am I missing something?
thanks for your help..!
Simply using a basic Exec() expression in a Table.
The help article says:
"According to the Expression scope help article, you must specify the current scope or a containing scope; you cannot specify a scope that is lower or at the same level in containment order than the current scope."
Well even though I refer to the Report as the scope, which is the highest scope level, the Exec expression returns an error...
Am I missing something?
thanks for your help..!
0
Massimiliano Bassili
Top achievements
Rank 1
answered on 15 Jun 2011, 03:14 PM
bash, the Table is a separate data region (they call it data items here I believe) and it has its own data source. I believe the quote you pasted is valid within a single data item only, otherwise it does not make sense.
Cheers!
Cheers!
0
sid
Top achievements
Rank 1
answered on 15 Jun 2011, 03:18 PM
Hello Telerik Team,
I am having Similar problem what bash has, I am not able to access any values from a higher scope even if the value is from report level. Could you post a code snippet or even better a working example using Exec Function.
Thanks,
Sid
I am having Similar problem what bash has, I am not able to access any values from a higher scope even if the value is from report level. Could you post a code snippet or even better a working example using Exec Function.
Thanks,
Sid
0
bash
Top achievements
Rank 1
answered on 15 Jun 2011, 04:30 PM
Thanks for your reply -
I understand what your saying, though I just wish the Tables would at least be part of the Scope hierarchy and not separate...
All these limitations on the Exec() function and on the Table are giving me a hard time...
In SSRS for instance, you can define multiple DataSets - and in a single Table, each cell can actually fetch from any of those datasets (using their own Exec(scope) function)... Seems a lot more flexible...
-bash
I understand what your saying, though I just wish the Tables would at least be part of the Scope hierarchy and not separate...
All these limitations on the Exec() function and on the Table are giving me a hard time...
In SSRS for instance, you can define multiple DataSets - and in a single Table, each cell can actually fetch from any of those datasets (using their own Exec(scope) function)... Seems a lot more flexible...
-bash
0
Massimiliano Bassili
Top achievements
Rank 1
answered on 16 Jun 2011, 11:26 AM
bash, I think you're missing the point. The example you give for SSRS is not the same as your current one i.e. you have a single Table, in other words the data region is in reality the same. Imagine the following to retrospect the same case in SSRS:
you have a Table/Matrix that is bound to data and you have a TextBox in the body with some data - you cannot use the scope function with argument the textbox.
Anyway I do not want to start an argument, but the comparisons you give to SSRS are simply not true, because the scenario differs. After all if you like SSRS and know its inner working well, stick to it.
Cheers!
you have a Table/Matrix that is bound to data and you have a TextBox in the body with some data - you cannot use the scope function with argument the textbox.
Anyway I do not want to start an argument, but the comparisons you give to SSRS are simply not true, because the scenario differs. After all if you like SSRS and know its inner working well, stick to it.
Cheers!
0
bash
Top achievements
Rank 1
answered on 16 Jun 2011, 02:02 PM
>> you have a Table/Matrix that is bound to data and you have a TextBox in the body with some data - you cannot use the scope function with
>> argument the textbox.
There are two ways to solve this in SSRS
1) using the Report Item listing: =ReportItems!TextBox1.Value
2) scoping not the textbox, but scoping the textbox's dataset: =Exec('TextBox1DataSet', Fields.ValueA)
Haven't found the equivalents in Telerik...
>> Anyway I do not want to start an argument, but the comparisons you give to SSRS are simply not true, because the scenario differs. After all if
>> you like SSRS and know its inner working well, stick to it.
Not my decision to make. Business here uses Oracle!
0
Hello bash,
The approaches you mention in your last post are not yet available in Telerik Reporting and we covered this in your original inquiry. Please explain your goal in detail so we can grasp what you are trying to achieve and hopefully we would be able to offer a solution for your case.
Regards,
Steve
the Telerik team
The approaches you mention in your last post are not yet available in Telerik Reporting and we covered this in your original inquiry. Please explain your goal in detail so we can grasp what you are trying to achieve and hopefully we would be able to offer a solution for your case.
Regards,
Steve
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items
0
Ubuntu
Top achievements
Rank 1
answered on 07 Sep 2012, 11:52 PM
Dear All,
I am having a very hard time with this report, let me explain further:
1st: Localization:
Whenever I change any thing in the english report and move to the localized report a found a strange thing, text are not in the same order, some are empty ... I just don't know why .. as If I should be careful 100% about the modification !!!
2nd: EXEC function
Couldn't find any help about using Exec() function with correct usage; I have a table that use it's one dataset but I need a field outside the table to reference that table field, so I used the proposed solution http://www.telerik.com/help/reporting/expressions-functions.html, I don't get any error in the report but the value isn't shown either !!
3rd: Grouping
I can't see how can I create grouping in the same scenario where I have a table with it's own dataset, or should I have the report reference the global dataset and use the tabular layout instead !!
I am evaluating telerik and having a very hard time because I am doing a demo in a few days but can't get through
any help will be appreciated
I am having a very hard time with this report, let me explain further:
1st: Localization:
Whenever I change any thing in the english report and move to the localized report a found a strange thing, text are not in the same order, some are empty ... I just don't know why .. as If I should be careful 100% about the modification !!!
2nd: EXEC function
Couldn't find any help about using Exec() function with correct usage; I have a table that use it's one dataset but I need a field outside the table to reference that table field, so I used the proposed solution http://www.telerik.com/help/reporting/expressions-functions.html, I don't get any error in the report but the value isn't shown either !!
3rd: Grouping
I can't see how can I create grouping in the same scenario where I have a table with it's own dataset, or should I have the report reference the global dataset and use the tabular layout instead !!
I am evaluating telerik and having a very hard time because I am doing a demo in a few days but can't get through
any help will be appreciated
0
Hello Ubuntu,
Report localization is a part of application localization task. You should get familiar with creating resources for each culture you use. Also take a look at Report Viewers localization.
Using Exec() function requires understanding of the data scopes.
Each data item such as Table item has its own DataSource property and can be set to any report DataSource.
All the best,
Hrisi
the Telerik team
Report localization is a part of application localization task. You should get familiar with creating resources for each culture you use. Also take a look at Report Viewers localization.
Using Exec() function requires understanding of the data scopes.
Each data item such as Table item has its own DataSource property and can be set to any report DataSource.
All the best,
Hrisi
the Telerik team
BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >
0
Ubuntu
Top achievements
Rank 1
answered on 14 Sep 2012, 04:21 PM
Dear Hrisi,
I failed to do the demo with Telerik reporting tools, so let's cool down.
I think reports in telerik still need a lot, let me explain:
The report I am working on should be displayed in English and Arabic, first If I need to use Telerik reporting I should consider the English
layout to be exactly as it should be in Arabic (if you understand what I mean). the layout should be from right-to-left in English !!! why..
Because in printing the report will be printed as in the designer not as it shown on the screen, which is not accepted at all.
How should I convince the client that the report will be printed okay, while on the screen it isn't ....
If I localized the report to Arabic, then I need to go back to the original English to delete any column and add a new one, the layout
in Arabic is screwed !!!
The changes for the text alignment is set through styles to be to the right, but when printed is displayed aligned to left !!!
It is fixed if I do the opposite and put the alignment to be left at the design !!!
It is not the way to work with the reports, should I be considering this all or focusing on the report development and other consideration.
I hope you can have answers to my questions, I don't have much time ....
Best
I failed to do the demo with Telerik reporting tools, so let's cool down.
I think reports in telerik still need a lot, let me explain:
The report I am working on should be displayed in English and Arabic, first If I need to use Telerik reporting I should consider the English
layout to be exactly as it should be in Arabic (if you understand what I mean). the layout should be from right-to-left in English !!! why..
Because in printing the report will be printed as in the designer not as it shown on the screen, which is not accepted at all.
How should I convince the client that the report will be printed okay, while on the screen it isn't ....
If I localized the report to Arabic, then I need to go back to the original English to delete any column and add a new one, the layout
in Arabic is screwed !!!
The changes for the text alignment is set through styles to be to the right, but when printed is displayed aligned to left !!!
It is fixed if I do the opposite and put the alignment to be left at the design !!!
It is not the way to work with the reports, should I be considering this all or focusing on the report development and other consideration.
I hope you can have answers to my questions, I don't have much time ....
Best
0
Hi,
Please open a support ticket and provide us with a sample project that exhibits the problems you've encountered with steps we should follow to reproduce them. Then we can answer your concerns accordingly.
All the best,
Steve
the Telerik team
Please open a support ticket and provide us with a sample project that exhibits the problems you've encountered with steps we should follow to reproduce them. Then we can answer your concerns accordingly.
All the best,
Steve
the Telerik team
BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >
0
Ubuntu
Top achievements
Rank 1
answered on 24 Sep 2012, 04:25 PM
Hello Steve,
I believe you have a track of this already opened ticket (573144).
Best
I believe you have a track of this already opened ticket (573144).
Best