Matrix Show Repeated Data

Jan 12, 2007

Hi,

i have a matrix with some fixed columns. when the fixed columns have repeated data, the repeated data is hidden.

how do you show the data all the time??

eg. i have:

Customer - Month - bikes - balls - toys - Total

Sam - January - 0 - 4 - 10 - 14

- February - 3 - 2 - 8 - 13

- March - 2 - 0 - 9 - 11

Tom - January - 2 - 5 - 2 - 9

- February - 5 - 2 - 8 - 15

- March - 1 - 6 - 3 - 10

but i want it to show like this:

Customer - Month - bikes - balls - toys - Total
Sam - January - 0 - 4 - 10 - 14
Sam - February - 3 - 2 - 8 - 13
Sam - March - 2 - 0 - 9 - 11
Tom - January - 2 - 5 - 2 - 9
Tom - February - 5 - 2 - 8 - 15
Tom - March - 1 - 6 - 3 - 10

Thanks.

View 3 Replies


ADVERTISEMENT

How To Show All Data In A Matrix

Nov 30, 2007

Hi to all


How do I can to show all data group by for one row using a matrix? Example:


Title ID

Harry Potter 0001
0002

0052
0120
Shrek 0003
0004
0050




Sorry for the English, I'm Brazilian.
Thank's for all

View 2 Replies View Related

Show Columns On Both Matrix Regardless Of Population Of Data

May 1, 2008



I have used two matrix in one of my reports. One matrix is right above other. Both matrix's columns are allocated for month name. I.e there are 12 columns for each month of the year for each matrix.
column name of the second matrix was hidden. so end user can see only first matrix column name and corresponding data in each matrix.
But the problem is now, when there is no data for perticular month in first matrix, thats month's column does not appear at all.
Lets say there is no data for November in first matrix. so Novem column is missing in first mtrix now. but still Novem column is shown on the second matrix as it has some data, although column name is not shown. I wonder how I can show all the columns of both matrix regardless of population of data.

Thanks

View 1 Replies View Related

Matrix Column Repeated On Every Page.

Mar 7, 2007

Hi guys,

I have a matrix report with one row group and one dynamic column group. My issue is that I want to see the column group to be appeared only on the first page of the report not on every next page, because I am going to finally export the report to Excel spreedsheet so I don't want the column to be repeated in the middle of the records.

Let me know if anybody has some idea.

Thanks!

--Amde





View 1 Replies View Related

Show Detail Data On A Matrix Rather Than Aggregate Data

Dec 12, 2007



Hi all experts,

I have a result set like:





Project

Milestone

Info


Project1

M1

Info1


Project1

M1

Info2


Project1

M2

Info3


Project2

M1

Info4


Project2

M2

Info5


Project3

M1

Info6


I need to create a report like:







M1

M2


Project1

Info1
Info2

Info3


Project2

Info4

Info5


Project3

Info6




But while I use matrix to build this report, I got the result like:







M1

M2


Project1

Info1

Info3


Project2

Info4

Info5


Project3

Info6




The report will not show the multiple records on the row group "Project" like item "Info2".

After I referred to the similar problem mentioned on this forums, I tried to use "RowNumber("Matrix1_Project")" to resolve it. But still I got the result like:









M1

M2


Project1

RowNumer

Info1






RowNumer

Info1






RowNumer



Info3


Project2

RowNumer

Info4






RowNumer



Info5


Project3

RowNumer

Info6



It would be much appreciated if anyone could give me some hints to complete the report I need.

Thanks in advance,
Steve Wang 2007/12/12

View 5 Replies View Related

How Do I Show All Columns In A Matrix Even If There Are No Data Rows Using The Column On A Given Page?

May 31, 2007

I have one column in a matrix component and it has about 7 items, but the only the items which have values on the page appear at the top of that page.



This is for a labratory so the columns are the different Patient Types and the rows are the different Test Mnemonics. If one of the Patient Types is not used in any of the tests on that page, it doesnt show up. How to I make sure all Patient Types show up on every page?



Thank you all.

View 2 Replies View Related

Search Repeated Record And Give Suggestion As Most Repeated One

Sep 4, 2007

I have problem, i wanted a query which will search the duplicate and then give suggestionmost repeated word
Table containing the records like below








