PortalId Substitution - anyone got it to work? > Module Master Support Forums

Unanswered Active Topics

Forums Search

Forums > Module Masters Forum > SQL Reporting Services

Subject: PortalId Substitution - anyone got it to work?

Prev Next

You are not authorized to post a reply.

Author

Messages

nick chance User is Offline

Posts:2

05/01/2008 12:15
After looking through this forum I am struck by the number of people with PortalId/UserId Parameter problems, from developers who invariably have asked you to provide some document that covers this subject. I cannot understand why you don't. I have written several times to you and several times you have very kindly replied without really understanding my question and, consequently, I have got nowhere with your support. The issue must be a common enough problem and for the benefit of your readers I will outline it:- I have a report that can be generated from several database events and each of these events has a portal identity. I need to produce a Cascaded Parameter, 'PortalId', to pass back to the DataSet that Report Server uses to populate the Events dropdown, in order to limit the option of reports to those that pertain to that portal. Having selected the Event the user may then hit the View Report. Quite simple really, but I have been trying for several days to pass back PortalId.Value, including (portalid.value, PortalID.value, PORTALID.value plus many other combinations), which the RS2005 Report Viewer is supposed to substitute, at least, so I am led to believe. But I can't make it work. I have tried making the Report Parameter hidden and internal but again to no avail. I have created the parameter through a Select Dataset to make sure that the Cascaded parameters actually work and they do. So, when I then set PortalId then to hidden (or internal) then nothing gets substituted by DNN RS2005. I cannot believe that the developers have never tried this most common of all Report requirements. If so, why do they keep it such a well-guarded secret as to how it is achieved? Why not provide an exhaustive document of examples that show how this works. In view of the number of queries regarding this subject, if I am thick, then I am in good company. Nick Chance, Developer, and currently heading for a mental breakdown. [Incidentally, on the subject of issues, the Preview button below only showed half my message when I clicked it. When I attempted to go back and post the message, the whole thing went tits up and I've had to re-enter the whole message again. Perhaps it needs testing?]

host

Posts:497

05/01/2008 12:39
Nick, sorry for your troubles here, agree that you have had way more headaches than are due for such a trivial task. We have plenty of customers who are passing a mixture of userid and portalid implicitely via the built in DNN session pararmeters in addition to the querystring. I will review the email chains yet again and see if I can mock up an example of how this is done and supply this example here. It will be for the adventureworks sample database which I mock an example up for how portalid works. Hopefully this suffices for your needs?

host

Posts:497

05/01/2008 12:39
Oh, and regarding the forums issue, we use the activeforums module, it is probably the most popular third party forums module for DNN, we did not write it :)

host

Posts:497

05/02/2008 06:57
Nick, sent you an email, I think see the issue with your situation after review of your emails, best we have a conversation to clear this up as this is not an issue with our module but instead your report you are trying to deploy.

nick chance User is Offline

Posts:2

05/06/2008 08:57
Many, many thanks BEN for all of your help and support. Your example has helped enormously, as well as the advice you gave about utilising a sproc rather than in-line text sql, which seems to have been the key to unlocking this. To anyone else who gets the awful A critical error has occurred. The report parameter 'UserId' is read-only and cannot be modified. (rsReadOnlyReportParameter) May I suggest that you try using a sproc. Again many thanks Ben for terrific support and patience. See you at the Indy 500. Nick

paaschp

Posts:3

04/26/2010 15:37
So what if I am using a sproc and I am still getting this error. Mine is on PortalID

host

Posts:497

04/26/2010 15:42
It doesn't matter if the report is using a sproc or a sql query, all that matters is it finds a match, case is important in general when working with parameters, so as long as you have a parm called "PortalId" the current portal id will be passed at runtime to the report.

paaschp

Posts:3

04/26/2010 16:26
Yes but I recieve the same error as the one listed above. The report parameter 'PortalID' is read-only and cannot be modified. (rsReadOnlyReportParameter) Are these case sensitive? I noticed in the documentation it is PortalID in the above reposone it is PortalId, lower case d. I build my sproc on the documentation so perhaps one of them is incorrect. Just to test I just just updated everything to lower case "d" and it works. You should update the documentation shipped with the module.

host

Posts:497

04/26/2010 16:31
So you are good to go now or you still have the read only message?

You are not authorized to post a reply.

Forums > Module Masters Forum > SQL Reporting Services > PortalId Substitution - anyone got it to work?

ActiveForums 3.7