Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...

Or... now make it easy with Facebook Integration
Connect via Facebook

Top Sellers

Dynamic Registration 4.0

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery 4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

XMod Pro 2.7 - Forms and Views for Databases

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

Smith Shopping Cart v3.88

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

Event Calendar and Registration 4.0

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

DNN Modules

Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
Use DF to send parameters to a DNN Report
Last Post 09-20-2011 04:36 PM by Chad Nash. 9 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Mark BuelsingUser is Offline
river guide
river guide
Posts:241
Avatar

--
09-14-2011 01:24 PM

    Hi, I'm looking for a creative way to pass the UserID or Username of the logged in account to a DNN report. I know how to pass parameters to a report. The missing piece is how to send the UserId.

    I think DF knows the active UserID, right?  So I was thinking I could use a DF form to redirect to a URL with the report on it with the UserID parameter in the URL.

    Does this make sense? Ideally, I'd like the redirection to happen on page open, without human intervention. Maybe like this:

    User clicks on item in the menu --> That briefly opens a page with a DF form on it which immediatly redirects to the ---> report page and sending the UserID parameter in the URL.


    Am I dreaming? or can something like this work? My sub questions are

    1. Can the DF automatically run a completion event when the form opens?

    2.  Can this be done with a HTTP Post? I know nothing about those yet.

    3.  If there is another way to send the UserID to a DNN report, I'd like to hear about that too, please.

    Thank you for your suggestions!
    Don GeeUser is Offline
    river guide
    river guide
    Posts:273
    Avatar

    --
    09-15-2011 05:34 AM
    Hi Whetstone,
    As far as I know the completion events always run off of some kind of field condition at form submission so you can't get there with completion events with "on Load" of the form. However, something with sql data binding might work for you. Seems like with that approach you could use a stored procedure to fire and get a result back for the UserID. I can't say as that I know how to do it. You might try submitting this question in a contact us support form email to get some more eyes looking at this for more help on this. Also, I will ask someone in the office on this and perhaps come back with a better answer.

    Thanks

    Mark BuelsingUser is Offline
    river guide
    river guide
    Posts:241
    Avatar

    --
    09-15-2011 07:08 AM
    A clarification, the DF already has a code that retrieves the userid. It is $(UserID). Anytime the form is open on a page, the form knows the userid, I don't have to query for it. What I am asking is if I can have the form on a page and when the page loads - the form immediately, without a user clicking anything, runs a completion event that opens the url for the report with the parameters in the url. Thanks for your help.
    Mark BuelsingUser is Offline
    river guide
    river guide
    Posts:241
    Avatar

    --
    09-15-2011 07:36 AM
    I have already made the form and completion event that works with the UserID and the report opens great. But I have to click the "send" or "submit" link on the form. The missing piece now is to have this completion event happen without me having to click "send"
    Don GeeUser is Offline
    river guide
    river guide
    Posts:273
    Avatar

    --
    09-15-2011 08:04 AM
    Hi Whetstone,
    I just found out that under intitial javascript can fire javascript needed to run a completion event to get a completion event to fire before submitting a form but check out this link and see what it gives you:
    http://www.dotnetnuke.com/Resources...age/2.aspx

    Thanks
    Don GeeUser is Offline
    river guide
    river guide
    Posts:273
    Avatar

    --
    09-15-2011 08:06 AM
    Hi Whetstone,
    In addition to the above, DNN reports module should be able to provide you what you need according to Chad. See if the link above helps and let us know how it goes.
    Mark BuelsingUser is Offline
    river guide
    river guide
    Posts:241
    Avatar

    --
    09-15-2011 09:14 PM
    Don. Thanks for your help.

    1. What does that initial javascript entry look like that can run a completion event?

    2. I read the link you provided, it does not answer this question, but it does throw much caution into the thought of using a url querystring parameter as an input for the report module. Was that your point in providing the link? To alert me to the danger of SQL script injection? Or did I miss your point? ( I still take this point either way)

    3. It seems that Chad implies that the report module can access the UserID without me sending it in through a parameter. Is that what he implied? I researched that extensively and did not find helpful info on doing this. I would appreciate a hint of a keyword that I could use to google this thought some more. if it is true.

    Let me express that I really appreciate all this help. If you two were not helping so much, most of us out here would be reduced to simple input forms only. These special techniques allow us to move so far beyond that. Thanks!
    Mark BuelsingUser is Offline
    river guide
    river guide
    Posts:241
    Avatar

    --
    09-16-2011 05:16 AM
    The initial goal was to have a report that used the UserID in the sql as a criteria. I was going through all this with a Dynamic Form in order to throw the UserID into a url parameter to send to the report. It turns out that all this effort with a form was unnecessary in my project because, as Chad implied, the UserID could be attained in the sql statement in the report settings all by itself. The syntax is similar to:

    SELECT SomeField FROM Users WHERE UserID=@UserID

    The @UserID token will resolve into the real UserID when sent to the SQL Server. Simple.

    This issue is resolved. Thank you Don and Candace and Chad!

    Before you go though, could you comment on the question I raised yesterday:

    1. What does that initial javascript entry look like that can run a completion event?

    Thanks a bunch!
    Don GeeUser is Offline
    river guide
    river guide
    Posts:273
    Avatar

    --
    09-16-2011 07:37 AM
    Hi Whetstone,
    I am curious about how that can work as well. Perhaps Chad will shed some light on it.
    Don
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    09-20-2011 04:36 PM
    Hi... To answer your question...

    "1. What does that initial javascript entry look like that can run a completion event? "

    I believe this could be handled if you viewed the source code of the form for the "Save Form" JavaScript button. Then, copy and paste that JavaScript into your initial JavaScript.

    You could also possibly just use a question event set to always fire and make the question event setup to fire form submission which is one of the question event options.

    Thanks!


    -Chad
    You are not authorized to post a reply.

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
     
     

    Join our mailing list...

    Get current news and events the easy way
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi