Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DataGirl
Starting Member
2 Posts |
 Posted - 2011-04-04 : 09:25:28
|
| We have a report that currently runs in Crystal, but gathers its data from another program. The report allows for multiple selections and the parameters in the stored procedure are either DATETIME or NVARCHAR(max). I then take the NVARCHAR(max) parameters and enter them into table variables and use the table variables in the joins. Something isn't correct with that parameters. I cannot get them to be sent to the server properly. Has anyone successfully converted a Crystal Report to an SSRS? I was able to convert one, but this other one just isn't working. A friend said to use RDL, but I can't find a tutorial to get me started.Thanks in advance! |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-04-04 : 12:20:30
|
| I had read online about software to convert Crystal to SSRS, but it was expensive. I have found it was easiest to just rewrite the report in SSRS. It gave me practice.Hey, it compiles. |
 |
|
|
DataGirl
Starting Member
2 Posts |
Posted - 2011-04-05 : 10:12:41
|
| How did you send criteria to SQL when you're allowing multiple selections? Meaning, say you're looking up all my customers in three states. I've noticed that I can get the first chosen state to be returned in the results, but not the next two. How do I make that happen? |
|
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-04-05 : 10:49:13
|
| The report file will allow you to select an option for multiple values on a parameter. On the SQL side, there is a way to pass an array of values to a parameter, but it has been a long time since I have done it and I don't have access to the source code anymore to reference it. Might try googling SQL array parameters.Hey, it compiles. |
|
|
|
|
|
|
SSRS Set up Parameters