pulpfiction

This adding parameter I can use in the report but cannot use it in SP parameter.Say if the query is like this. SELECT fldname FROM tlb WHERE id=@param.how can I give the value for @param

almost correct spelling.... Its "Adieu". also I think it means "goodbye".

Problem is after I select the SP....... i select the SP in the "database expert" [ole db (ado)] when I select the SP in the expert window is gets added but there are no fields in it. Are you telling about the "add command" under OLE DB. but the query I use requires parameters, how can I do that? Thanks.

No AFAIK, the reports must be designed manually and there's no other way to do that....

Its the same procedure in CR 9, but temp tables are messing it up. guess there's no other option other than to rewrite the SP. its gonna get really complex.

Tried to trace where the div open and close. seems like the container div "content_wrap" is closed after the "left_col" and the "welcome_join" and other divs are outside the container div. so they are moved to the bottom <div id="content_wrap"> <div id="left_col"> <div id="nav"> <ul class="nav"> <li class="item1"><a class="first" href= "index.php?src=gendocs&ref=AboutSampleCity&category=Main&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">About Sample City</a></li> <li class="item2"><a href="index.php?src=gendocs&ref=AbouttheChamber&category=Main&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">About the Chamber</a></li> <li class="item3"><a href="index.php?src=events&category=Events&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Programs & Events</a></li> <li class="item4"><a href="index.php?src=news&persist_cat=1&srctype=lister&newssearch=yes&kw=&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Press Room</a></li> <li class="item5"><a href="index.php?src=gendocs&ref=GovernmentAffairs&category=Main&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Government Affairs</a></li> <li class="item6"><a href="index.php?src=dining&persist_cat=1&srctype=lister&newssearch=yes&kw=&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Dining Guide</a></li> <li class="item7"><a href="index.php?src=nightlife&persist_cat=1&srctype=lister&newssearch=yes&kw=&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Nightlife Guide</a></li> <li class="item8"><a href="index.php?src=directory&view=businesses&view=businesses_lister&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Business Search</a></li> <li class="item9"><a href="index.php?src=products&persist_cat=1&srctype=lister&newssearch=yes&kw=&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Marketplace</a></li> <li class="item10"><a href="index.php?src=forum&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Members Forum</a></li> <li class="item11"><a href="index.php?src=faq&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">FAQ</a></li> <li class="item12"><a href="index.php?src=blog&view=blog&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Chamber Blog</a></li> <li class="item13"><a href="index.php?src=gendocs&ref=AdvertisingInformation&category=Main&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Advertising Information</a></li> <li class="item14"><a class="last" href="index.php?src=forms&ref=Contact Us&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Contact</a></li> </ul> </div> <!-- END OF NAV --> <div id="poll"> <form action="index.php" method="post" style="margin-bottom:3;"><input type="hidden" name="PHPSESSID" value="3c0eea866da0ca0b84527386ee8eaa17" /> <div class="pollHomeQuestion">What is your favorite thing about Sample City?</div> <div class="pollHomeChoices"><input type="radio" name="myvote" value="1">The People</div> <div class="pollHomeChoices"><input type="radio" name="myvote" value="2">The Nightlife</div> <div class="pollHomeChoices"><input type="radio" name="myvote" value="3">The Events</div> <input type="hidden" name="id" value="1" /> <input type="hidden" name="src" value="poll" /> <input type="hidden" name="srctype" value="process" /> <input type="hidden" name="category" value="Polls" /> <div class="pollHomeVote"> <input type="image" src="http://www.samplechamber.com/graphics/vote.gif" border="0" name="vote" value="Vote" /> </div> </form> </div> <!-- END OF POLL --> <div id="banner"><p align="center"><a class="fba_links" href="index.php?src=fba&srctype=click&id=1&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17" onclick="window.open(this.href); return false;"><img src="cache/sql/fba/fs_1.jpg" style="border:0px;width:120px;height:90px" alt="Indy Star" /></a></p></div> </div> <!-- END OF LEFT_COL --></div> <!-- END OF CONTENT_WRAP --><!-- THIS DIV ABOVE MUST COME AFTER AT THE BOTTOM, JUST BEFORE THE FOOTER DIV --><!-- ======== Header Page Layout Ends ========= --><div id="welcomejoin">

I use VS 2003 and CR bundled with it. When I add a SP, it appears under "database fields" this SP must be expandable and must show the fields to drag into the report. but its not expandable at all. no [+] appears when SP is added. Also SP ends like SELECT fldname from #temp. Data from different tables are collected in a temp table.

After 2 weeks of struggling with CR finally found the work around. its to totally avoid dataset. you need to directly connect with the database [OLE DB]and pull the stored procedure. and add some CR connection info code. Next problem is, one of the stored procedures has temporary table and final data comes from a temp data. CR cannot use that SP. any suggestions? thanks.

The left div which contains the menu has a width:900px [covers the whole mid section]. reduce that width and float it to left. #content_wrap { width:200px; margin: 0 auto; text-align:left; float:left; border:1px solid #fff; }

I just tried to install Internet Explorer Developer Toolbar Beta 3. is this the latest version? its pretty much like FF's tool but graphically poor....http://www.microsoft.com/downloads/details...;displaylang=en

I like all the designs there except for "Retro Theater by Eric Roge"http://www.csszengarden.com/?cssfile=/202/202.css&page=0

FF Web Developer tool is awesome, "validate local CSS" and "validate local HTML" options are really helpful..... Never used it much, guess it should be nice.http://dev.opera.com/tools/

small change.... add "mailto:" to the radio button value.....<form id="theForm" action="mailto:person1@domain.com" method="post"><input type="radio" name="email" value="mailto:person1@domain.com" selected="selected" onclick="changeEmail(this)"/> person1<br/><input type="radio" name="email" value="mailto:person2@domain.com" onclick="changeEmail(this)"/> person2</form>

Not sure if you can do that in SQL. You must do that restriction with application...

MySql or SQLServer is better than MS Access.... http://64.233.167.104/search?q=cache:_6B8v...;cd=1&gl=usMySql and ASP connection..http://www.aspdev.org/articles/asp-mysql-connect/