I have a Parameter with 2 non-queried choices, Yes and No. I set the default
to No. When the report displays, instead of the default value displaying in
the dropdown, the users are being forced to choose. any ideas what would
cause this or how to fix?
TIA
deanI have a yes and no parameter. The labels say Yes and No and the values are
Y and N. You can either put in Y or ="Y" (either syntax works).
Also, it is case sensitive. So be sure the default you put in matches the
value not the label AND you are matching the case.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dean" <deanl144@.hotmail.com.nospam> wrote in message
news:Os5F3I6$HHA.4200@.TK2MSFTNGP04.phx.gbl...
>I have a Parameter with 2 non-queried choices, Yes and No. I set the
>default to No. When the report displays, instead of the default value
>displaying in the dropdown, the users are being forced to choose. any ideas
>what would cause this or how to fix?
> TIA
> dean
>|||I fixed this myself by deleting my deployed report and redeploying.
"Dean" <deanl144@.hotmail.com.nospam> wrote in message
news:Os5F3I6$HHA.4200@.TK2MSFTNGP04.phx.gbl...
>I have a Parameter with 2 non-queried choices, Yes and No. I set the
>default to No. When the report displays, instead of the default value
>displaying in the dropdown, the users are being forced to choose. any ideas
>what would cause this or how to fix?
> TIA
> dean
>sql
Showing posts with label displaying. Show all posts
Showing posts with label displaying. Show all posts
Wednesday, March 28, 2012
Wednesday, March 7, 2012
Programmatically Adding ADO.NET Connections
I can't find any documentation on the connection string for creating ADO.NET connections.
I am displaying a report in a viewer. It is connected to a wrapper DLL through an ADO.NET connection using the properties:
File Path
Class Name
Dataset Names
I'm having trouble accessing these to change them at runtime.
I've tried something like:
rpt.database:Tables(1):ConnectionProperties("File Path") = "c:\..."
No luck. Crystal doesn't have much documentation on this method. Any takers?Nevermind. Got it.
I was able to override the path of my DLL at runtime using the syntax:
report.database.tables(1).ConnectionProperties("File Path").Value = "c:\blah"
seems to be working.
I am displaying a report in a viewer. It is connected to a wrapper DLL through an ADO.NET connection using the properties:
File Path
Class Name
Dataset Names
I'm having trouble accessing these to change them at runtime.
I've tried something like:
rpt.database:Tables(1):ConnectionProperties("File Path") = "c:\..."
No luck. Crystal doesn't have much documentation on this method. Any takers?Nevermind. Got it.
I was able to override the path of my DLL at runtime using the syntax:
report.database.tables(1).ConnectionProperties("File Path").Value = "c:\blah"
seems to be working.
Labels:
adding,
ado,
adonet,
connected,
connection,
connections,
creating,
database,
displaying,
documentation,
microsoft,
mysql,
net,
oracle,
programmatically,
report,
server,
sql,
string,
viewer
Subscribe to:
Posts (Atom)