Home

Products
       NCAA Tourney
       Loan Calculator
       Text / HTML Versioner
       HTML Fader
       HTML Scheduler
       SQL Reporting Services
       MySkype

Support & Forums
Saturday, May 19, 2012 You Are Here: Support & Forums  | 
Welcome to Module Masters support forums - the primary support mechanism for our products. Feel free to post your questions, and we will aim to respond in a timely manner.  We also encourage our users to post any feedback you may have.  You may also email us directly at service@modulemasters.com
Forums > Module Masters Forum > SQL Reporting Services
Subject: Work with two databases
Prev Next
You are not authorized to post a reply.

Author Messages
muniappanUser is Offline

Posts:53
08/06/2007 11:00  

Hi,

I want to do the following,

1. I have to check the portalAdmin parameter is true / false. If true, I can proceed with regular reporting process.

2. If false, then I have to connect to the first database and check whether the user is a corporate user. If yes, I can proceed with regular reporting process.

3. If no, then I have to connect to the second [main] database and select only the stores that are applicable to the user and show it in the drop down box. Stores is the multi select parameter in my report.

Thanks,

Muniappan Kandasamy
hostUser is Offline

Posts:502
08/06/2007 12:08  
This module can pass report parameters down to your report for portaladmin and for userid, what you do with them from there is up to the logic you have contained in your report. I suppose in theory, you could do all of this within the report by adding some additional .NET code to the report to extend the report.
muniappanUser is Offline

Posts:53
08/06/2007 15:59  
I can do all the above in the custom function. Then the custom function will return the dataset contains all stores or only the applicable stores to the user. Store is the multivalue parameter for that i am using dataset to provice the values. Can I use the dataset returned by the custom function for the store multi value parameter?[to fill drop down]
hostUser is Offline

Posts:502
08/06/2007 22:28  
I am not certain I understand what you are asking.
You are not authorized to post a reply.
Forums > Module Masters Forum > SQL Reporting Services > Work with two databases


ActiveForums 3.7
Copyright 2011 by Module Masters Privacy StatementTerms Of Use