index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Default index for report criteria drop down :: (12)Post a New Message | Post a Reply
Jul 19 2005, 8:42 AM
 Default index for report criteria drop downPost a Reply
 MindTelligent

View this author's profile Send this author a private message Visit author's homepage

since: May 10, 2005
from: El Dorado Hills, CA

The Search Condition Dropdown Works great. Is is possible to set the default index to the dropdown "Labels". I have about 6 columns in the drop down. I want to set the default value to index 3 every time the report is used, so that the user does not have to select the "column". Please help

Jul 19 2005, 1:15 PM
 Re: Default index for report criteria drop downPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

Will make sure DefaultFilterFieldIndex property is added by the next release. e.g.

objWiz.DefaultFilterFieldIndex = 3


-------------------------
Ghost
Jul 20 2005, 9:07 AM
 Re: Default index for report criteria drop downPost a Reply
 MindTelligent

View this author's profile Send this author a private message Visit author's homepage

since: May 10, 2005
from: El Dorado Hills, CA

Thanks for the prompt response. This is a great product!!


Jul 22 2005, 9:19 AM
 Re: Default index for report criteria drop downPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

The following properties DefaultFilterConditionIndex and  DefaultFilterFieldIndex are available as of version 2.5.65


-------------------------
Ghost
Jul 26 2005, 8:14 AM
 Re: Default index for report criteria drop downPost a Reply
 MindTelligent

View this author's profile Send this author a private message Visit author's homepage

since: May 10, 2005
from: El Dorado Hills, CA

I downloaded the latest version yesterday. Added the floowing lines

objWiz.DefaultFilterConditionIndex=1
objWiz.DefaultFilterFieldIndex=3


When I ran the report, It DID NOTdefault to the filter indexi

Please help

Jul 26 2005, 10:15 AM
 Re: Default index for report criteria drop downPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

This bug has been fixed and will be available in the next minor release.
(Apparently some other initialization was reseting the index to -1)


-------------------------
Ghost
Jul 27 2005, 6:06 PM
 Re: Default index for report criteria drop downPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

These properties are now working as of the current version v2.5.66


-------------------------
Ghost
Jul 29 2005, 8:03 AM
 Re: Default index for report criteria drop downPost a Reply
 MindTelligent

View this author's profile Send this author a private message Visit author's homepage

since: May 10, 2005
from: El Dorado Hills, CA

I tried it with the latest download, it does not seem to work.

Best Regards

Jul 29 2005, 8:15 AM
 Re: Default index for report criteria drop downPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

Can I see your source code!
P/S: Also make sure you are running v2.5.66 (build 2.0.566) or greater as follows:
Response.Write(objWiz.Version)




-------------------------
Ghost
Jul 29 2005, 8:43 AM
 Re: Default index for report criteria drop downPost a Reply
 MindTelligent

View this author's profile Send this author a private message Visit author's homepage

since: May 10, 2005
from: El Dorado Hills, CA

I verified the version, it it 2.0.566  Please see the code below for default.asp

<%

Dim objWiz
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")
Response.write("Report Version" & objWiz.Version)
  
'Make sure you initialize before adding any HTML text
'TODO: Change this to your actual connection tring
objWiz.Init("provider=sqloledb; data source = appsrv; uid=sa; pwd=123; DATABASE=STOCKTON_SCHEDULER")
  
'put this where you want your reports
objWiz.OverridePageSize=50
objWiz.CanDelete=False

objWiz.DisplayReports
objWiz.DefaultFilterFieldIndex =   3
objWiz.DefaultFilterConditionIndex=3
Response.write(objWiz.Version)
  
Set objWiz = Nothing




%>


Jul 29 2005, 9:28 AM
 Re: Default index for report criteria drop downPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

Remember to always set all your properties before calling any methods.

Init and DisplayReports must come after all your properties have been set. The Filters get created before the report so if you create the report (DisplayReports) before setting your properties, the properties will have no effect because the filters have already been created.

<%

Dim objWiz
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")

objWiz.OverridePageSize = 50
objWiz.CanDelete = False  'User cannot delete anything

objWiz.DefaultFilterFieldIndex =   3
objWiz.DefaultFilterConditionIndex = 3

'Make sure you initialize before adding any HTML text
'TODO: Change this to your actual connection tring
objWiz.Init("provider=sqloledb; data source = appsrv; uid=sa; pwd=123; DATABASE=STOCKTON_SCHEDULER")
  

Response.write("Report Version " & objWiz.Version)

'put this where you want your reports
objWiz.DisplayReports
  
Set objWiz = Nothing

%>


-------------------------
Ghost
Jul 29 2005, 10:00 AM
 Re: Default index for report criteria drop downPost a Reply
 MindTelligent

View this author's profile Send this author a private message Visit author's homepage

since: May 10, 2005
from: El Dorado Hills, CA

Thanks, it works great!!!

Pages: (1)   [1]

search this forum: