Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MisterMo

    IIF statement does not work as anticipated

    =iif(Fields!db_bud_desc_line1.Value = NOTHING ,Fields!a_account_desc.Value,Fields!db_bud_desc_line1.Value) SSRS way to read null value fields -Mo If you don't stand for something, you'll fall for anything
  2. MisterMo

    How to segment/group data

    just nest the query into another select statement eg: select sum(case when col1 in 'acc10','Acc11' then col2+col3+col4 else 0 end) as Gr1, sum(case when col1 in 'acc11','Acc12' then col2+col3+col4 else 0 end) as Gr2, sum(case when col1 = 'acc30' then col2+col3+col4 else 0 end) as Gr3 from...
  3. MisterMo

    Date Parameter List Formatting

    i think that the problem should fix itself as soon as you deploy the report. any attempt to work with dates on the developement platform almost always fail, I am still forced to test data by entering 1/1/2008 or 3/3/2008 so that when the month and day swap places(american format) it does not...
  4. MisterMo

    Selection Criteria Parameter double-trouble

    try something like this declare @DateType varchar(20), @Flag int, @StartDate datetime, @EndDate datetime set @DateType = 'DueDatess' set @StartDate = '2001/01/01' set @EndDate = '2002/02/02' if @DateType = 'DueDate' set @Flag = 1 else set @Flag = 2 select PurchaseOrderID...
  5. MisterMo

    Data-driven subscription emails

    just an idea, What about sending the report to a single email and them have a policy set on that email to forward the report to whoever you wish to.... as I said Just an Idea -Mo If you don't stand for something, you'll fall for anything
  6. MisterMo

    about stored procedure

    because yoy set the no count on the last teransaction only will be returned by the stored procedure which is an update, you might be able to see stuff in SQL but reporting needs a dataset to work with, add a select statement as the last statement of the stored proc to return whatever data it is...
  7. MisterMo

    Program freezing

    I am not 100% sure that this would work because you have declared t1,t2,t3 and then keep on referencing t2 and t3 and redeclaring t1 and every statement. I would also wrap the statement in a view or stored procedure because is a heck of a statement with more than 60 queries to pass in RS. it...
  8. MisterMo

    HELP!!How to separate comma and space??

    sorry but your logic is quite confusing 1) your function should return a string but you want to return an array 2) you have a return inside the loop without exit function and that will break the code 3) I can only assume that you want to read the array, remove commas(,), (:) and (.). And then...
  9. MisterMo

    Server security problem

    if that's the case you can remove those keys from RS Manager -Mo If you don't stand for something, you'll fall for anything
  10. MisterMo

    HELP!!How to separate comma and space??

    Sorry but what exactly do you mean with array? How do you want the data to be displyed? could you be more specific? -Mo If you don't stand for something, you'll fall for anything
  11. MisterMo

    HELP!!How to separate comma and space??

    or replace(replace("0100000, 0201T00, 0301T00, 0401T00"," ",""),",", vbCRLF) -Mo
  12. MisterMo

    HELP!!How to separate comma and space??

    replace("0100000, 0201T00, 0301T00, 0401T00", ",", vbCRLF) -Mo
  13. MisterMo

    Column repeating on same page (like in Excel)

    As I said before if you have set the report properties right it will do exactly what you want. Body Properties: Columns = 2 0r 3 depending on how much space you have ColumnSpacing = .5 space between columns if this is right you will see your table on one column and the other column/s will be...
  14. MisterMo

    Server security problem

    try and log from SQL server and see if you get the same problem -Mo
  15. MisterMo

    Server security problem

    Visual Studio and RS are two different things they might connect to the same database but that's it. if the services is running check that a domain Admin user is actually running such service. another thing worth checking is if IIS is still working properly, sometime stop and re-start...
  16. MisterMo

    Column repeating on same page (like in Excel)

    because reports are displayed on a browser you might lose some of the pagination feature when viewing the report. The default view in Visual Studio when you're designing reports is also browser like. however another option you have is to see the reports in print view and from there (depending...
  17. MisterMo

    Column repeating on same page (like in Excel)

    Hi if you have created the report properly just run and refresh the data and all should work just fine there is no other code to write its one of the basic functions of RS -Mo
  18. MisterMo

    filter on group count

    you could do in your SQL script, if you give some more info I could have look -Mo
  19. MisterMo

    Export to Excel

    I have noticed that when you export to excel if you have header, footers and/or group slightly offline it will create merged cells which are a pain to work with. it could be that what causes the error lays in the way the report is formatted. When I create a report that has to be exported to...
  20. MisterMo

    Using a multi-value parameter and want to put All in the header

    hi rogerzebra, the way I use multi values is this: @MultiParam string Multivalue option checked. Value could be from select statement or you add the values manually. @MultiParamList string hidden value: =Join(Parameters!MultiParam.Value,", ") default value: non quered =...

Part and Inventory Search

Back
Top