CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 CCGetQueryString

Print topic Send  topic

Author Message
ddmcse

Posts: 24
Posted: 02/14/2008, 1:31 PM

I have a report generated using report builder
at the top of the report i want to add the criteria select by the user on the previous search page

i added a report label to the report and added custom code to the before show event of the label

  
$ result = CCGetQueryString("QueryString","");  
$Formname->ReportLabel1->SetValue($result);  

apparently it's doing exactly as i said
i put in some canned text above my ReportLabel1
"this report is generated based on the following criteria"
s_Vendor_Proof_Number=0987645&s_Product_Size=12+oz&s_Category=&s_Type=&s_Fragrance_Name=Lavender&TextBox1=

on and on , so this isn't what i was hoping for .
is there some way to take this and put into human usable type stuff ?

i.e.
"this report is generated based on the following criteria"
Vendor Proof Number 0987645
Product Size 12 ozs
Fragrance Name Lavender
_________________
http://www.buyrfidlabels.com
View profile  Send private message
datadoit
Posted: 02/14/2008, 7:07 PM

$result = "this report is generated based on the following criteria";
$result .= "\n";
$result .= "Vendor Proof Number " . CCGetParam("s_Vendor_Proof_Number","");
$result .= "\n";
$result .= "Product Size " . CCGetParam("s_Product_Size","");
$result .= "\n";
$result .= "Fragrance Hame " . CCGetParam("s_Frangrance_Name","");

$Component->SetValue($result);
ddmcse

Posts: 24
Posted: 02/14/2008, 11:38 PM

looks like something i can work with . thanks alot data
what does the "\n" do ?
_________________
http://www.buyrfidlabels.com
View profile  Send private message
wkempees
Posted: 02/15/2008, 3:55 AM

\n ewline

"ddmcse" <ddmcse@forum.codecharge> schreef in bericht
news:547b5416617e35@news.codecharge.com...
> looks like something i can work with . thanks alot data
> what does the "\n" do ?
> _________________
> http://www.buyrfidlabels.com
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

datadoit
Posted: 02/15/2008, 5:55 AM

Make your control HTML and that'll allow you to make your display 'pretty':

$result = "<font color=BLUE><strong>this report is generated based on
the following criteria</strong></font>";
$result .= "<br>";
$result .= "<strong>Vendor Proof Number </strong>" .
CCGetParam("s_Vendor_Proof_Number","");
$result .= "<br>";
$result .= "<strong>Product Size </strong>" .
CCGetParam("s_Product_Size","");
$result .= "<br>";
$result .= "<strong>Fragrance Hame </strong>" .
CCGetParam("s_Frangrance_Name","");

$Component->SetValue($result);
ddmcse

Posts: 24
Posted: 02/20/2008, 11:41 AM

I am just about to get to "pretty"
which leads me to my next question and that is:

How to deal with IE 6 printing with the right hand side cut off ?

IE 7 does fine and so does firefox


i see a bunch of stuff on google about IE6 and this issue but it's
mostly end users

i submitted a support issue but they haven't come up with anything

i ended up doing something like this so far

  
$result = "This report is generated based on the following criteria:";  
  
$result .= "\n";  
  
  
  
$ans = CCGetParam("s_Vendor_Proof_Number","");  
  
if ($ans !=null) {  
  
	$result .= "Vendor Proof Number = " . $ans;  
  
	$result .= "\n";  
  
}  
  
  
  
$ans = CCGetParam("s_Product_Size","");  
  
if ($ans !=null) {  
  
	$result .= "Product Size = " . $ans;  
  
	$result .= "\n";  
  
}  
  
  
  
$ans = CCGetParam("s_Fragrance_Name = ","");  
  
if ($ans !=null) {  
  
	$result .= "Fragrance Name = " . $ans;  
  
	$result .= "\n";  
  
}  
  
  
  
$ans = CCGetParam("s_Publish_Start_Date = ","");  
  
$ans2 = CCGetParam("s_Publish_End_Date = ","");  
  
if ($ans !=null or $ans2 !=null) {  
  
	$result .= "Publish Date ";  
  
	if ($ans !=null) {  
  
		$result .= "From  " . $ans . "  ";  
  
	}  
  
	  
  
	if ($ans2 !=null) {  
  
		$result .= "Thru  " . $ans2;  
  
	}	  
  
	  
  
	$result .= "\n";  
  
}		  
  
	  
  
$Component->SetValue($result);  
  

thanks again
DD


_________________
http://www.buyrfidlabels.com
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.