reporting services - LookUpSet - Group By -

-

i have 2 databases:

database1 on server1 database2 on server2

i create table gives me small example result below:

name       |  date        | total name1         10/04/2014    125,101 name1         11/04/2014    125,101 name2         10/04/2014    2,5 name2         11/04/2014    2,5

so database1 on server1 date , name values.

i total column using following expression on 'total' textbox field looksup total database2 on server2:

=join(lookupset(fields!col1.value, fields!col1a.value, fields!totalcol.value, "datasetserver2"),",")

obviously want following results:

name       |  date        | total name1         10/04/2014    125 name1         11/04/2014    101 name2         10/04/2014    2 name2         11/04/2014    5

is possible? if further information needed let me know, apologies have never used lookupset.

additional info:

dataset2 used query database1 on server1 create table , example data is:

date        | col1    | name 10/04/2014    uid01     name1 11/04/2014    uid01     name1 10/04/2014    uid02     name2 11/04/2014    uid02     name2

the following dataset used query database2 on server2

date        | totalcol   | col1a 10/04/2014    125          uid01 11/04/2014    101          uid01 10/04/2014    2            uid02 11/04/2014    5            uid02

with sample datasets:

enter image description here

enter image description here

i have created simple table based on first dataset:

enter image description here

the expression is:

=lookup(fields!col1.value & fields!date.value     , fields!col1a.value & fields!date.value     , fields!totalcol.value     , "datasetserver2")

you'll note i'm comparing fields!col1.value & fields!date.value fields!col1a.value & fields!date.value in first 2 parameters here. can pass expression, doesn't have 1 column. expression i've used give unique lookup comparisons require.

since we're getting unique rows, lookupset can replaced lookup.

this gives required results:

enter image description here

you need find way make lookup unique, i.e. combination of col , date. use calculated field in dataset.


Comments

Post a Comment

Popular posts from this blog

windows - Single EXE to Install Python Standalone Executable for Easy Distribution -

-
i used pyinstaller create standalone exe file pyqt project. did not use single file option because exe created single file option takes long open. therefore, pyinstaller created dist folder contains bunch of files including program.exe file. create setup.exe file place contents of dist folder in program directory , create shortcut in start menu , on desktop. want super simple user. maybe setup.exe files when download program cnet. found inno-setup, looks promising. however, not know if there special considerations because program standalone program create python/pyqt program. thanks! have experience task? there program using task not know about? inno-setup or nsis easiest use. tell them files include , put them , create nice installer you. wrote short tutorial on experiences using innosetup might find helpful: http://www.blog.pythonlibrary.org/2008/08/27/packaging-wxpymail-for-distribution/ note tutorial based around wxpython app wrote, concepts same.
Read more

c# - Access objects in UserControl from MainWindow in WPF -

-
i have simple xaml, how can change text property of textblock in usercontrol1 mainwindow ? <window x:class="refactorxaml.mainwindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:refactorxaml="clr-namespace:refactorxaml" title="mainwindow" height="350" width="525"> <grid> <grid.rowdefinitions> <rowdefinition height="100"></rowdefinition> <rowdefinition height="100"></rowdefinition> </grid.rowdefinitions> <grid> <refactorxaml:usercontrol1></refactorxaml:usercontrol1> </grid> <grid grid.row="1"> <button>change text</button> </grid> </grid> </window> <usercon...
Read more

javascript - How to name a jQuery function to make a browser's back button work? -

-
i'm trying write function ajaxyfy web site, works perfect, except function button. that's have now: function loading() { if (typeof history.pushstate !== "undefined") { var historycount = 0; $('.menu-item, .logo').on('click','a',function(e){ e.preventdefault(); $(this).data('clicked', true); if ($(this).is('.logo a')) { var homepage = $(this).attr('href'); function1(homepage); history.pushstate(null, null, homepage); } else if ($(this).is('.projects a')) { var projects = $(this).attr('href'); function2(projects); history.pushstate(null, null, projects); } else { var pages = $(this).attr('href'); function3(pages); history.pushstate(null, null, pages); ...
Read more