Re: SSRS 2008 reports in Silverlight 4 apps - WPF Discussion Boards

SSRS 2008 reports in Silverlight 4 apps

26-Oct-11 12:19

Hi All,

in anyways if I could do that or any one could give me some code or a link, it would have been better for me.

Thanks,
Abdul

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

arkiboys26-Oct-11 5:21

arkiboys

26-Oct-11 5:21

Hi,
I am currently developing in windows form and can display the SSRS reports using the ReportViewer control...

Question:
1- Is it possible to display the SSRS reports via silverlight 4?
2- IS it as same as using the report viewer control as I do in windows forms?

Thanks

Mark Salsbery26-Oct-11 5:45

26-Oct-11 5:45

No report viewer included in Silverlight 4.

Maybe some ideas in these....

Implementing SSRS in Silverlight 4[^]

Silverlight Reporting Support for SSRS reports – Problem and Possible solutions[^]

Mark Salsbery
Java | [Coffee]

Mycroft Holmes26-Oct-11 14:10

Mycroft Holmes

26-Oct-11 14:10

As Mark said there is no native report viewer in Silverlight. There is a 3rd party one available but it is expensive and only works with server based reports.

As I need embedded reports (RDLC) so I spawn an ASPX page passing the parameters in the url, while this works it is not satisfactory as the values are exposed and the spawned page just feels flaky. However it does give me a reporting solution in Silverlight, there are some articles on CP that helped.

Silverlight Report Viewer using View Model (MVVM)[^]

Integrate Reporting Services with Silverlight and RIA Services[^]

Never underestimate the power of human stupidity
RAH

arkiboys26-Oct-11 23:41

arkiboys

26-Oct-11 23:41

Do you mean I can add an .aspx page into my silverlight application and have the report viewer control inside the .aspx page and then call the .aspx from the silverlight page?

Mycroft Holmes27-Oct-11 0:51

Mycroft Holmes

27-Oct-11 0:51

This lives in the VM for my reports dialog

private void doReport(object o)
{
    string sReport = o.ToString();
    string sURL, sCriteria = string.Empty;
    switch (sReport)
    {
        case"EquipmentList":
            sCriteria = GetCriteriaEQ();
            break;
        case "EquipmentFleet":
            sCriteria = GetCriteriaEQFleet();
            break;
        default:
            break;
    }

    sURL = VML.ReportsVMStatic.GetReportsAddress(sReport, sCriteria);
    gUI.ShowWindow(sURL);
    AppMessage.DialogCompleted.Send(AppMessage.DialogCompleted.enDialogResult.eTrue);
}

GetCriteria returns a string with the criteria formatted specifically for a report and showwindow openns the aspx page

HtmlPage.Window.Navigate(oURI, "_blank");

The page_load of the aspx deals with the query string and gets the data from the database to service the RDLC. As I said ugly but works.

Never underestimate the power of human stupidity
RAH

arkiboys28-Oct-11 4:38

arkiboys

28-Oct-11 4:38

Hi,
I studied the link you sent. thanks.
It seems that a new form should be added to the silverlight project which then shows the SSRS report in a popup format?

Display list content

columbos1492725-Oct-11 23:13

columbos14927

25-Oct-11 23:13

Hello,
Is there some control in WPF that i can use to display a list.

For example i have a list of objects where each object have some number of properties.
I wannt to give this list to the control and he will display each object properties in a row when every propertie displayed in a separate column.

So my question is is there some control already in WPF.
If not i will have some how to create one but in order to create i have to know how many properties object has,how can i do it?

Thanks.

Pete O'Hanlon25-Oct-11 23:33

Pete O'Hanlon

25-Oct-11 23:33

You could use a DataGrid and set AutoGenerateColumns="True" on it. This assumes that all your properties can be displayed textually - if you have images to display, for instance, you are going to have to take over control yourself. WPF can only go so far.

Forgive your enemies - it messes with their heads

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Member 103390726-Oct-11 3:22

Member 1033907

26-Oct-11 3:22

Check out ListView, it is customizable to some degree (with AutoGenerateColumns=false) and it will probably serve you just fine.

Member 103390726-Oct-11 4:24

Member 1033907

26-Oct-11 4:24

What is the difference/benefit between this and using ListBox? I thought ListView was supposed to be used with views (ViewBase-derived objects), like GridView - isn't that the case?

Member 103390726-Oct-11 5:02

Member 1033907

26-Oct-11 5:02

What I meant (and also in my replay to OP) is that ListView (as opposed to ListBox) can be used this way

