Telerik Forums
Reporting Forum
1 answer
283 views
TableAdapter configuration wizard and QueryBuilder give confusing error messages when SQL parameters are used in a query.

If you don't declare a parameter in your SQL statement, the wizard tells that
Must declare the scalar variable @Parameter

On the other hand, if you put in a declare statement and open QueryBuilder, it gives you a syntax error:
The Declare SQL construct or statement is not supported

I don't know if this is something you guys can do anything about. You can get through the wizard by adding a parameter declaration and that's about it.

The real problem is that in order to get the report working, you have to manually remove the parameter from the DataSet designer file and add it to the DataSetTableAdapter Fill function. Otherwise, the report does not run.

Or is there a way to use TableAdapter wizard with SQL paremeters without touching the designer files?

-mika-


Steve
Telerik team
 answered on 08 Apr 2009
2 answers
216 views
I have a master report with one sub report. In the master report I created properties that my web applications sets for the report parameters. In the needdatasource sub of the master reports I simply populate the dataset based on the properties set.

Now I have added a sub report and I am trying to set the properties in the sub report in a similar manager. I tried passing the values in the sub reports needsdatasource (fired in the master report) and cannot get the values to pass over. Is there any easy way to pass values from the master report to the sub report? I have tried everything I can think of including parameters.
Chris
Top achievements
Rank 1
 answered on 07 Apr 2009
3 answers
250 views
Hi

I'm trying to deploy a report with html output that has quite a lot of images inside. Some are imported bitmaps, some are generated by reporting engine. At the end all the images are "static" e.g. the same in all the reports. As we have quite number of reports and they get sent around a lot we thought it to be a great idea to have all the images linked from a public web server. Would that be possible?

The other problem is that html export places calls to local resource urls for image sources (&StreamID=pwpejk4p1st) that we can't find a way to overcome (didn't find a clue in documentation nor forums). If we could solve the first thing probably it would also help here. Thank you.
Hrisi
Telerik team
 answered on 07 Apr 2009
2 answers
118 views
hello

i am using the reporting successfully but keep getting an error lately.
it is a known error that serialization is not possible in asp state server. i had this error before and fixed it using the forums here with replacing some types that can handle serialization.
but now the same website with same assemblies works on my development machine and on one website of our hosting servers.
but on another website on the same server i am getting the serialization error.

do you have any hint where the problem might be? maybe a rights issue within the os?
or do you have a suggestion how to test where the issue is?

this is crucial because we just started publishing our website for a new customer and now the reporting does not work

any help highly appreciated
regards
Ibrahim Imam
Top achievements
Rank 1
 answered on 07 Apr 2009
3 answers
1.0K+ views
Hi
    When i have groups in a report,and i want to show sum of one column just like following:
   
    name         subject          score
    kate            English          88
    kate            math              100
    kate            chinese         90
    kate           total               278(sum of score above)

    name         subject          score
    lily              English          80
    lily              math              90
    lily              chinese         100
    lily              total               270(sum of score above)

How can i do?

Thanks.
3ms
Top achievements
Rank 2
 answered on 07 Apr 2009
2 answers
122 views
The report viewer is there, so is the report header, but the data does not show up. It works on my local box. I checked the connection string.

What am I missing
Steve
Telerik team
 answered on 07 Apr 2009
1 answer
141 views
Dear support,

Recently I switched from the 2008Q3 release to the 2009Q1 release and noticed that it is not possible anymore to refresh the report anymore. In the previous release I could refresh the report by setting the ReportViewer.Report property to the new report. The report was refreshed if I did a reassignment upon postback of the page.
However after upgrade to the 2009 release the report is not refreshed anymore, it will stick to the initially loaded report. 

How to get this solved?

Best regards,

Daniel van Oostveen
Steve
Telerik team
 answered on 07 Apr 2009
1 answer
155 views
I'm anxious to ditch Crystal Reports and start working with Telerik in production but i first need to convert all my reports to Telerik. Problem is, i had some wacky reports but i'm sure there is a way to reproduce them. See the pic below before moving on :

http://s734.photobucket.com/albums/ww342/crazycoders/?action=view&current=crystallayout2.jpg

This layout, although it looks like it's displayed horizontally is actually displayed vertically like any other reports, but what we used was to simply detect group changes based on the employee name and service name and in the details section we'd hide the field that gets repeated for nothing.

In Telerik, i though i could achieve this doing the following: (Note that PreviousEmployeeName and PreviousServiceName as simple Strings declared private at the top of the report object)

    Private Sub Details_ItemDataBound(ByVal sender As ObjectByVal e As System.EventArgs) Handles Details.ItemDataBound 
        If PreviousEmployeeName = "" Or PreviousEmployeeName <> EmployeeName.Value Then 
            PreviousEmployeeName = EmployeeName.Value 
            PreviousServiceName = "" 
        Else 
            EmployeeName.Value = "" 
        End If 
    End Sub 
 
    Private Sub ServiceName_ItemDataBound(ByVal sender As ObjectByVal e As System.EventArgs) Handles ServiceName.ItemDataBound 
        If PreviousServiceName = "" Or PreviousServiceName = ServiceName.Value Then 
            PreviousServiceName = ServiceName.Value 
        Else 
            ServiceName.Value = "" 
        End If 
    End Sub 

But this doesn't do what i would have expected it to do... instead it does the following:

http://s734.photobucket.com/albums/ww342/crazycoders/?action=view&current=teleriklayout2.jpg

And you can see in this picture that the employee name seems to repeat twice then stops but the service name never stops repeating. I don't think my logic is all that bad.. can someone help me try to achieve that layout?

Thanks




Ivan
Telerik team
 answered on 06 Apr 2009
3 answers
248 views
I am trying out Telerik Reporting component and currently have a problem that I hope to get some help with.

I have everything setup in my application and the report seems to work on first pass.  After I make changes to my database via the application, e.g. My application assigns an asset to a person, none of my associated reports show the changes in the database.  Other portions of my application do reflect the change indicating that the changes are successful, but my Telerik reports do not see the changes.  The only I can get the reports to reflect the changes is by restarting my application.  This obviously will not be an acceptable behavior.

I was hoping someone can help me with this.

Thanks in advance.  Prompt responses are definitely appreciated.
KNana
Bob
Top achievements
Rank 1
 answered on 04 Apr 2009
5 answers
189 views
Hi,
I've been trying the report tool (v1.1). My data was generated by the radeditor which has embedded html markup in it. When the report is generated it shows the data just fine. When I try to export the data to pdf or tiff, the html markup is shown literally. When I attempt to export to a web archive, the html markup is ok (as expected), except I have <img> tags that are not resolved (I get the red X). I have the HtmlRendering.dll, ImageRendering.dll and WebForms.dll in my bin directory of the app.

I'm I missing something required to have my markup rendered correctly including images?

Thanks,
Bruce
Steve
Telerik team
 answered on 03 Apr 2009
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?