ID 
Movie Name 
New Name

1
Spider Man 
Spider Man

2
Spider Man 2 
Spider Man

3
Spider Man 3 
Spider Man

4
Spider Man UK 
Spider Man

5
Spider Man USA 
Spider Man

6
New Spider Man 
Spider Man

7
Spider Man Black 
Spider Man

8
Spider Man Part 1 
Spider Man

9
Spider Man Part 2 
Spider Man

10
Spider Man I 
Spider Man

11
Spider Man III 
Spider Man

12
Spider Man Part II 
Spider Man
My manufacturer send me the data in this format and i have to allocate there new name
to do some comparison
I wanted to make this process automatic.
what i mean is i need a query which will give me a repeated records  along with suggestion
as new name.
I am fully confident that you  guys will help me out from this problem.
Looking forward

View 9 Replies View Related

Matrix Problem - Can I Show All Columns?

May 21, 2008

Good morning all.

I have a report that is set up as a matrix. The repor shows data relating to review numbers (for example 1-6). Based on the date range selected from my parameters the report will show stats and the matrix grouping is by the review number.

My question is this, if the dataset returns only some of the review numbers, can I do anything to show the other review numbers? They will always be from 1-6.

Thanks

View 4 Replies View Related

How To Show Single Row Wise Percentage In Matrix

Feb 11, 2008



Hi,

I'm using Reporting Services 2005. In my report I'm binding data in a matrix by grouping 3 row fields (nested within each other) and 1 column field. Now I get the subtotals alright but I also want to get percentage at row1 only rather than grouping it with either in row or in column. I've tried so many ways but am not able to do it. Can anybody help me on this or is there a way in SSRS 2005 to get over this.


Also please suggest something instantly, as I'm terribly in the need
Thanks

View 1 Replies View Related

Repeated Data

Dec 21, 2004

If I have a student table with 3 columns ID, FirstName and LastName
ID- FirstName -LastName
-------------------------
1 Tom Hanks
2 Jerry Thomas

and I have a subject table with two columns StudentID and Subject. StudentID is a foreign key to the student table.
StudentID - Subject
------------------------
1 History
1 Biology
2 History

If my query is
select distinct student.id, student.fname, student.lname, student.subject from student
left outer join subject on student.id = subject.studentid

then I get
1 Tom Hanks History
1 Tom Hanks Biology.

Is there a way I could get
1 Tom Hanks History
null null null Biology

--> meaning I don't want to repeat data??

thanks
Teena

View 1 Replies View Related

Hide Calculated Column In Matrix Report And Show Only In Total

Sep 25, 2007



Hi All,

I need to show the Cumulative calculated value only in Total by year/Group. I could not use Visibility expression using

InScope, as it creates *Blank column. Please go thru details below.



Year
Month01 02 03 Total
Salary Salary Salary Salary Cumulative (Calc)

Employee01 20 5 25 25
Employee02 10 10 20 45
.....
Total


How can i achieve this?. Any suggestion on this would be appreciated.

Thanks,

View 1 Replies View Related

Reporting Services :: Columngrouping In Matrix Don't Show Existing Items

Oct 12, 2015

I'm trying to create a report in SSRS using a Matrix.

The data in my dataset looks like this one:

Part      Action   SortID  Count
---------------------------------------------------
Login      LA1      1         12
Login      LA2      2         25
Login      LA3      3         548
Register  RA1      1         12
Register  RA2      2          56

I have one rowgroup by the column Part and one columngroup by SortID and my Data should look like this:

Login          LA1       LA2        LA3
                  12         25         548
Register      RA1       RA2
                  12         56

But it looks like

Login          LA1       LA2        LA3
                  12         25         548
Register      RA1       RA2       LA3
                  12         56

how I could solve my Problem, that in row number 2 the LA3 isn't shown?

View 4 Replies View Related

Rows Repeated With Same Data

Dec 17, 2013

For the below mentioned query their is repetition of rows with the same data.

SELECT srs.prod_area as PA,
srs.art as ArtNo,
b.adsc_unicode as ArtName,
cast(case when a.unit <> '2' then c.avsx/10 else c.avsx/1000 end as integer(2)) as AwsMHS,
cast(srs.estimate/10 as integer(1)) as AwsSRSThisWeek,

