Report parameter dropdown

I bound a report parameter to a combobox. I tried to configure default
parameter as null several ways
in report parameters properties dialog but could not.
How can i specify default value of null for a combobox parameter? thxOn Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
> I bound a report parameter to a combobox. I tried to configure default
> parameter as null several ways
> in report parameters properties dialog but could not.
> How can i specify default value of null for a combobox parameter? thx
If the default value of null does not work in the Report Parameters
dialog, I would suggest unioning your dataset against an empty/null
record and then use a default of the dataset and make sure that the
empty/null value is listed first. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||thx!
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176856481.241478.187380@.b58g2000hsg.googlegroups.com...
> On Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
>> I bound a report parameter to a combobox. I tried to configure default
>> parameter as null several ways
>> in report parameters properties dialog but could not.
>> How can i specify default value of null for a combobox parameter? thx
>
> If the default value of null does not work in the Report Parameters
> dialog, I would suggest unioning your dataset against an empty/null
> record and then use a default of the dataset and make sure that the
> empty/null value is listed first. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Apr 18, 1:51 pm, "nkg" <x...@.yahoo.com> wrote:
> thx!"EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1176856481.241478.187380@.b58g2000hsg.googlegroups.com...
> > On Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
> >> I bound a report parameter to a combobox. I tried to configure default
> >> parameter as null several ways
> >> in report parameters properties dialog but could not.
> >> How can i specify default value of null for a combobox parameter? thx
> > If the default value of null does not work in the Report Parameters
> > dialog, I would suggest unioning your dataset against an empty/null
> > record and then use a default of the dataset and make sure that the
> > empty/null value is listed first. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" wrote:
> On Apr 18, 1:51 pm, "nkg" <x...@.yahoo.com> wrote:
> > thx!"EMartinez" <emartinez...@.gmail.com> wrote in message
> >
> > news:1176856481.241478.187380@.b58g2000hsg.googlegroups.com...
> >
> > > On Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
> > >> I bound a report parameter to a combobox. I tried to configure default
> > >> parameter as null several ways
> > >> in report parameters properties dialog but could not.
> >
> > >> How can i specify default value of null for a combobox parameter? thx
> >
> > > If the default value of null does not work in the Report Parameters
> > > dialog, I would suggest unioning your dataset against an empty/null
> > > record and then use a default of the dataset and make sure that the
> > > empty/null value is listed first. Hope this helps.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. Software Consultant
>
> You're welcome. Let me know if I can be of further assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Instead of modifying my datasource, I chose to change the parameter. A small
function injects the null value into the selected list before filtering my
data.
here's how :
http://pderop.blogspot.com/2007/05/ssrs-multivalue-and-nulls.html
cheers

Report Parameter Default Value from Column

DataSet2:
select MyCol1 from MySecondTable
In the Report Parameters dialog box, I add MyCol1 as a multi-value
parameter. When I run the report, I can select one or more values from the
MyCol1 drop-down. This works great.
The problem is I want the first value in MyCol1 to be the default value in
the drop-down. In the Default Values box, I select Non-queried, and use the
expression =Parameters!MyCol1.Value(0) This seems exactly right to me.
With the default value set as above, the report fails to run with the
following error: Error during processing of 'MyCol1' report parameter.
Any suggestions on how to fix this?
Thanks,
--
RandyYou can create a hidden parameter but not multi-valued. Set its default
value as coming from a query and select MyCol1 in DataSet2, it should pull
the first value from the dataset. Then you can set the default value of the
multi-valued parameter to the value of the hidden parameter.
"randy1200" wrote:
> DataSet2:
> select MyCol1 from MySecondTable
> In the Report Parameters dialog box, I add MyCol1 as a multi-value
> parameter. When I run the report, I can select one or more values from the
> MyCol1 drop-down. This works great.
> The problem is I want the first value in MyCol1 to be the default value in
> the drop-down. In the Default Values box, I select Non-queried, and use the
> expression =Parameters!MyCol1.Value(0) This seems exactly right to me.
> With the default value set as above, the report fails to run with the
> following error: Error during processing of 'MyCol1' report parameter.
> Any suggestions on how to fix this?
> Thanks,
> --
> Randy|||I have done this by creating another dataset called someting like
MyCol1Default defined as:
SELECT TOP1 MyCol1 FROM MySecondTable
or
SELECT MIN(MyCol1) FROM MySecondTable
Then in the report parameter definition specify that the default comes from
dataset MyCol1Default and that the value is MyCol1.
HTH,
Magendo_man
"randy1200" wrote:
> DataSet2:
> select MyCol1 from MySecondTable
> In the Report Parameters dialog box, I add MyCol1 as a multi-value
> parameter. When I run the report, I can select one or more values from the
> MyCol1 drop-down. This works great.
> The problem is I want the first value in MyCol1 to be the default value in
> the drop-down. In the Default Values box, I select Non-queried, and use the
> expression =Parameters!MyCol1.Value(0) This seems exactly right to me.
> With the default value set as above, the report fails to run with the
> following error: Error during processing of 'MyCol1' report parameter.
> Any suggestions on how to fix this?
> Thanks,
> --
> Randy

