Progress Bar in Table Cell

I'm creating a report with several columns. One of which is a percentage
value. The business people have asked that that column show a progress bar of
sorts to give a visual indicator of the percentage complete, in addition to
the textual %. I have tried to figure out how to do this in a table cell but
to no avail. It appears that you can't use an Expression to set the sizing of
an image, rectangle, etc. Anyone have an idea on how this might be done?
Thanks!you could try a chart (one of the bar graphs that are horizontal based).Then
maybe format the chart to remove the legend, scale, title etc
"rSmoke" wrote:
> I'm creating a report with several columns. One of which is a percentage
> value. The business people have asked that that column show a progress bar of
> sorts to give a visual indicator of the percentage complete, in addition to
> the textual %. I have tried to figure out how to do this in a table cell but
> to no avail. It appears that you can't use an Expression to set the sizing of
> an image, rectangle, etc. Anyone have an idea on how this might be done?
> Thanks!|||I had tried that, except you can't put a chart in a table cell. However, your
post led me to try a subreport with a chart in it. That works great. I had
tried a subreport before but hadn't thought to try a chart in it. Thanks for
the help.
"NH" wrote:
> you could try a chart (one of the bar graphs that are horizontal based).Then
> maybe format the chart to remove the legend, scale, title etc
> "rSmoke" wrote:
> > I'm creating a report with several columns. One of which is a percentage
> > value. The business people have asked that that column show a progress bar of
> > sorts to give a visual indicator of the percentage complete, in addition to
> > the textual %. I have tried to figure out how to do this in a table cell but
> > to no avail. It appears that you can't use an Expression to set the sizing of
> > an image, rectangle, etc. Anyone have an idea on how this might be done?
> > Thanks!|||Note: you can put a chart inside a table group header or group footer. In
that case, the chart would be based of all data rows of that particular
group instance (which is what you typically want). The subreport approach
works but is usually not as efficient as table groups.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"rSmoke" <rSmoke@.discussions.microsoft.com> wrote in message
news:7CC6307F-077B-45A8-9BBD-18C451815AD4@.microsoft.com...
>I had tried that, except you can't put a chart in a table cell. However,
>your
> post led me to try a subreport with a chart in it. That works great. I had
> tried a subreport before but hadn't thought to try a chart in it. Thanks
> for
> the help.
> "NH" wrote:
>> you could try a chart (one of the bar graphs that are horizontal
>> based).Then
>> maybe format the chart to remove the legend, scale, title etc
>> "rSmoke" wrote:
>> > I'm creating a report with several columns. One of which is a
>> > percentage
>> > value. The business people have asked that that column show a progress
>> > bar of
>> > sorts to give a visual indicator of the percentage complete, in
>> > addition to
>> > the textual %. I have tried to figure out how to do this in a table
>> > cell but
>> > to no avail. It appears that you can't use an Expression to set the
>> > sizing of
>> > an image, rectangle, etc. Anyone have an idea on how this might be
>> > done?
>> > Thanks!

Progress bar for backup operation

Hi,
I am creating a simple form that user will backup his database using that. I
need to show a progress bar when the backup is in progress. How can I read a
value which indicates that? I saw that BACKUP statement has a STATS option,
but I don't know how to capture its value from the server and bring it to
client.
Any help would be greatly appreciated.
Thanks in advance,
Amin
Amin,
Use the Complete event of the Backup object in SQL-DMO.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Amin Sobati wrote:
> Hi,
> I am creating a simple form that user will backup his database using that. I
> need to show a progress bar when the backup is in progress. How can I read a
> value which indicates that? I saw that BACKUP statement has a STATS option,
> but I don't know how to capture its value from the server and bring it to
> client.
> Any help would be greatly appreciated.
> Thanks in advance,
> Amin
>
>
|||Amin,
Oops, I meant use the PercentComplete event of the Backup object. Ignore
my other post in this thread.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Amin Sobati wrote:
> Hi,
> I am creating a simple form that user will backup his database using that. I
> need to show a progress bar when the backup is in progress. How can I read a
> value which indicates that? I saw that BACKUP statement has a STATS option,
> but I don't know how to capture its value from the server and bring it to
> client.
> Any help would be greatly appreciated.
> Thanks in advance,
> Amin
>
>
|||Thanks Mark! That was great tip :-)
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OZDT9GabEHA.4092@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Amin,
> Oops, I meant use the PercentComplete event of the Backup object. Ignore
> my other post in this thread.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Amin Sobati wrote:
that. I[vbcol=seagreen]
read a[vbcol=seagreen]
option,[vbcol=seagreen]
to[vbcol=seagreen]

