Showing posts with label sort. Show all posts
Showing posts with label sort. Show all posts

Wednesday, March 21, 2012

how to align data

I am not sure what combination or item from my toolbox to do the follwing in my ssrs 2005 report:

I want sort of like a table that shows something like this:

label1 value1

lable2 value2

label3 value3

I tried dragging a table but it has headers, footers, details...I don't want all that. I ended up having to use a combination of textboxes to do all this but the values don't really align well with the label textbox. Also, this is going to be exported to Excel so I am also worried they will also not align correctly after this report is exported into Excel.

the values are 3 individual values, not all from the same DataSet so I'll be putting in expressions for each...I just want to know the best way to create a grid like this other than using the table in the toolbox to create a standard report.

Drag and drop table. Delete the header and footer. Drag the fields in the detail part and select the entire row, set border property to show like grid, use the align property to align text.

Hope this help.

|||AZ-xyz, thanks for the reply. I did actually try that before I posted. The problem though is that the details repeated itself so I ended up wtih repeated fields all the way down. So I figured well, then maybe I need to add those 3 lables and values in a group...tried adding 3 groups but that didn't work...don't remember why but maybe I'll try groups again.|||I think you need to use textboxes for all the six items

Wednesday, March 7, 2012

How to Add an event to CRI controls

Hi all,

I am trying to develop a CustomReportItem similar to Matrix control. Is it possible to add some "OnClick" sort of events to a section of this CRI (As a drilldown button of matrix control allows to expand the respective column).

Please help me if there can be any solution.

I think it not possible to do that.

Report is web page , is not the application window.

sort the date, you can add a sort report parameters,

different parameters, show different matrix.

|||

Are you asking about design time or runtime?

While the CRI runtime control can generate drillthrough actions based on an image map, currently you cannot fully simulate the matrix group toggle behavior. You would rather need to work around it with report drillthrough actions and encoding the toggle state in parameter values.

-- Robert

|||

Hi Robert,

Thanks for ur response

I am asking it for runtime. How can I encode the toggle state in parameter values and how will it help to solve my problem? Please explain, as I am new to this tool.

|||

For every toggle icon, you could use a boolean report parameter to encode its state (e.g. expanded = true, collapsed = false). Another option is to encode the state of multiple toggles into an integer parameter (by using it as a bitfield) or maybe as string parameter.

For the CRI runtime control you would need to pass the parameter values as custom property values so that you can see the current toggle state (i.e. report parameter values) from within your CRI runtime code. Then you would need to draw the toggle icons as part of the image generated by the CRI runtime control. In addition you need to generate an image map over the toggle icon with a drillthrough action that drills to the same report with a report parameter value that has the opposite value of the currently drawn toggle state.

For example, if there is only one toggle and the toggle icon drawn is shown as expanded (with a report parameter representation as =True), you would add an image map area with a drillthrough action that passes the report parameter with the boolean value =False.

-- Robert

How to add a URL to a ASP page into the Reporting Services folder

I want to add the URL to a ASP page into the Reporting Services Folder.
We are sort of using the Reporting Services as a portal to our other
reporting applications. I want to include the URL to a ASP page in a
reporting services folder not sure how to do this.
Please help with a simple URL scenario.
Thanks
Karenfirst add a web reference to ASP project
then define parameters of Reporting Service.render()
the url is a parameter of that function.
it works well on ASP.NET
but i do not know whether it is available on ASP|||Sorry, all I want to do is add an HTML page URL link to a reporting
services folder. I could not find much information on how to do this in
report manager.
Thanks
Karen|||the url is like that http://localhost/ReportServer?/sample
rs/Nametag&rs:Format=pdf
some of the url parameters are BookimakrID,DocMap, EndFind,FallbackPage|||So how do I publish the link to a URL into the Report Folder
Thanks
Karen|||All I want to do is put URLs to other applications and HTML pages into
the RS Folder. So sort of I want to use it as a portal not just as a
means to reach only reports
Thanks
Karen|||The only way I am aware of how to do this is to add a page that has the
links. You can create an HTML page and then add it to your report project
and deploy it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<karenmiddleol@.yahoo.com> wrote in message
news:1131673239.202311.213960@.f14g2000cwb.googlegroups.com...
> All I want to do is put URLs to other applications and HTML pages into
> the RS Folder. So sort of I want to use it as a portal not just as a
> means to reach only reports
> Thanks
> Karen
>