Is there a reason why a single cell in a table with the CanGrow property set to true will grow down, and merged cells grow right, and is there any way around it?
I have a report that I have to display comments, so I merged 2 cells put the comment field in it, and when it is displayed in the browser, it expands off the page.
When it prints, it seems to be fine, but the majority of my users will be viewing online in a browser.
Any ideas? just an HTML thing I am thinking, and nothing can be done about it.
I'm trying to eliminate merged cells when exporting a report to Excel. My problem being my report textbox above my table.
I've searched and found that making the textbox the same width as the first column eliminates the merging. Perfect, it does. But when the report is viewed in the report viewer, the textbox can only expand vertically. So the title looks terrible because column one is not wide.
I've read that expand horizontally is not an option I don't seem to be able to tell it not to output that text box, which would be an option if there is no other answer I can't have the text box the size I want it, due it creating merged cells I don't want to export it as a CSV
Are there any other options available or am missing something?
I receive this error during rendering when I have two cells merged together:
Error Snippet
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
When I "Split Cells" on the offending cells, it starts to work. This report renders without error when run on the RS server. This error only occurs when running the report locally on the "Preview" tab in the report designer.
I have closed the IDE and deleted the *.data files and restarted with the same results. Is there anyway to get more information about the error to help debug the problem?
I am trying to split cells that are merged as part of a grouped report. Am using the right-button menu and pressing "Split Cells" when it appears but it just splits into two parts and not into single cells or rows. When I right-button on one of the parts that came out of the split, I do not get a "Split Cells" to break it down further. Want to be able to split the grouped cells into individual cells or rows and have the rows be different colors. How can I do this?
I have a basic matrix report but whenever I export this report to Excel, some of the cells end up becoming merged. Is there any way to avoid this using Reporting Services instead of formatting the cells directly in Excel?
I have a matrix table in a report. The cells CanGrow field is set to true. When the report is generated in the browser, the row height grows according to the content in the cells. However, when the same report is exported to an Excel document, the row height is fixed and the content in the cells are partially hidden.
Is there anyway to get Excel report generator to recognize the CanGrow setting?
I have a report with a column which contains either a string such as "N/A" or a number such as 12. A user exports the report to Excel. In Excel the numbers are formatted as text.
I already tried to set the value as CDbl which returns error for the cells containing a string.
The requirement is to export the column to Excel with the numbers formatted as numbers and the strings such as "N/A' in the same column as string.
Lets say I have a table PortDates with 3 columns like this:PORT ARRIVALDATE SAILINGDATENewYork 12-15-2004Rio 10-12-2004Hamburg 10-14-2004etc.I want to sort the ports on dates from both date columnsSELECT Port FROM PortDatesORDER BY (ArrivalDate JOIN SailingDate)Now, that doesn't work of course, but what should I write to get it to workso I can order by the dates as if they were one merged column?Join Bytes!
i have a client who is dissatisfied with the merged columns and rows produced when SSRS renders to Excel, it prevents them from easily copying and pasting data into another workbook.
Is there going to be any work done in this area of the product in the near future? My understanding is that this 'issue' has been around for quite some time, and shortly after the SSRS2005 RTM release the team were going to look at tidying up the Excel rendering. Can anyone from MS make an official comment on this?
In the footer from a report I want to print the UserID and the Date. I added a textbox with de following code: =User!UserID & " " & Globals!ExecutionTime
Now I want to change the date format in dd-MM-yyy uu:mm. This is not possible in the textbox properties because I added the UserID to the same textbox. Is there a way to change the format?
Hi,I have boolean values in a table for ex. Federation. And I want toselect followingSelect 'Insert into' + member + 'test' as test1from federationThen I get error messageServer: Msg 403, Level 16, State 1, Line 1Invalid operator for data type. Operator equals add, type equals bit.Someone can help me out of it.Thanks an advance- Loi -
Hi, We have an existing merged replication schema that works well. One of the tables is named audit. Currently this is a bidirectional transfer. However, we want a new audit table that will transfer data from the subscriber to the publisher and not the other way round. I have a script that was generated as a backup script when replication was first created. I have no idea which parameter to change in order to have the merge replication going from subscriber to publisher. Any advise is helpful. Thanks.
I have a report in that report having some Text boxes and below tables.But the problem is when i export the report into excel textboxes are merged, not getting properly.
How do i do a loop to insert excel records to new excel worksheet as i onli want a certain of the columns from the existince excel. For the existince excel mi got record of column A - M then i just need to copy data of A - L then copy from the same existince column H data to the new excel worksheet. For those who know pls put up codes for me so tat i can have a better understanding over it . THankz
i need to sum the values in different cells of an excel sheet which im getting from data base and which is in a loop and the number of entries depends on the user.Please help me out
dim objConn set objConn=server.CreateObject("ADODB.Connection") objConn.open "provider=SQLOLEDB;data source=10.100.17.107;initial catalog=RUT;user id=test;password=test;"
if iMonth = "February" and iYear mod 4 <> 0 then iTo = 28 elseif iMonth = "February" and iYear mod 4 = 0 then iTo = 29 end if
if (iMonth = "April" or iMonth = "June" or iMonth = "September" or iMonth = "November") then iTo = 30 end if
if (iMonth = "January" or iMonth = "March" or iMonth = "May" or iMonth = "July" or iMonth = "August" or iMonth = "October" or iMonth = "December") then iTo = 31 end if
dim rsobj1,rsobj2,rsobj5,rsobj9
sql1 = "select first_name from tblUserMaster where emp_id='"&inteid&"'" set rsobj1 = objConn.Execute (sql1)
sql2 = "select distinct activity_id from tblTimeSheet where month='"&iMonth&"' and year='"&iyear&"' and project_id='"&intpid&"' and emp_id='"&inteid&"' and bill_non = ''" set rsobj2 = objConn.Execute (sql2) %>
<% do until rsobj2.EOF%> <tr> <% dim intactid,rsobj3 intactid = rsobj2("activity_id")
sql3 = "select activity_name from tblActivityMaster where activity_id = '"&intactid&"'" set rsobj3 = objConn.Execute (sql3)
sql4 = "select no_of_hrs,remarks,date from tblTimeSheet where month='"&iMonth&"' and year='"&iyear&"' and project_id='"&intpid&"' and emp_id='"&inteid&"' and activity_id='"&intactid&"'" set rsobj4 = objConn.Execute (sql4)
%>
<td><%=rsobj3("activity_name")%></td> <td></td> <td><%=rsobj4("remarks")%></td> <td></td> <%do until rsobj4.eof%>
<%if (rsobj4("no_of_hrs") < 8 ) then%> <td><%=rsobj4("no_of_hrs")%></td>// I need to add the values i get in this td and display in the td with red colour and the number of values may change according to the user <%else%> <td>8</td> <%end if%>
I am trying to import Data from an Excel file to a SQL DB table. there are around 106 rows and 2 columns. By default, the ssis is selecting around 200 columns and over 2000 rows. But all cells except for the 2 columns and 106 rows are empty. While I can specify that I need to read only 2 columns, I could not figure out a way to specify the rows. Any help?
Does anyone know if there is such a quary that can be written which would add up(or any math functions) a line of cells (on different rows) similar to that of working with a excel document?
If so please steer me towards the correct syntax for this.
I have two questions. I am somewhat of a novice at this but would really appreciate some help.
Table = svc There are multiple columns but I just need adjustments in the first 2.
Current Table: code name svctype CTS0003CT Abd Ltd 51608 CTS0005CT Abd W Cont 51608 CTS0011CT Abd WWO Cont 51608 CTS0013CT Abd WO Cont 51608 CTS0023CT Abd-Ltd Pel W Cont51608 CTS0025CT Abd-Ltd Pel WO Cont51608
What I want it update it to: code name svctype RCT0003AR CT Abd Ltd 19254 RCT0005AR CT Abd W Cont 19254 RCT0013AR CT Abd WO Cont 19254 RCT0011AR CT Abd WWO Cont 19254 RCT0023AR CT Abd-Ltd Pel W Cont19254 RCT0025AR CT Abd-Ltd Pel WO Cont19254
QUESTION #1: So I am trying to figure out if I could write a statement that basically updates the CODE column’s first three letters in each cell from CTS to RCT and retains the numbers afterwards.
QUESTION #2 The NAME column in Table 1 would also need a little adjustment. I need to add AR in front (almost like a prefix) of all of the descriptions (so that it looks like Table #2). How do I insert something into the description?
I greatly appreciate anyone's help in this. It would save me counltess hours. -T.C.
Any way to merge cells vertically in SSRS 2005? I know w can do it horizontally by right clik, then select "merge cells". How about vertically? Thanks.
I am trying to now access the data (if any) in the current cell of a table. I want to know if this cell has been populated, and if so to move on...if not then I want to populate with a zero.
I am using the following:
ReportItems!textbox9.Value inside of an if statement but it tells me that I am unable to do so as, and I quote:
"The Value expression for the textbox 'textbox 9' contains a direct or indirect reference to itself. Loops in expressions are not allowed."
In a matrix, is it possible to have the cell dynamically size itself horizontally (like a horizontal scroll bar)? The numbers are wrapping to the next line if they're too large to fit in the cell and it is too complicated for me to balance at compile time how large these numbers will be with the number of columns that are on the report.
Hi, I know that we can have User Defined Functions (UDFs) for columns but is it possible to have UDFs for each cell (like we can define functions for each cell in excel). Heres the situation: I have a database table that will have multiple fields. Some of the columns will be functions of other columns. One of the columns has variable functions. Heres an example: TABLE(A, B, C, D) Total Records = 9;
A B C D
A1 B1 C1 = A1+ B1 D1 = A1
A2 B2 C2 = A2+ B2 D2 = A2
A3 B3 C3 = A3+ B3 D3 = A3
A4 B4 C4 = A4+ B4 D4 = A4
A5 B5 C5 = A5+ B5 D5 = A5 + B5
A6 B6 C6 = A6+ B6 D6 = A6 + B6
A7 B7 C7 = A7+ B7 D7 = A7 + B7
A8 B8 C8 = A8+ B8 D8 = A8 + B8
A9 B9 C9 = A9+ B9 D9 = A9 + B9 If you notice, for Column D, some of the cells have a different formula than others. Is this doable? Thanks...
I have a DB migrated from SQL Server 2000 to SQL Server 2005 and I have a strange problem that I don't find any reason.
I make a simple SQL Query with one table showing all the fields and everything goes well. But when I insert another auxiliar table and showing one field, then I can't change any field of the main table. SQL Server shows me the message Read Only Cell. Why this happens? This problem didn't happen in SQL Server 2000.
The select sentence that works:
SELECT Notas_Estructura.* FROM Notas_Estructura
The previous Select sentence modified that doesn't work:
SELECT Notas_Estructura.*, Alumnos.Apellido1, Alumnos.Apellido2, Alumnos.Nombre FROM Notas_Estructura INNER JOIN Alumnos ON Notas_Estructura.CodAlumno = Alumnos.CodAlumno
I want to join the two tables to add the Code of CodeType "C" to the records of NAMES
Result Example IDNameCode 1FIRSTgfd 2SECOND----
I want to have all records from the names with the codetype C, if there is no record with the codetype c for a given ID, the cell should be blank to identify for which ID's the CodeType C is mising.
Tools: SQL Server 2K, Excel 2000Hi,I have an Excel report worksheet with formatted headings. What I wantto do is to export data from the SQL server into a specific cell of theexcel file. Is this doable? Can somebody give me some direction on howto accomplish this?I appreciate any suggestions.Edgar J.
