Accessing report parameters from code module can it be done?

I'm trying to get around a problem where my client wants to have totals from
each grouping in the report table displayed at the top of the report body
above the report table. It's easy to see why you can't just grab values from
the grouping footers and place them elsewhere. I had an idea to create some
report parameters and as the report is being rendered, run some custom code
that evaluates the field I'm trying to total and modifies the report
parameter I created for that specific total. Then I could use the report
parameter to display that specific total.
The problems with this are.. It seems that if I pass the parameter object
into the custom code function, it becomes read-only. Next, how would I be
able to tell the textbox that will show the total to wait to render until the
END of the report rendering. Lots of problems to try to overcome.
Basically, I need to take the value of a total in a subgroup (there are like
7 subgroups, so 7 different totals -- I can already take the ENTIRE report
total, but that's not what's neded) and copy it to a textbox either in the
report body ABOVE the report table.
Thanks for any tips.
--
Ken Fayal
Raptor Development Corp.I thought about this some and the only thing I can come up with is to have a
second dataset that has the same grouping and sums and reference the second
dataset at the top of the report. (By grouping I mean in SQL, not in RS).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ken Fayal" <ken@.raptordev.com.spamfree> wrote in message
news:5E4D812B-4868-44A7-BD79-F9E75C748F5C@.microsoft.com...
> I'm trying to get around a problem where my client wants to have totals
from
> each grouping in the report table displayed at the top of the report body
> above the report table. It's easy to see why you can't just grab values
from
> the grouping footers and place them elsewhere. I had an idea to create
some
> report parameters and as the report is being rendered, run some custom
code
> that evaluates the field I'm trying to total and modifies the report
> parameter I created for that specific total. Then I could use the report
> parameter to display that specific total.
> The problems with this are.. It seems that if I pass the parameter object
> into the custom code function, it becomes read-only. Next, how would I be
> able to tell the textbox that will show the total to wait to render until
the
> END of the report rendering. Lots of problems to try to overcome.
> Basically, I need to take the value of a total in a subgroup (there are
like
> 7 subgroups, so 7 different totals -- I can already take the ENTIRE report
> total, but that's not what's neded) and copy it to a textbox either in
the
> report body ABOVE the report table.
> Thanks for any tips.
> --
> Ken Fayal
> Raptor Development Corp.
>|||Bruce,
Thanks. What I ended up doing was create a subreport and put that at the
top. It works great. I guess I could have created another dataset, but he
subreport was easy because I had to use the same subreport in many other
reports.
"Bruce L-C [MVP]" wrote:
> I thought about this some and the only thing I can come up with is to have a
> second dataset that has the same grouping and sums and reference the second
> dataset at the top of the report. (By grouping I mean in SQL, not in RS).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Ken Fayal" <ken@.raptordev.com.spamfree> wrote in message
> news:5E4D812B-4868-44A7-BD79-F9E75C748F5C@.microsoft.com...
> > I'm trying to get around a problem where my client wants to have totals
> from
> > each grouping in the report table displayed at the top of the report body
> > above the report table. It's easy to see why you can't just grab values
> from
> > the grouping footers and place them elsewhere. I had an idea to create
> some
> > report parameters and as the report is being rendered, run some custom
> code
> > that evaluates the field I'm trying to total and modifies the report
> > parameter I created for that specific total. Then I could use the report
> > parameter to display that specific total.
> >
> > The problems with this are.. It seems that if I pass the parameter object
> > into the custom code function, it becomes read-only. Next, how would I be
> > able to tell the textbox that will show the total to wait to render until
> the
> > END of the report rendering. Lots of problems to try to overcome.
> >
> > Basically, I need to take the value of a total in a subgroup (there are
> like
> > 7 subgroups, so 7 different totals -- I can already take the ENTIRE report
> > total, but that's not what's neded) and copy it to a textbox either in
> the
> > report body ABOVE the report table.
> >
> > Thanks for any tips.
> >
> > --
> > Ken Fayal
> > Raptor Development Corp.
> >
>
>

Accessing processing information

Hi,

We need to access some of the processing information that are displayed when processing from BIDS. Is there any way to access this info send it to the event viewer (or anywhere) when processing a cube from the command-line?

I would like to see:

Processing start and end date

Error information if any

what are the dimensions/cubes processed

How many records were processed

TIA,

Aiwa

BIDS, SSMS and SQL Profiler establish a trace connection to the server and the server sends notifications.

Is your goal to write a program, which sends processing request and needs to capture the processing events or you already have some program and it needs to listen what the server does in response to that program's request?|||

I am hoping that there is an out of the box solution for this. We follow closely our DW processing and we would like to apply the same follo-up on our cube generation process.

We have developed some tools to do the DW generation follow-up but if an out of the box features exist to do that with AS2005 we would be more than willing to use it. Best case scenario would be to be able to capture processing events in the event viewer.

Thanks,

Aiwa

|||By "event viewer" do you mean SQL Profiler? When it is running it captures the trace events from all the clients you have. You can specify filters on the events.|||

Take a look at the ascmd utility that gives you ability to send processing commands and capture processing events in a log file.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.