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 |
|
Brutoxx
Starting Member
21 Posts |
 Posted - 2005-03-24 : 16:46:14
|
| Is there a character limit under the data tab for Text? I wrote a query but I believe it exceeds the allowed length because I can not past all of it.Have a nice day! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-24 : 16:49:39
|
| Use Query Analyzer to view the results of your query as the data tab should just be used to setup the parameters and fields and for quick viewing of the data. For QA, go to Tools..Options..Results, make sure to change the maximum characters per column to a higher value than the default.Tara |
 |
|
|
Xerxes
Aged Yak Warrior
666 Posts |
Posted - 2005-03-24 : 16:59:23
|
This stuff should be on this site listed under SQA FAQ. Semper fi, XERXES, USMC(Ret.)------------------------------------------------------The Marine Corps taught me everything but SQL! |
|
|
|
Brutoxx
Starting Member
21 Posts |
Posted - 2005-03-24 : 17:16:00
|
| Where should I store My query to be runned?I wrote it and tested it in query analizer no problem, when I pasted in the reporting server's data tab, that's when it cut's the bottom half of the query off... Have a nice day! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-24 : 17:18:50
|
| The data tab is where you tell the report which query to run. Then in the second tab, you design the report. The actual report will not have the bottom half cut off. So if it's already been tested in QA, then you don't need to run it anymore inside the data tab. You just set it up once, then design your report to reference it.Tara |
|
|
|
Brutoxx
Starting Member
21 Posts |
Posted - 2005-03-28 : 11:42:16
|
| But the long query I wrote? Where do I put that if not on the Data Tab? Are you saying that the data tab is only for Stored Procedures?I am a bit confused?Have a nice day! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-28 : 12:42:57
|
| Well perhaps there is a query size limit then when you don't use stored procedures. You should be using stored procedures anyway, which will allow you to have this long query.Tara |
|
|
|
Brutoxx
Starting Member
21 Posts |
Posted - 2005-03-28 : 13:03:00
|
| thank you Tara... I managed to get this to work using a stored Procedure. Now, I export my report to Excell and I would like to know if there is a way to rename each excel sheet using data from the report?Have a nice day! |
|
|
|
|
|
|
Character Limit