Report Parameter Date AND Time

SSRS2005.
In the Report Parameters dialog, I click Non-queried in the Default values
section, and use =Today(). I get today's date, which is exactly what I want.
But now I need to apply some formating, which generates an error:
=Format(Today(), "dd MMM yy hh:mm:ss")
How do I apply dd MMM yy hh:mm:ss formating to my Report Parameter without
any errors?
Thanks,
--
RandyTry going to properties of the text box and Format tab just give
dd-mm-yyyy-hh:mm:ss in the custom.
Amarnath
"randy1200" wrote:
> SSRS2005.
> In the Report Parameters dialog, I click Non-queried in the Default values
> section, and use =Today(). I get today's date, which is exactly what I want.
> But now I need to apply some formating, which generates an error:
> =Format(Today(), "dd MMM yy hh:mm:ss")
> How do I apply dd MMM yy hh:mm:ss formating to my Report Parameter without
> any errors?
> Thanks,
> --
> Randy|||The Today() property only gives you the date with time set to 00:00:00. You
should use the Now() property if you want time as well as date.
HTH,
Magendo_man
"randy1200" wrote:
> SSRS2005.
> In the Report Parameters dialog, I click Non-queried in the Default values
> section, and use =Today(). I get today's date, which is exactly what I want.
> But now I need to apply some formating, which generates an error:
> =Format(Today(), "dd MMM yy hh:mm:ss")
> How do I apply dd MMM yy hh:mm:ss formating to my Report Parameter without
> any errors?
> Thanks,
> --
> Randy|||Hello Randy,
Have you tried Amarnath's suggestion on use the "dd-MMM-yy hh:mm:ss" format
string instead to see whether it works. Based on my test, both the
followign formatting code work correctly:
=Format(Today(), "dd MMM yy hh:mm:ss")
=Format(Today(), "dd-MMM-yy hh:mm:ss")
Also, I suggest you consider the following options:
Currently you directly use the following expression for your report
parameter:
=Format(Today(), "dd MMM yy hh:mm:ss")
Then the paramter's type must be "string" , correct? Instead of directly
add the formatting operation in the parameter expression(and define the
parameter as string), you can define the report parameter as Datetime type
and use the following expression:
=Today()
this will return the DateTime object of today. And when you want to
display a formatted datetime string upon this paramter, you can use the
format function in the certain ReportItem's expression, e.g
=Parameters!Today_Param.Value
You can try this to see whethe it also works.
Hope this helps.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

Report not printing

I'm having a problem with one machine especifically. On my machine if I hit
the print buttom on Report Manager, I get a printing dialog box for a long
time but nothing is printed (no error message neither). If I try the same
thing in another machine, it prints fine. I though about uninstalling and
reinstalling the client ActiveX, but don't know how to do it. Any suggestions,
Thanks,
Carmen.To uninstall the activex control, go to the tools menu in IE. Then go to
Internet Options->Settings->View Objects. Then delete the RSClientPrint
control.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carmen" <Carmen@.discussions.microsoft.com> wrote in message
news:210BFC5F-91E8-4AE4-BBBD-AC1F7817FD94@.microsoft.com...
> I'm having a problem with one machine especifically. On my machine if I
> hit
> the print buttom on Report Manager, I get a printing dialog box for a long
> time but nothing is printed (no error message neither). If I try the same
> thing in another machine, it prints fine. I though about uninstalling and
> reinstalling the client ActiveX, but don't know how to do it. Any
> suggestions,
> Thanks,
> Carmen.|||Thanks, Daniel. It worked!
Carmen
"Daniel Reib [MSFT]" wrote:
> To uninstall the activex control, go to the tools menu in IE. Then go to
> Internet Options->Settings->View Objects. Then delete the RSClientPrint
> control.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Carmen" <Carmen@.discussions.microsoft.com> wrote in message
> news:210BFC5F-91E8-4AE4-BBBD-AC1F7817FD94@.microsoft.com...
> > I'm having a problem with one machine especifically. On my machine if I
> > hit
> > the print buttom on Report Manager, I get a printing dialog box for a long
> > time but nothing is printed (no error message neither). If I try the same
> > thing in another machine, it prints fine. I though about uninstalling and
> > reinstalling the client ActiveX, but don't know how to do it. Any
> > suggestions,
> >
> > Thanks,
> >
> > Carmen.
>
>