[Code] ....

View 4 Replies View Related

Need To Avoid Repeated Data In A DataGrid

Apr 15, 2004

Hi there :)

I am developing a system for my uni course and I am stuck a little problem...

Basically its all about lecturers, students modules etc - A student has many modules, a module has manu students, a lecturer has many modules and a module has many lecturers.

I am trying to get a list of lecturers that run modules associated with a particular student. I am able to get a list of the appropriate lecturers, but some lecturers are repeated because they teach more than one module that the student is associated with.

How can I stop the repeats?

Heres my sql select code in my cs file:

string sqlDisplayLec = "SELECT * FROM student_module sm, lecturer_module lm, users u WHERE sm.user_id=" + myUserid + "" + " AND lm.module_id = sm.module_id " + " AND u.user_id = lm.user_id ";
SqlCommand sqlc2 = new SqlCommand(sqlDisplayLec,sqlConnection);
sqlConnection.Open();
lecturersDG.DataSource = sqlc2.ExecuteReader(CommandBehavior.CloseConnection);
lecturersDG.DataBind();

And here is a pic of my Data Model:
Data Model Screenshot

Any ideas? Many thanks :) !

View 1 Replies View Related

Removing Rows With Repeated Data

Sep 7, 2005

I am running a query on multiple tables and the data I get back consists of several repeated rows but with one column different. I want to take out those repeated rows and for the column that is different join that data and separate it by a comma. Can this be done?

Ex.
Cindy Lair 111 Drury Circle Harrisburg Pennsylvania 717
Cindy Lair 111 Drury Circle Harrisburg Pennsylvania 610
Cindy Lair 111 Drury Circle Harrisburg Pennsylvania 310

So i would like this data to come up as:
Cindy Lair 111 Drury Circle Harrisburg Pennsylvania 717,610,310

View 7 Replies View Related

Normalization - How To Get Repeated Data From Existing Table

Jul 8, 2014

What I need to know is how to get repeated data from a existing table, to normalized tables with out typing it...

Example:

---------------------
| ID |TEXT | TAGS |
---------------------
| 1 |text1|repeating|
| 2 |text2|repeating|
----------------------

How to normalization would be use 3 tables ,one for tags_id and tags, and another relating the tags_id to ID from the table above...but how does the code already know there is a tag called repeating?

View 3 Replies View Related

HELP!!! Creating Nested Data In Repeated Region Problem

Jul 28, 2007