Progress bar for backup operation

Hi,
I am creating a simple form that user will backup his database using that. I
need to show a progress bar when the backup is in progress. How can I read a
value which indicates that? I saw that BACKUP statement has a STATS option,
but I don't know how to capture its value from the server and bring it to
client.
Any help would be greatly appreciated.
Thanks in advance,
AminAmin,
Use the Complete event of the Backup object in SQL-DMO.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Amin Sobati wrote:
> Hi,
> I am creating a simple form that user will backup his database using that.
I
> need to show a progress bar when the backup is in progress. How can I read
a
> value which indicates that? I saw that BACKUP statement has a STATS option
,
> but I don't know how to capture its value from the server and bring it to
> client.
> Any help would be greatly appreciated.
> Thanks in advance,
> Amin
>
>|||Amin,
Oops, I meant use the PercentComplete event of the Backup object. Ignore
my other post in this thread.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Amin Sobati wrote:
> Hi,
> I am creating a simple form that user will backup his database using that.
I
> need to show a progress bar when the backup is in progress. How can I read
a
> value which indicates that? I saw that BACKUP statement has a STATS option
,
> but I don't know how to capture its value from the server and bring it to
> client.
> Any help would be greatly appreciated.
> Thanks in advance,
> Amin
>
>|||Thanks Mark! That was great tip :-)
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OZDT9GabEHA.4092@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Amin,
> Oops, I meant use the PercentComplete event of the Backup object. Ignore
> my other post in this thread.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Amin Sobati wrote:
that. I[vbcol=seagreen]
read a[vbcol=seagreen]
option,[vbcol=seagreen]
to[vbcol=seagreen]

Progress bar for backup operation

Hi,
I am creating a simple form that user will backup his database using that. I
need to show a progress bar when the backup is in progress. How can I read a
value which indicates that? I saw that BACKUP statement has a STATS option,
but I don't know how to capture its value from the server and bring it to
client.
Any help would be greatly appreciated.
Thanks in advance,
AminAmin,
Use the Complete event of the Backup object in SQL-DMO.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Amin Sobati wrote:
> Hi,
> I am creating a simple form that user will backup his database using that. I
> need to show a progress bar when the backup is in progress. How can I read a
> value which indicates that? I saw that BACKUP statement has a STATS option,
> but I don't know how to capture its value from the server and bring it to
> client.
> Any help would be greatly appreciated.
> Thanks in advance,
> Amin
>
>|||Amin,
Oops, I meant use the PercentComplete event of the Backup object. Ignore
my other post in this thread.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Amin Sobati wrote:
> Hi,
> I am creating a simple form that user will backup his database using that. I
> need to show a progress bar when the backup is in progress. How can I read a
> value which indicates that? I saw that BACKUP statement has a STATS option,
> but I don't know how to capture its value from the server and bring it to
> client.
> Any help would be greatly appreciated.
> Thanks in advance,
> Amin
>
>|||Thanks Mark! That was great tip :-)
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OZDT9GabEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Amin,
> Oops, I meant use the PercentComplete event of the Backup object. Ignore
> my other post in this thread.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Amin Sobati wrote:
> > Hi,
> > I am creating a simple form that user will backup his database using
that. I
> > need to show a progress bar when the backup is in progress. How can I
read a
> > value which indicates that? I saw that BACKUP statement has a STATS
option,
> > but I don't know how to capture its value from the server and bring it
to
> > client.
> > Any help would be greatly appreciated.
> > Thanks in advance,
> > Amin
> >
> >
> >

Programmability of parameter bar(layout/items)?

Hi all,

does anybody of you know how to code and customize the parameter bar of the
SSRS reports? I know about putting code behind expressions but how is it with
parameters?

How is it possible to...
1. define the layout of the parameter bar and the positions of the parameter
items?
2. make the parameter items user-specific?

