Monday, March 19, 2012
How to use Parameters without letting it to Prompt to enter
We are using 10 parameters in SRS report. When the report is
executing, it prompts us to enter all 10 parameters.
But we don't want to enter all parameters, we should be able to enter
blank parameters without mandatory parameters.
SRS prompts to enter all parameters.
Kindly help.
Regards,
Manoj
Mobile: +91-9989010205Allow blank option should be enabled. Still it will wait for the input for
any other field you wanted to enter and have to press "View Reports"
Amarnath
"plmanoj@.gmail.com" wrote:
> Hi All,
> We are using 10 parameters in SRS report. When the report is
> executing, it prompts us to enter all 10 parameters.
> But we don't want to enter all parameters, we should be able to enter
> blank parameters without mandatory parameters.
> SRS prompts to enter all parameters.
> Kindly help.
> Regards,
> Manoj
> Mobile: +91-9989010205
>|||Hi Amar,
Thanks for your reply!
Even blank option does not solve the purpose. It still pops the message saying
"Please enter a value for the parameter. The parameter cannot be blank".
Our objective is, It should not be mandatory to specify the parameter value.
Please let us know if you have any solution.
Regards,
Manoj
"Amarnath" wrote:
> Allow blank option should be enabled. Still it will wait for the input for
> any other field you wanted to enter and have to press "View Reports"
> Amarnath
> "plmanoj@.gmail.com" wrote:
> > Hi All,
> >
> > We are using 10 parameters in SRS report. When the report is
> > executing, it prompts us to enter all 10 parameters.
> >
> > But we don't want to enter all parameters, we should be able to enter
> > blank parameters without mandatory parameters.
> >
> > SRS prompts to enter all parameters.
> >
> > Kindly help.
> >
> > Regards,
> > Manoj
> > Mobile: +91-9989010205
> >
> >|||Hope you have checked for Null as well, so if both are checked then it goes
through. Just check each parameter, to see any where you had not checked and
more over there is an option called default, where you can specify so that it
goes through
Amarnath
"AxMan" wrote:
> Hi Amar,
> Thanks for your reply!
> Even blank option does not solve the purpose. It still pops the message saying
> "Please enter a value for the parameter. The parameter cannot be blank".
> Our objective is, It should not be mandatory to specify the parameter value.
> Please let us know if you have any solution.
> Regards,
> Manoj
> "Amarnath" wrote:
> > Allow blank option should be enabled. Still it will wait for the input for
> > any other field you wanted to enter and have to press "View Reports"
> >
> > Amarnath
> >
> > "plmanoj@.gmail.com" wrote:
> >
> > > Hi All,
> > >
> > > We are using 10 parameters in SRS report. When the report is
> > > executing, it prompts us to enter all 10 parameters.
> > >
> > > But we don't want to enter all parameters, we should be able to enter
> > > blank parameters without mandatory parameters.
> > >
> > > SRS prompts to enter all parameters.
> > >
> > > Kindly help.
> > >
> > > Regards,
> > > Manoj
> > > Mobile: +91-9989010205
> > >
> > >|||Forgot to mention, the other option is "default value", if you give the
default value then it goes through directly, without popping a msg.
Amarnath
"AxMan" wrote:
> Hi Amar,
> Thanks for your reply!
> Even blank option does not solve the purpose. It still pops the message saying
> "Please enter a value for the parameter. The parameter cannot be blank".
> Our objective is, It should not be mandatory to specify the parameter value.
> Please let us know if you have any solution.
> Regards,
> Manoj
> "Amarnath" wrote:
> > Allow blank option should be enabled. Still it will wait for the input for
> > any other field you wanted to enter and have to press "View Reports"
> >
> > Amarnath
> >
> > "plmanoj@.gmail.com" wrote:
> >
> > > Hi All,
> > >
> > > We are using 10 parameters in SRS report. When the report is
> > > executing, it prompts us to enter all 10 parameters.
> > >
> > > But we don't want to enter all parameters, we should be able to enter
> > > blank parameters without mandatory parameters.
> > >
> > > SRS prompts to enter all parameters.
> > >
> > > Kindly help.
> > >
> > > Regards,
> > > Manoj
> > > Mobile: +91-9989010205
> > >
> > >
Wednesday, March 7, 2012
How to use cp855 endoded text in a database?
I'm trying to enter a text encoded in cp855 in a table field which must
be defined as char. The cp855 encoding is 8-bit encoded text. This
text, will then be transfered into a POS terminal and display localized
text. I'm having problems settings up the correct collation and the
method for entering the text in a char field.
Can anyone help me please?
Thank you,
TomislavIf you are having trouble specifying the collation for the particular field
or using the 8-bit encoding, you might have to convert to the IMAGE data
type, which excepts binary data. You would then need to pass and retreive
the information as a bit stream, like using the ADO Stream object.
Hope this helps.
Sincerely,
Anthony Thomas
<tomislav.markovski@.gmail.com> wrote in message
news:1103903500.132330.54060@.z14g2000cwz.googlegroups.com...
Hello,
I'm trying to enter a text encoded in cp855 in a table field which must
be defined as char. The cp855 encoding is 8-bit encoded text. This
text, will then be transfered into a POS terminal and display localized
text. I'm having problems settings up the correct collation and the
method for entering the text in a char field.
Can anyone help me please?
Thank you,
Tomislav|||(tomislav.markovski@.gmail.com) writes:
> I'm trying to enter a text encoded in cp855 in a table field which must
> be defined as char. The cp855 encoding is 8-bit encoded text. This
> text, will then be transfered into a POS terminal and display localized
> text. I'm having problems settings up the correct collation and the
> method for entering the text in a char field.
> Can anyone help me please?
This looks difficult. There does not seem to be any collation based on
CP855. It is possible that a Cyrillic collation would them, and you would
then have to place your bets on ANSI/OEM conversion when outputting the
data. If your input is in CP855 as well, then the ANSI/OEM conversion
mus work in both direction, and be round-trip. Unfortunately, this is
not always the case with ANSI/OEM conversions.
Anothy Thomas's idea of using binary somewhere on the way, may be worth
pursuing.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
How to use cp855 endoded text in a database?
I'm trying to enter a text encoded in cp855 in a table field which must
be defined as char. The cp855 encoding is 8-bit encoded text. This
text, will then be transfered into a POS terminal and display localized
text. I'm having problems settings up the correct collation and the
method for entering the text in a char field.
Can anyone help me please?
Thank you,
Tomislav
If you are having trouble specifying the collation for the particular field
or using the 8-bit encoding, you might have to convert to the IMAGE data
type, which excepts binary data. You would then need to pass and retreive
the information as a bit stream, like using the ADO Stream object.
Hope this helps.
Sincerely,
Anthony Thomas
<tomislav.markovski@.gmail.com> wrote in message
news:1103903500.132330.54060@.z14g2000cwz.googlegro ups.com...
Hello,
I'm trying to enter a text encoded in cp855 in a table field which must
be defined as char. The cp855 encoding is 8-bit encoded text. This
text, will then be transfered into a POS terminal and display localized
text. I'm having problems settings up the correct collation and the
method for entering the text in a char field.
Can anyone help me please?
Thank you,
Tomislav
|||(tomislav.markovski@.gmail.com) writes:
> I'm trying to enter a text encoded in cp855 in a table field which must
> be defined as char. The cp855 encoding is 8-bit encoded text. This
> text, will then be transfered into a POS terminal and display localized
> text. I'm having problems settings up the correct collation and the
> method for entering the text in a char field.
> Can anyone help me please?
This looks difficult. There does not seem to be any collation based on
CP855. It is possible that a Cyrillic collation would them, and you would
then have to place your bets on ANSI/OEM conversion when outputting the
data. If your input is in CP855 as well, then the ANSI/OEM conversion
mus work in both direction, and be round-trip. Unfortunately, this is
not always the case with ANSI/OEM conversions.
Anothy Thomas's idea of using binary somewhere on the way, may be worth
pursuing.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
How to use cp855 endoded text in a database?
I'm trying to enter a text encoded in cp855 in a table field which must
be defined as char. The cp855 encoding is 8-bit encoded text. This
text, will then be transfered into a POS terminal and display localized
text. I'm having problems settings up the correct collation and the
method for entering the text in a char field.
Can anyone help me please?
Thank you,
TomislavIf you are having trouble specifying the collation for the particular field
or using the 8-bit encoding, you might have to convert to the IMAGE data
type, which excepts binary data. You would then need to pass and retreive
the information as a bit stream, like using the ADO Stream object.
Hope this helps.
Sincerely,
Anthony Thomas
<tomislav.markovski@.gmail.com> wrote in message
news:1103903500.132330.54060@.z14g2000cwz.googlegroups.com...
Hello,
I'm trying to enter a text encoded in cp855 in a table field which must
be defined as char. The cp855 encoding is 8-bit encoded text. This
text, will then be transfered into a POS terminal and display localized
text. I'm having problems settings up the correct collation and the
method for entering the text in a char field.
Can anyone help me please?
Thank you,
Tomislav|||(tomislav.markovski@.gmail.com) writes:
> I'm trying to enter a text encoded in cp855 in a table field which must
> be defined as char. The cp855 encoding is 8-bit encoded text. This
> text, will then be transfered into a POS terminal and display localized
> text. I'm having problems settings up the correct collation and the
> method for entering the text in a char field.
> Can anyone help me please?
This looks difficult. There does not seem to be any collation based on
CP855. It is possible that a Cyrillic collation would them, and you would
then have to place your bets on ANSI/OEM conversion when outputting the
data. If your input is in CP855 as well, then the ANSI/OEM conversion
mus work in both direction, and be round-trip. Unfortunately, this is
not always the case with ANSI/OEM conversions.
Anothy Thomas's idea of using binary somewhere on the way, may be worth
pursuing.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Friday, February 24, 2012
How to use a Wildcard with the value for the parameter?
I have a report that selects certain records based on what the user enters for the parameter but I'm trying to allow the user to enter a wildcard and show the relevant records. I used like and had the user add an * or even a % but it still returns nothing. Records are returned only when the user enters the full value with no wildcards. Help.
SELECT DISTINCT
PDFBM.ASSEMBLY_ID, PDFBM.COMPONENT_ID, PDFBM.REQUIRED_QTY, ICFPM.PART_DESC, ICFPM.DWG_REV, ICFPM.PENDING_ECN,
dbo.ICFSS.STORES_CODE, dbo.ICFSS.STOCK_LOCATION
FROM dbo.ICFPM ICFPM INNER JOIN
dbo.PDFBM PDFBM ON ICFPM.PART_ID = PDFBM.ASSEMBLY_ID INNER JOIN
dbo.ICFSS ON ICFPM.PART_ID = dbo.ICFSS.PART_ID
WHERE (PDFBM.COMPONENT_ID LIKE @.componentid) AND (PDFBM.ASSEMBLY_ID LIKE '350%')
ORDER BY PDFBM.ASSEMBLY_ID, PDFBM.COMPONENT_ID
A
I'm not sure but try converting the query to a dynamic query:
="SELECT DISTINCT
PDFBM.ASSEMBLY_ID, PDFBM.COMPONENT_ID, PDFBM.REQUIRED_QTY, ICFPM.PART_DESC, ICFPM.DWG_REV, ICFPM.PENDING_ECN,
dbo.ICFSS.STORES_CODE, dbo.ICFSS.STOCK_LOCATION
FROM dbo.ICFPM ICFPM INNER JOIN
dbo.PDFBM PDFBM ON ICFPM.PART_ID = PDFBM.ASSEMBLY_ID INNER JOIN
dbo.ICFSS ON ICFPM.PART_ID = dbo.ICFSS.PART_ID
WHERE (PDFBM.COMPONENT_ID LIKE '" + Parameters!componentid.Value + "') AND (PDFBM.ASSEMBLY_ID LIKE '350%')
ORDER BY PDFBM.ASSEMBLY_ID, PDFBM.COMPONENT_ID"
Regards,
Telmo Moreira
|||try:
LIKE @.parameter + '%')
drop the user adding the wildcard char