<ListView>
  <ListView.View>
    <GridView>
      <GridViewColumn DisplayMemberBinding="{Binding FirstName}" Header="First Name" />
      ...
    </GridView>
  <ListView.View>
</ListView>

where the individual columns can be either autogenerated or more or less customized. Which I assume is what the OP wanted. This displays the "grid-view" known for example from file explorer if you select display mode->details.
This is (I think) the primary purpose of ListView.

String Formatting in XALM, Silverlight

SledgeHammer0126-Oct-11 8:46

SledgeHammer01

26-Oct-11 8:46

There is a huge difference between ListView and ListBox. ListBox just displays a flat list of items whereas ListView supports columns, grouping, etc.

chrisndirangu25-Oct-11 21:30

chrisndirangu

25-Oct-11 21:30

Well, I had this problem where I got so many answers but they couldn't work together as I desired.

Now, I have a decimal (money) field from my repository.

After binding my collection to a grid using the Galasofts Mvvm framework, I want +ve values to take the #,###,###.## format and the -ve values to take the (#,###,###.##) format. Zero values will then take #.## format. All this formatting I want to happen in the xaml. Not in my view models.

Most solutions offered money formatting but the has the dollar sign, and we dont use dollars. Others wont cater for the negative value, and others will not cater for the decimals.

So the best solution is

“#,0.00;(#,0.00);0”

The first bit is the format for positive numbers.

The second bit is how negative numbers are displayed

The third bit is for zeros

Practical example:
Binding="{Binding Amount, StringFormat=#\,0.00;(#\,0.00);0}"

Re: String Formatting in XALM, Silverlight

Mycroft Holmes25-Oct-11 21:39

Mycroft Holmes

25-Oct-11 21:39

I love these, are we supposed to guess the question or telepathically download the requirement form the ether. This being a forum where you can get answers, it is common to ask a question to get a reasoned response (unlike this sarcastic missive).

On the other hand if this is a 'suggestion' and you are trying to help others (having beaten the internet into submission getting the answer) then I suggest you present this as a Tip/Trick where it can be dealt with correctly and will actually help other.

Never underestimate the power of human stupidity
RAH

Wrapping Text in Canvas

indian14325-Oct-11 13:43

25-Oct-11 13:43

Hi All,

I am new to the Silverlight world. can anybody please help me in wrapping the text in the textblock which is there in the Canvas.

Is there any way to do it, please help me.

Thanks in Advance.

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

modified 25-Oct-11 20:56pm.

Mark Salsbery25-Oct-11 17:18

25-Oct-11 17:18

Set the TextBlock's TextWrapping property to TextWrapping.Wrap. A Canvas parent won't resize or clip the TextBlock so you'll need to handle that yourself.

Mark Salsbery
Java | [Coffee]

indian14325-Oct-11 17:23

25-Oct-11 17:23

But if I use anyother container like stackpanel or grid then the text is taking all the browser width and making all the page uncomfortable.

What can I do, can you please help me, I am working around it, any link or any kind of help is greatly appreciated.

Thanks in advance. In no way I am getting it, please help me.

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

Mark Salsbery26-Oct-11 5:37

26-Oct-11 5:37

Set the width and height of the textblock explicitly.

Mark Salsbery
Java | [Coffee]

indian14326-Oct-11 6:15

26-Oct-11 6:15

Hi,

Can you please help me little bit by using any link or code snippet please.

I request you, I have been trying it so severely.

Thanks,
Abdul.

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

Mark Salsbery26-Oct-11 7:31

26-Oct-11 7:31

<TextBlock TextWrapping="Wrap" Width="100" Height="100" Canvas.Left="20" Canvas.Top="20" />

Mark Salsbery
Java | [Coffee]

indian14326-Oct-11 7:58

26-Oct-11 7:58

Hi,

This width should depend upon the parent elements width or it should depend upon the ViewModel property that is binding to this textblock.

According to any of them it should able to take the value and wrap the text and fit within the browser but should not stretch beyond the browser size or monitor size.

Thanks,
Abdul

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

Mark Salsbery26-Oct-11 8:17

26-Oct-11 8:17

indian143 wrote:
This width should depend upon the parent elements width

Then a Canvas isn't necessarily the proper parent element - it rarely is except for drawings and shapes etc. There's better panel elements for layout if you don't need pixel-level positioning.

If you must use a canvas then you could handle the canvas' SizeChanged event and in your handler code resize and/or reposition the textblock based on the values of the canvas' ActualWidth/ActualHeight properties.

Mark Salsbery
Java | [Coffee]

indian14326-Oct-11 12:18