I need display some processes (lines in a chart) in the report. One process
per chart. The number of processes is not known at the design time and is
defined by the result of the underlying report query, so I do not know how
many chart objects to place on the report at design time. Is it possible to
add charts dynamically to the report during the run time?
Any hint would be greatly appreciated.
Thanks.Maybe this will help!
I create a group (detail) line and I add a chart to this group by defining a
chart in one of the text boxes...
hen do the normal things with a chart - but the chart is automatically
GROUPED for you based upon the results of your query (in line or T-SQL)
"Simon Gold" wrote:
> I need display some processes (lines in a chart) in the report. One process
> per chart. The number of processes is not known at the design time and is
> defined by the result of the underlying report query, so I do not know how
> many chart objects to place on the report at design time. Is it possible to
> add charts dynamically to the report during the run time?
> Any hint would be greatly appreciated.
> Thanks.
>
Showing posts with label processes. Show all posts
Showing posts with label processes. Show all posts
Wednesday, March 21, 2012
Friday, March 9, 2012
Dynamically create a snapshot
We would like to dynamically create a snapshot, based on other events. We
have snapshots based on tables which are created from overnight processes,
but which can sometimes overrun. Snapshots scheduled to run at fixed times
can then fail because the tables don't yet exist.
Any thoughts on this please ?
Thanks in advance.
--
Mike StephenMike,
Reporting Services has a web service method named
CreateReportHistorySnapshot. You can create a script to call this method
programmatically...
Searching for the method name in books online will get you started, then you
can back up into the Web services and scripting calls.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Mike Stephen" wrote:
> We would like to dynamically create a snapshot, based on other events. We
> have snapshots based on tables which are created from overnight processes,
> but which can sometimes overrun. Snapshots scheduled to run at fixed times
> can then fail because the tables don't yet exist.
> Any thoughts on this please ?
> Thanks in advance.
> --
> Mike Stephen
have snapshots based on tables which are created from overnight processes,
but which can sometimes overrun. Snapshots scheduled to run at fixed times
can then fail because the tables don't yet exist.
Any thoughts on this please ?
Thanks in advance.
--
Mike StephenMike,
Reporting Services has a web service method named
CreateReportHistorySnapshot. You can create a script to call this method
programmatically...
Searching for the method name in books online will get you started, then you
can back up into the Web services and scripting calls.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Mike Stephen" wrote:
> We would like to dynamically create a snapshot, based on other events. We
> have snapshots based on tables which are created from overnight processes,
> but which can sometimes overrun. Snapshots scheduled to run at fixed times
> can then fail because the tables don't yet exist.
> Any thoughts on this please ?
> Thanks in advance.
> --
> Mike Stephen
Subscribe to:
Posts (Atom)