Prologika Forums

Hi Teo,

Your books are great, simple the best.

I got an idea how to pass data from report to subreport and vice versa but I don't know how to implement it. I want to fill Array (or Hashtable, or something) in report and pass it to subreport. Is it possible for report and subreport to share some memory?

BTW, forum paging doesn't work if from More Options, under Date Filter choose Show All.

Best regards

Nikola

To make myself more clear: I'm thinking of making Shared memory by DLL like it is done here

http://msdn.microsoft.com/en-us/library/ms686958(VS.85).aspx

Is that good idea?

I haven't tried but I don't think it will work because the subreport is processed as a separate report so no static variable sharing. The only supported option is to pass parameters from the master to the subreport. There is no option to send information back from the subreport to the master report. What are you trying to do exactly?

BTW, thanks for reporting the issue with paging. It may have happened after the upgrade to CS 2008. I need to research it.

Thanks for reply,

I still think it is possible but I cannot make it work with Reporting.

Here is nice VB.NET class which I use to implement Named Shared memory.

http://www.codeproject.com/KB/files/MemMap.aspx

I will let you know if I manage to make it work.

Nikola

If you provide more details about your report requirements, perhaps I could advise a different approach.

Thanks for your replies,

1st) Example and class with Shared memory works fine. But API function CreateFileMapping doesn't see already opened file mapping object when class is compiled as DLL and referenced by Report. Same problem with OpenFileMapping API. I guess that Reporting service blocks memory access for custom dlls. I need to investigate more on that. Do you know something more?

2nd) Here is simplified explanation what I'm trying:

I have to make conversion rate report for user selection and to make evaluation of it by comparing company Total sales data to user selection. Total sales data is long running query which runs every week. I want to use snapshot of report as storage for Total sales data instead to keep data in temporary table. That way I don't have to write user interface for administration but admins can use Report Manager. Total sales data should be subreport of desired conversion rate report. So I need a way to return conversion rates of Total sales data (which are in subreport) back to main report.

I already have different approach, thanks to you and your Reporting book. I will use XML dataset to get Total sales data.

New question: Is it possible to make something like sql views with datasets in report?

Thanks again

Nikola

1. If you comment the following line in the Report Server web.config, does it work?

<

trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />

2. With the risk I don't understand your scenario quite well, I'd gravitate toward materializing the dataset to disk instead of trying to figure out a way to pass data back from a subreport.

Hi Teo,

1. No luck, still same problem. I must find document about memory management of Reporting service.

2. Ok. My idea is to use snapshot of report as a place for materializing the dataset to disk. That way I can use Report manager as a admin tool (instead to write my own tools) to control execution history, set schedules, review created dataset, ...

Thanks for all your help

Nikola

Hi Teo,

1. I made it work, thanks for your help. I can send you example if you want it. It transfers data from report to subreport and vice versa.

Regards

Nikola