Report layout issue - Textboxes, long text and page breaks I have a report based on one record.
There are several fields that can be extremely long (ntext).
The report itself basically has a heading next to a textbox so that the output looks like
heading text |fields to display
____________________________________________________________________________________
5. Client Name Joe Client
6. Business Background Background Text Bla Bla Bla
Family History Family History Text Bla Bla Bla
7. Question bla bla bla Yes
Explanation bla bla bla
______________________________________________________________________________________
For each section, I used a ListBox with textboxes inside.
With small text blocks to display all is good.
Then...
During the initial screen render, all looks excellent. When I switch to the page view or print the report, the large text blocks mess things up.
Just after the end of section 5, I'll see section 6. heading text, then the extremely long bla bla bla is on the next page.
At the end of section 6. I'll see the section 7. heading text with the extremely long bla bla bla on the following page. This happens for all large text blocks.
The simple observation is to turn off the 'Keep Together' property of the text box. But there isn't one. All I want is the textbox contents to flow from page to page.
I hope my explanation is acceptable, if you need more let me know. I really do appreciate any guidance or suggestions.
secoast Tag: using express edition
forms in reporting services Are you using Sharepoint or Report Manager
You will probably have to write a custom web app or web part to enter data into a sql database, or use the sql web data administrator tool.
There is no facility for creating a data entry form in reporting services.
regards,
Andrew Tag: using express edition
Fail to backup Hi,
I want to backup the Analysis Services database from the MS SQL Server Management Studio, but I received this error message:
The following system error occurred: Bad Data. .
Errors in the encryption library: Failed to decrypt sensitive data. Possibly the encryption key does not match or is inaccessible because of improper service account change.
How to fix this error
Thanks, Tag: using express edition
Strange Problem Hi,
I have a problem with email delivery, I scheduled a report on Report Manager for Email delivery. I could see the status as
Mail sent on Report Manager, sometimes the email is triggered to me and sometime I am unable to get email but still I see the message as Mail sent and i verified the log files I could see the message as Mail sent successfully.
I even verified the mails are not blocked but still I could get mail sometimes not all the times. Please help me in solving this strange problem.
Thanks in Advance. Tag: using express edition
How to include a Express 2005 database in a setup You may find this method of creating an MSI package useful.
Deploy Database with MSI http://msdn.microsoft.com/msdnmag/issues/04/09/customdatabaseinstaller/ Tag: using express edition
Which SELECT statement is faster Again,... hello all mighty exprerienced developers, here is a beginner :) I am working on app with lots of searches. So far i see two options. Having table with cca 40 columns of nchar data type, querring it with sentences like: WHERE '*3*' LIKE '*3*;*4*;*5*' OR '*5*' LIKE '*3*;*4*;*5*' etc. or have table with cca 200 boolean columns and querries like: WHERE field13 =TRUE OR field 15=TRUE etc. Does anybody know what is faster, how sql server works on one hand LIKE is heavy operation on system resources, on the other hand isn't 200 columns too much
tanx for suggestions Best regards, Grega Tag: using express edition
SSIS Logging feature YoungEngineer wrote:
i havent had much luck figuring out how to use the expression builder. can you tell me how i would go about renaming a staticly named file to something like "abcXXX.txt" where XXX would be todays date using the expression builder.
thanks
Dynamically set a logfile name
( http://blogs.conchango.com/jamiethomson/archive/2006/10/05/SSIS-Nugget_3A00_-Dynamically-set-a-logfile-name.aspx )
-Jamie Tag: using express edition
Degenerate Dimension Experts:
Pardon me for this basic question. A degenerate dimension as I understand does not have a parent dimension (pls correct me if I am wrong) in the fact table. In that case is it repeated in the fact table
For example if i have the following fact table
Productkey(FK)
Customerkey(FK)
Timekey(FK)
TicketNumber
All the first three (product,customer and Time) have dimensions while Ticketnumber has a orphan parent. In that case does its value get repeated in the fact table or is it usually a unique value
Please explain.
Thanks
Ankith Tag: using express edition
Reporting services with SQL Express Ok, here's the deal. I'm just learning sql express and I'm trying to get my reporting services worked out. I have everything installed and I have managed to connect to the report server at http://<computername>/Reports my problem is I can only connect to this page when I am at the machine where the sql database, reporting database, etc... I cannot log on to this site from any other computer no my network Does any one know why Thanks!!! Tag: using express edition
SQL Server Management Studio - Connecting to Server never connects to server I am trying to connect to a sql server 2005 server using either windows auth or sql server auth but I can not. When I click on the connect button to connect to a server it never connects. I can not cancel once I press connect. It never times out after I press connect. I removed all registered servers that were registered previously. I have uninstalled all software that involved sql server (and sql2000) run a registry cleaner(not microsofts), installed the software to a new directory and still I can not connect to the sql2005 server (the only db).
Any ideas
I am running Windows XP with latest services packs for both windows and sql server. I have visual studio 2005 installed on my machine and I have had sql express installed on it previously. Tag: using express edition
Show and render only one page my report generates most than a page, i want sent the parameters and render only the fist page , the if i need the other when the number page chage the control render the nex page, how i can do it, this because in this moment the control render all the report and the show it , and sometimes i have to wait to long time to see it
someone can help me Tag: using express edition
EXEC sp_insertRecord has too many arguments specified: Msg 8144, Level 16, State 2-Why I got this error? Hi Arnie, Thanks for your response.
I got the right ideas to do this procedures, after I read your response and went back to review my old stored procedure stuff - I should create the procedure first and then execute. Here is my revised shcSP_1:
USE shcDB
GO
CREATE PROC sp_insertRecord @procPersonID int , @procFirstName nvarchar ( 9 ), @procLastName nvarchar ( 9 ), @procAddress nvarchar ( 15 ), @procCity nvarchar ( 10 ), @procState nvarchar ( 10 ), @procZipCode nvarchar ( 10 ), @procEmail nvarchar ( 25 ) AS INSERT INTO MyFriends VALUES ( @procPersonID , @procFirstName , @procLastName , @procAddress , @procCity , @procCity , @procState , @procZipCode , @procEmail )
GO
EXEC sp_insertRecord 3 , 'Mary' , 'Smith' , '789 New St' , 'Chicago' , 'Illinos' , '12345' , 'M_Smith@Yahoo.com'
GO
//////////////////////////////////////////////////////////////////////////////////////
I executed the above code and I got the following errors:
Msg 213, Level 16, State 1, Procedure sp_insertRecord, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Msg 8144, Level 16, State 2, Procedure sp_insertRecord, Line 0
Procedure or function sp_insertRecord has too many arguments specified.
***************************************************************************************
I created the 'dbo.MyFriends' last year and I can not remember what I defined the table. And I do not know how to reveal the "table definition"
of my 'dbo.MyFriends. Could you please tell me how to reveal the "table definition" of my 'dbo.MyFriends in SQL Server 2005 Management Studio Express
Thanks again,
Scott Chang Tag: using express edition
Color Property Formatting not working correctly Hi,
I have a problem with a conditional format of the Color property in a matrix report. When the value of the textbox is greater than 0, the color should be Red otherwise it should be Blue. This is implemented via an IIF statement and works perfectly in Preview in Visual Studio 2005.
When the report is deployed, the formatting appears to be ignored and all values are the default value of Black.
Anyone else experienced this problem and, if so, is there a workaround Tag: using express edition
SQL server 2000 memory problem Hi to alll, I use sql server 2000 ver 8.00.2039 I would like to know if is possible to free some ram memory without restart the service . I have about 1.7 Gb of memory used I have just tried to use these commands DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE dbcc free but seems that nothing happens Any idea thank you in advance Tag: using express edition
I need to Give DBA full admin rights to SQL 2005 without OS windows rights, can anyone help please!! ok i think i figured out the surface area config issue, theres a link that states : Add new administrator in which i did and i can access all pages now, but it wont obviously let a non admin restart services, since there's a handful of services i think i'll just have/set the services under the SQL admins credentials, unless someone knows of a better way, in which i can allow the sql admin to restart services
On the other issue i still cant access the reporting service configuration page, still recieving a WMI error //
Please anyone HELP!! Tag: using express edition
when i run SnapshotGenerationAgent.GenerateSnapshot(), it fails. Hi Ariston, i have a similiar problem. I get the same error message, but i already gave the user and agent all the rights they need. As far as i think! My question here is: what if you run your code as a db_owner of the database and not as a admin Is it then also working Cause in my program its working as a sysadmin, but not when i execute as a simple "db_owner" of the database. I use the MS SQL Server 2005. Maybe you can help me out Greetings, MariJo Tag: using express edition
New to SSIS and can't seem to get started off right. I am trying to show my employer the benefits of using SQL SERVER (2005) vs. MS Access. My problem is I can't get past a something I believe to be simple.
I created a project in Business Solutions (I tried multiple times) - The idea of the project is to download a flat file from FTP, then pull the records into a table. I can get this to work without issue *IF* I execute this process by hand.
However, I would like to execute the project via a stored procedure. I am using
exec master..xp_cmdshell 'dtexec /F C:\ssis\new_package.dtsx'
My last version of the package just has the FTP download in it (I was trying to break it down to small steps) - when executing I get an error
" Description: Failed to decrypt protected XML node "DTS:Property" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that..."
I'm not sure if that error is important or not (I guess every error is important). However, the one that bothers me the most is
" Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed"
I know the password I set in the FTP function is correct, because I can run it by hand. Can someone please offer me some direction
Thank you very much.
Greg Kane Tag: using express edition
MDX Calculation Question - need to filter out a response value in overall calc All right, I have been trying to come up with a solution for this problem, but so far I have had no luck. Maybe someone else can point me in the right direction:
I am working with some results from surveys and each respondents has a weight value related to them for each of their responses to the questions. So if respondent #1 has a weight value of 1.5 and respondent #2 has a weight value of 2 and respondent #3 has a weight value of 1.75 and they respond to the following questions like such:
Respondet# Question Response Weight
1 Drink Light Beer Yes 1.5
1 Drink Regular Beer Yes 1.5
2 Drink Light Beer Yes 2.0
2 Drink Regular Beer No 2.0
3 Drink Light Beer No 1.75
3 Drink Regular Beer No 1.75
My over all calculation is to take the Weight value for the respondents that responded with ¡®Yes¡¯ and divide by the Weight value of all of the respondents. The gotcha is that if the respondent selected ¡®Yes¡¯ to more than one Question then I want to only include them once in the numerator.
What I am getting is: (1.5+1.5+2.0)/(1.5+2.0+1.75) = .95238
What I want to get is: (1.5+2.0)/(1.5+2.0+1.75) = .66667
As of right now I do not know how I can filter out the first respondents second response of ¡®Yes¡¯.
Right now my MDX looks like the following:
([Beverage].[Report Response Text].&[1], Measures.[Weight Value])/ iif ( count ( descendants (beverage.[alcohol]. currentmember ,, after ))>0,Measures.[Weight Value]/ count ( descendants (beverage.[alcohol]. currentmember ,, after )), Measures.[Weight Value])
The denominator in this query is basically determining if there are multiple children associated with the Alcohol Type (which in this case would be Beer and the children would be Light Beer and Regular Beer). I am then taking the Weight and dividing it by the number of children associated with the Alcohol Type (which in this case would be (1.5+1.5+2.0+2.0+1.75+1.75)/2 = 5.25). The Report Response Text value of 1 = Yes and 2 = No.
Does anyone have any suggestions on how I can filter out the second ¡®Yes¡¯ response for Respondent #1 Tag: using express edition
OLEDB to Flat File Destination - Comes out in wrong order MrHat wrote:
The only property that Data Flow Editor has is "PathAnnotation".
Is there anything from the toolbox I can use between the OLE DB Source and the Flat File Destination to make sure that my columns will come out in the right order
Thank you.
You have to open the connection manager....all you need is there. Tag: using express edition
Server: Msg 22029, Level 16, State 1, Line 0 Hello everyone and happy new year.
This is related to a maintenance plan that pushes data from one to another continuesly and eventully backs up the database.
This is the code "
EXECUTE master.dbo.xp_sqlmaint N'-PlanID CA2CE438-C14B-442C-AB75-D2838EAA8076 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB " \\dca-05\sqldumps\weekly " -DelBkUps 3WEEKS -BkExt "BAK"'
Problem is I continue to get errors:
(9 row(s) affected)
Server: Msg 22029, Level 16, State 1, Line 0 sqlmaint.exe failed. Tag: using express edition
OUTER JOIN plus split? - how to? Hi,
I have two tables.. one has a list of the UK postcodes.. well..it's actually the districts..
so it's the first two three or four characters (basically all UK postcodes are one or two letters.. then one or two numbers.. then a gap.. and then some more info)
So my first table has everything "before the gap" in seperate records.
My second table is full of exact postcodes.. so everything before and after the gap.
What I need to do is.. for each "full" postcode I have... strip it down so I get it formatted to everything before the gap.. and then find out how many of those I have...
This is also complicated because many of the "full postcodes" don't have the gap.
so if I have:
er56 7tr fr2 4tg er567tr po3 8ty
I would want results of:
er56 - 2 fr2 - 1 po3 - 1
One I have that, I can bring in the second table with all of the parcial postcodes to do an OUTER JOIN and get the postcodes where I DONT have any results.
I know that's pretty complicated, so I'm stuggling a little!
sO i need to get the first "X" amount of characters out of a db value (it could be two values.. could be up to four- first one or two will be char, second one or two will be numeric), then do a count.
Can anyone help Tag: using express edition
SQL server 2005- hanging problem SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems.
server is 64 bit, Windows 2003 R2 SP2
SQL server is MS SQL Server 2005 without any Service pack
Any ideas guys
Server stopped responding to the queries so after waiting for a while we had to reboot the machine. Now it is fine but can get the error again any time.
Thanks Tag: using express edition
User Tables Hi, i'm a new in this, so when i create a Login form on VS 2005, i have a little trouble, i already create the db with a table called users and another called things, so the thing i wanna do is authenticate the users, for this on the table i have a 2 rows, "Users" and "password", an when in the login form i put the user an passwor i¡¯t'll be the same on the table, but when i debbug, it shows me
Cannot open database "clientes" requested by the login. The login failed. Login failed for user 'MOBILEWORK\mikke.
thanks!!!!!!!! Tag: using express edition
SSIS Service won't start Additional info (from http://msdn2.microsoft.com/en-us/library/ms143504.aspx ):
Identifying Instance-Unaware Services
Instance-unaware services are shared among all installed SQL Server instances; they are not associated with a specific instance, are installed only once, and cannot be installed side-by-side. Instance-unaware services in SQL Server 2005 include:
Notification Services
Integration Services
SQL Server Browser
SQL Server Active Directory Helper
SQL Writer Tag: using express edition
Maintaining custom colors when exporting to Excel I am using RGB HEX #s in my report for some colors. It shows up fine when rendering to a browser, however when exporting to Excel my custom colors don't come over. I've tried creating a report.xlt file with my custom colors in it, but when I export to Excel it uses the standard Excel palette instead of the custom palette in my report.xlt.
Any ideas on how to retain my custom colors when exporting to Excel Tag: using express edition
satyanarayana
is it possible to use VS Express Edition to create .NET CLR Stored Procedures
Sure you can, but you can not deploy automatically from inside VS.
1. Create a normal class library 2. write your methods as public static 3. Compile 4. Deploy the assembly to the database (look in BOL for CREATE ASSEMBLY) 5. Create T-SQL wrapper procedures/functions/triggers against your CLR methods (look in BOL for CREATE FUNCTION/PROCEDURE/TRIGGER)