Is it possible to define a report with the report designer and hand over
data (parameters) by code-behind or a referenced assembly?

Thanks a lot for any help

Best Regards
Marc

Unfortunately, you can't do either of these things. (#1, #2, or the "hand-over" of parameter selection via Report Designer).

If the parameter selection needs to be as dynamic as you describe, the best solution is to actually build your own custom UI in which you display the appropriate parameter UI in the appropriate places to the appropriate users...Then take the values that get selected and pass them to the report via URL Access, or plug them into the ReportViewer with code, andrender the report in the viewer. www.gotreportviewer.com has samples of the latter.

Hope this helps!

|||

Hey Russell,

that's not really good news...but thanks a lot for your help anyway..i'm going to try the solution with passing parameters by code into the ReportViewer control.

Cheers
Marc

|||

Hi Marc,

I have a similar problem. Could you please explain how you were able to solve this problem.

Thanks a lot for your help.

Regards,

Simranjeev

|||You need to query the web service to find out which parameters a report has, their data types and values etc. then programatically populate dropdowns etc. and arrange them how you like in your custom UI. You can use either a web or a windows UI for this.|||

Thanks ... Can i find some article / sample code somewhere on how to build custom UI and use it as the Parameter Area in Reporting Services

Programmability of parameter bar(layout/items)?

Hi all,

does anybody of you know how to code and customize the parameter bar of the
SSRS reports? I know about putting code behind expressions but how is it with
parameters?

How is it possible to...
1. define the layout of the parameter bar and the positions of the parameter
items?
2. make the parameter items user-specific?

Is it possible to define a report with the report designer and hand over
data (parameters) by code-behind or a referenced assembly?

Thanks a lot for any help

Best Regards
Marc

Unfortunately, you can't do either of these things. (#1, #2, or the "hand-over" of parameter selection via Report Designer).

If the parameter selection needs to be as dynamic as you describe, the best solution is to actually build your own custom UI in which you display the appropriate parameter UI in the appropriate places to the appropriate users...Then take the values that get selected and pass them to the report via URL Access, or plug them into the ReportViewer with code, andrender the report in the viewer. www.gotreportviewer.com has samples of the latter.

Hope this helps!

|||

Hey Russell,

that's not really good news...but thanks a lot for your help anyway..i'm going to try the solution with passing parameters by code into the ReportViewer control.

Cheers
Marc

|||

Hi Marc,

I have a similar problem. Could you please explain how you were able to solve this problem.

Thanks a lot for your help.

Regards,

Simranjeev

|||You need to query the web service to find out which parameters a report has, their data types and values etc. then programatically populate dropdowns etc. and arrange them how you like in your custom UI. You can use either a web or a windows UI for this.|||

Thanks ... Can i find some article / sample code somewhere on how to build custom UI and use it as the Parameter Area in Reporting Services

Programmability of parameter bar(layout/items)?

Hi all,
does anybody of you know how to code and customize the parameter bar of the
SSRS reports? I know about putting code behind expressions but how is it with
parameters?
How is it possible to...
1. define the layout of the parameter bar and the positions of the parameter
items?
2. make the parameter items user-specific?
Is it possible to define a report with the report designer and hand over
data (parameters) by code-behind or a referenced assembly?
Thanks a lot for any help
Best Regards
MarcI don't know if this is the right way but I turned off the parameter bar and
added the following code
Dim parm As New
Microsoft.Reporting.WebForms.ReportParameter("week",
DrpWeeks.SelectedValue.ToString)
Dim p() As Microsoft.Reporting.WebForms.ReportParameter = {parm}
ReportViewer1.ServerReport.SetParameters(p)
DrpWeeks is a drop down box populated just as I would have if I had
populated it in the report designer.
User specific is by grabbing user!userid
"MarcBey" wrote:
> Hi all,
> does anybody of you know how to code and customize the parameter bar of the
> SSRS reports? I know about putting code behind expressions but how is it with
> parameters?
> How is it possible to...
> 1. define the layout of the parameter bar and the positions of the parameter
> items?
> 2. make the parameter items user-specific?
> Is it possible to define a report with the report designer and hand over
> data (parameters) by code-behind or a referenced assembly?
> Thanks a lot for any help
> Best Regards
> Marc
>
>