Hi All, Would appreciate some assistance with the attached, I'm using some fairly complicated recordsets (ASP VBScript) for a property search website, I have a page where a user selects search by County this in turn takes them to a page which lists all the towns in the county and number of live properties in each, I'm using 4 recordsets for this - 3 of which list the towns (townsA2I, townsJ2R & townsS2Z) the 4th is a Property Count, examples of the recordsets are below (using townsAtoI and LiveProperties -

TownsA2I

<%
Dim TownA2I
Dim TownA2I_numRows

Set TownA2I = Server.CreateObject("ADODB.Recordset")
TownA2I.ActiveConnection = MM_recruta2_STRING
TownA2I.Source = "SELECT towncountyID, Town, County FROM dbo.easytolettowncounty WHERE Town LIKE 'A%' AND County = '" + Replace(TownA2I__MMColParam, "'", "''") + "' OR Town LIKE 'B%' AND County = '" + Replace(TownA2I__MMColParam1, "'", "''") + "' OR Town LIKE 'C%' AND County = '" + Replace(TownA2I__MMColParam2, "'", "''") + "' OR Town LIKE 'D%' AND County = '" + Replace(TownA2I__MMColParam3, "'", "''") + "' OR Town LIKE 'E%' AND County = '" + Replace(TownA2I__MMColParam4, "'", "''") + "' OR Town LIKE 'F%' AND County = '" + Replace(TownA2I__MMColParam5, "'", "''") + "' OR Town LIKE 'G%' AND County = '" + Replace(TownA2I__MMColParam6, "'", "''") + "' OR Town LIKE 'H%' AND County = '" + Replace(TownA2I__MMColParam7, "'", "''") + "' OR Town LIKE 'I%' AND County = '" + Replace(TownA2I__MMColParam8, "'", "''") + "' ORDER BY Town ASC"
TownA2I.CursorType = 0
TownA2I.CursorLocation = 2
TownA2I.LockType = 1
TownA2I.Open()

TownA2I_numRows = 0
%>

LiveProperties

<%
Dim LiveProperties
Dim LiveProperties_numRows

Sub sLivePropertyCount(vLocation)
vCount=0

Set LiveProperties = Server.CreateObject("ADODB.Recordset")
LiveProperties.ActiveConnection = MM_recruta2_STRING
LiveProperties.Source = "SELECT COUNT(PropertyID) As NumberofProperties, propertylive, propertylocation FROM dbo.easytoletproperty WHERE propertylive = 'y' AND propertylocation = " & vLocation & " GROUP BY propertylocation, propertylive"
LiveProperties.CursorType = 0
LiveProperties.CursorLocation = 2
LiveProperties.LockType = 1
LiveProperties.Open()

vCount=(LiveProperties("NumberofProperties"))
Response.write(vCount)

LiveProperties.Close()
Set LiveProperties = Nothing
end sub

LiveProperties_numRows = 0
%>

I've tried following the tutorial here http://www.webthang.co.uk/tuts/tuts_dmx/rob9/rob9.asp but when i review the page i get the following error -

"Microsoft OLE DB Provider for SQL Server error '80040e14'

Invalid column name 'Barnet'.

/PropertiesbyTown1.asp, line 338 "

Where line 338"

Where line 338 is the "LiveProperties.Open()" of the above recordset, when i try to view bindings on this recordset Dreamweaver gives me the following errors -

"Column 'dbo.easytoletproperty.propertylive' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.

Column 'dbo.easytoletproperty.propertylocation' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause."

I would appreciate any assistance -

View 1 Replies View Related

Comparing Similar Tables - Removing Duplicate Or Repeated Data

Sep 30, 2007

It seems that there should be a solution for my situation, but for the life of me I can't seem to figure it out.

I need to compare two "like" tables, containing similar data. Tbl 1 is "BOOKED" (which is a snapshot of inventory) and tbl 2 is "CURRENT" (the live - working inventory table). If I write my query as follows the the subsequent result is "duplicate" data.




Code Block
SELECT booked.item, booked.bin, booked.quantity, current.bin, current.quantity
FROM BOOKED
LEFT JOIN
CURRENT
ON booked.item = current.item







No matter what type of join I use, there is duplicate data displayed for each table. For example, if there are more bins in the BOOKED table that contain a certain product then the CURRENT table will repeat data and vica versa.

As follows:







Item
Bin
Quantity
Bin
Quantity

12345
A01
500
A01
7680

12345
B01
6
A01
7680

12345
C01
20
A01
7680

54321
G10
1032
E15
1163

54321
G10
1032
F20
523

54321
G10
1032
H30
750

98765
Z20
7000
Z20
8500

98765
Y15
2500
Y15
3000

98765
X10
1200
Y15
3000

What I would like to do is display Bin and Quantity only once and the repeating values as NULL or [BLANK]. Or, to display all of the bins from both tables and only the quantities from each table in relation to the bin found in that table, returning a "0" if no quantity exists.

This is what I'm after:







Item
Bin
Quantity
Bin
Quantity

12345
A01
500
A01
7680

12345
B01
6
B01
0

12345
C01
20
C01
0

54321
G10
1032
E15
1163

54321
F20
0
F20
523

54321
H30
0
H30
750

98765
Z20
7000
Z20
8500

98765
Y15
2500
Y15
3000

98765
X10
1200
X10
0



Is this possible? If so, how?

I also might add that it is ok for each table to contain multiple entries for any given item. This is basically being requested as an inventory variance report - inventory before physical count and immediatly after physical count - and will only be run once a year.

-----------------------------------------------
Just thinking out loud here:
What if I created three subqueries, the first containing only BOOKED information, the second containing only CURRENT information and the third being a UNION of both tables? Something like this:




Code Block
SELECT q3.bin, q1.item, ISNULL(q1.quantity, 0) as QTY_BEFORE, ISNULL(q2.quantity, 0) as QTY_AFTER

FROM

(select item, bin, quantity
from BOOKED)q1
Left Join

(select item, bin, quantity
from CURRENT)q2
on q1.item = q2.item
Left Join

(select bin, item
from BOOKED
UNION
CURRENT)q3
on q1.item = q3.item

Order By q1.item





I don't know if I wrote the UNION statement correctly, but I will have to try this when I get back to work...


Any suggestions?

View 7 Replies View Related

How To Show Field Name Or Field Title In Matrix

Nov 19, 2007



Hi,

A very simple question but I cannot find how, please share with me if you know how to display Field Name or Field Title in Matrix at Rows ?

Thanks
best regards,
Tanipar

View 1 Replies View Related

Collapsing/Expanding Group Data In Table And Matrix Data Regions

May 30, 2007

Hi,



Is it possible to create Expand/Collapse functionality for the grouped data in Table and Matrix data regions? Essentially, the idea is for the user to be able to see the group/subgroup data if she wishes to by clicking on (+/-) symbols, as is usually the case in Tree View style data grid control in web apps. Any ideas how to accomplish the same in reporting services?



Thanks.

View 1 Replies View Related

Transact SQL :: Table Row Data Show In Column Data

Oct 22, 2015

I have a simple table data i want want to show row data in to column data.
      
SELECT clblcode,mlblmsg
FROM warninglabels

My expected result will be 

0001                 0002  0003                      0004
-------                ------- --------                    --------
May Cause....       Important.....  Take madi...........         Do Not Take.......

View 16 Replies View Related

SQL 2012 :: Data Collection Does Not Show Data

May 30, 2014

i am trying to configure data collector on my server. so i configured data collector on server A and setup on server B. but the "Query statistics collection set" do not show me any data.

i right click and select "collect and upload now " item and get success result for this. but in the report i cant see any data...

also in the log page of data collection i see so many errors with messages like this:

"Failed to create kernel event for collection set: {2DC02BD6-E230-4C05-8516-4E8C0EF21F95}. Inner Error ------------------> Cannot create a file when that file already exists."

i tried some solution like disabling and enabling again, re-configuring, removing and configuring again .... but none of them work right.

View 2 Replies View Related

It Will Not Show The Data From The DB

Jan 10, 2007

is have this code, and i know that i have a record with the ID=1 but it will not show the data from the record..<asp:Content ID="Main" ContentPlaceHolderID="ContentPlaceHolderMain" Runat="Server">
<asp:FormView ID="form1" runat="server" DataSourceID="SqlDataSource1"></asp:FormView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnStrAccess %>"
SelectCommand="SELECT [MainID], [MainText] FROM [SiteText] WHERE ([MainID] = ?)" ProviderName="<%$ ConnectionStrings:ConnStrAccess.ProviderName %>">
<SelectParameters>
<asp:SessionParameter DefaultValue="1" Name="SiteMainID" Type="Int32" />
</SelectParameters>

</asp:SqlDataSource>
</asp:Content> Why can't it show the record !??

View 2 Replies View Related

Need To Show Data

Nov 7, 2006

Hello All,

I am using the folliwing sql statement:

execute whs_he_rpt_ds_summary '11/01/05', '11/30/05', '594'


It displays the headers but no information. The date range is obviously a date range and the 594 is a BranchNbr.

How do I see if there is truly any data for this date range.

TIA

Kurt

View 5 Replies View Related

Show Data

Feb 4, 2007

Hi all

I have a data base for some equipment on a few windows application forms written in vb 2005 express. eg Form1 for tools , form2 for nuts &bolts ect.

I wondered if it is it possible to set data base to open when the form loads and shows the data of that particular piece of equipment instead of always opening on equipment id number 1 for instance . For example when form3 loads ,equipment id is set to 3.

Thanks

Rob

View 1 Replies View Related

Matrix Data

Nov 12, 2007

Is there a way in matrix where i can determine if a certain field in my resultset has no value??Thanks

View 1 Replies View Related

Matrix Data

May 6, 2008



I have a stored procedure that give the (sample) data as below.

Country Category State/Province Year Month quantity
Canada cat1 AB 2008 1 10
Canada cat2 BC 2008 2 10
Canada cat3 AB 2008 3 10
Canada cat4 SK 2008 1 10
US cat1 BB 2008 1 20
US cat3 GJ 2008 2 15
US cat4 CO 2008 2 15

When I configure the matrix I EXPECT TO SEE THE FOLLOWING:




AB BC SK
2008 2008 2008
1 3 2 1
________________________________________________________________________

Canada cat1 10
cat2 10
cat3 10

cat4 10




BB GJ CO
2008 2008 2008
1 2 2
________________________________________________________________________

US cat1 20
cat3 15
cat4 15



BUT I AM GETTING THE FOLLOWING RESULT:





AB BC SK BB GJ CO
2008 2008 2008 2008 2008 2008
1 3 2 1 1 2
________________________________________________________________________

Canada cat1 10
cat2 10
cat3 10

cat4 10




BB GJ CO AB BC SK
2008 2008 2008 2008 2008 2008
1 2 2 1 3 2 1
________________________________________________________________________

US cat1 20
cat3 15
cat4 15



In Crystal it automatically displays as above. How do I do this in SRS? Matrix is not showing the state relevant to the country properly. It is showing all the states.

Thank you for your help in advance

View 5 Replies View Related

Cant Show Data From My Database

Jan 6, 2007

HiI have this code, but i can't get it to work, and if i delete <% %> then the if statsment is not working, how do i get this code to work.
 1 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionStringMain %>"
2 SelectCommand="SELECT [SiteMainID], [SiteMainText] FROM [MainSiteText] WHERE ([SiteMainID] = @SiteMainID)">
3 <% Dim pageString As String = "Def"
4 If Not (Request.QueryString("Page") Is Nothing) Then
5 pageString = Request.QueryString("Page").ToString
6 End If
7 If pageString = "Def" Then
8 %>
9 <SelectParameters>
10 <asp:Parameter DefaultValue="1" Name="SiteMainID" Type="Int32" />
11 </SelectParameters>
12 <%
13 Else
14 If pageString = "Page1" Then
15 %>
16 <SelectParameters>
17 <asp:Parameter DefaultValue="2" Name="SiteMainID" Type="Int32" />
18 </SelectParameters>
19 <%
20 Else
21 If pageString = "Page2" Then
22 %>
23 <SelectParameters>
24 <asp:Parameter DefaultValue="3" Name="SiteMainID" Type="Int32" />
25 </SelectParameters>
26 <%
27
28 End If
29 End If
30 %>
31 </asp:SqlDataSource>

View 5 Replies View Related

Query To Show All Data According To ID

Feb 1, 2015

I have a table i need to show data according to id. distinct id and all name should be comma separated against each id.

DECLARE @TBL TABLE (ID NUMERIC(10), NAME VARCHAR(10))

INSERT INTO @TBL (ID,NAME)
VALUES(1, 'A'), (1,'B') ,(1,'C') ,(2,'E') ,(2,'B') , (3,'F') , (3,'G')

output :

id name

1 a,b,c
2 e,b
3 f,g

View 2 Replies View Related

Show Message If No Data

Jan 21, 2008

I'm hoping this is fairly simple to do.

I have a report with many matrices. Basically what I want to do is display a message such as "No History within Date Range Selected" if there is no data on the report (all of the matrices return no data).


Is there a way to determine if the report is returning no data and show a textbox message in that case?

View 1 Replies View Related

Matrix Displaying Data

Oct 1, 2007



I'm sorry if this is a stupid question, but this is my first matrix report.

I am using a stored procedure that generates the following data:

Item Color Size Qty
Shorts Tan 32 0
Shorts Tan 34 2
Shorts Tan 36 2
Shorts Tan 38 0

The matrix displays as follows:
34 36
Shorts Tan 2 2


I would like it to display as follows:

32 34 36 38
Shorts Tan 0 2 2 0

It seems that by default (I used the wizzard to create the report) that the zeros are being suppressed. How can I get them to display?

Thanks

View 7 Replies View Related

Two Data Sets In A Matrix

Mar 13, 2007

Hi

I have a matrix whos colunm group is filed by Dataset1,
now i want to add naother colunm group,but using the Dataset2

can I use two different dataset for a matrix,
for differnt colunm group

please help me in this regards

thanks

View 2 Replies View Related

Matrix - No Data Display NaN

May 6, 2007

Hello,



I have matrix object in reportin (SQL 2005 reporting services)

When in some field have no data it display NaN.

How can I change it ?

I try to use iif(my function = nothing.....) but didn't help

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved