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!

Register Log in
  • Congratulations Rhinorhino 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. rose4567

    Need to show text in the sub-report

    What information is being displayed in the section3a subreport? Does the subreport require any parameters to run? Where in Report1 have you placed section3a? (ie. if you are using a table, is the subreport at the header level, group level, etc.)
  2. rose4567

    Don't want grand totals in table footer on separate page

    Are you conditionally displaying or suppressing groups two and three depending on what paramters are selected? If you select the entire group row and apply suppression, it should also suppress all attributes associated with them (ie. page breaks). Another way to handle the grand totals might...
  3. rose4567

    Passing Two Parameters to a stored procedure

    You might try calling via a subquery. I think this is the easiest way. See copy/paste of code I'm using in one of my reports. Feel free to modify the code for your own use. In my case, the function is set to use two parameters - site_id and stock_item_nbr. You can see how I've called to...
  4. rose4567

    PDF Render Looks Different Than Onscreen Version (SSRS 2008)

    Calibri is not a standard font. Adobe is choking on it and trying to render it down to one of the standard Adobe recognized fonts. Odd that this is happening to you in 2008 where issue is supposed to be fixed. I saw this exact same issue, but in 2005. We installed SP3 and it corrected it...
  5. rose4567

    PDF Render Looks Different Than Onscreen Version (SSRS 2008)

    Also, in terms of installing the font on your server, in some cases you need to open the font on the server (through the font control panel, so you can see the font preview) and then close the preview and reboot the server - apparently this is sometimes needed to 'convince' the system to use the...
  6. rose4567

    PDF Render Looks Different Than Onscreen Version (SSRS 2008)

    Yes. I've seen issues with Adobe render. Font embedding in the PDF render was implemented for SSRS 2008. If you're running SSRS 2005, you will need to install SSRS SP3 to correct the issue. Here's the MSDN article...
  7. rose4567

    Currency-varying decimal places (but always min 2 decimals)

    That's much simpler. Thank you so much!
  8. rose4567

    Adding Dynamic Page Break to Groups

    If you prefer to avoid page breaks you could simply generate two reports, one with page breaks and one without. Create a third report to use as your main report and keep your page break/non page break reports as subreports. Conditionally suppress or display the appropriate subreport based on...
  9. rose4567

    Currency-varying decimal places (but always min 2 decimals)

    ...Here is the code for anyone else running into a similar issue. =iif(Fields!req_item_type.Value <>"I","","$"&iif(Fields!est_unit_cost.Value like "*.00000", FORMAT(Fields!est_unit_cost.Value,"#,##.#####")&".00",FORMAT(Fields!est_unit_cost.Value,"#,##.#####"))) Thanks to everyone who replied!! :)
  10. rose4567

    Adding Dynamic Page Break to Groups

    My apologies RikHess, I think I misread what you are trying to do. I suggest you create a second group and conditionally display or suppress the entire group line based on the "group page break" parameter. For example Group Page Break y/n and your user chooses "Y" they want the page break...
  11. rose4567

    Adding Dynamic Page Break to Groups

    vbcrlf is the standard hard return. Try that instead of char(12).
  12. rose4567

    Currency-varying decimal places (but always min 2 decimals)

    I need to format a currency field. I'm hoping someone can help me craft a format or forumla to display up to five decimal places but always display a minimum of two decimal places since this is currency. Database Value Report Display 35 35.00 35.5...
  13. rose4567

    New to Oracle. Help with Function Syntax

    Interesting. I guess I figured since the actual dollar_cost is 44.09 that's what would display. I didn't think it would round to straight 44. I had tried TO_NUMBER with formatting but it still displayed just the whole number. TO_CHAR in your sample above, however, works. Not sure why I...
  14. rose4567

    New to Oracle. Help with Function Syntax

    ...IV_TRANSACTIONS.STOCK_ITEM_NBR, IV_TRANSACTIONS.UNIT_COST, IV_TRANSACTIONS.QUANTITY, STOCK_ITEM_LOCATIONS.QTY_ON_HAND, QUANTITY*UNIT_COST DOLLAR_COST, SUM(QUANTITY) OVER (PARTITION BY IV_TRANSACTIONS.SITE_ID, IV_TRANSACTIONS.STOCK_ITEM_NBR ORDER BY TRAN_TS)...
  15. rose4567

    Windows &amp; Web Services show as not configured in Configure Reports

    Is IIS configured correctly? By default, the Report Server Web service runs under Network Service in Internet Information Services (IIS) 6.0 and under the ASP.NET account in IIS 5.0. Might be a good idea to start there in your troubleshooting.
  16. rose4567

    New to Oracle. Help with Function Syntax

    ...IV_TRANSACTIONS.STOCK_ITEM_NBR, IV_TRANSACTIONS.UNIT_COST, IV_TRANSACTIONS.QUANTITY, STOCK_ITEM_LOCATIONS.QTY_ON_HAND, QUANTITY*UNIT_COST DOLLAR_COST, SUM(QUANTITY) OVER (PARTITION BY IV_TRANSACTIONS.SITE_ID, IV_TRANSACTIONS.STOCK_ITEM_NBR ORDER BY TRAN_TS)...
  17. rose4567

    New to Oracle. Help with Function Syntax

    OK sorry, still testing. I think that this version of Oracle or TOAD requires different JOIN syntax.
  18. rose4567

    New to Oracle. Help with Function Syntax

    ...iv_transactions.stock_item_nbr, iv_transactions.UNIT_cost, iv_transactions.QUANTITY, STOCK_ITEM_LOCATIONS.QUANTITY_ON_HAND, QUANTITY*UNIT_cost DOLLAR_COST, SUM(QUANTITY) OVER (PARTITION BY iv_transactions.SITE_id, iv_transactions.stock_item_nbr ORDER BY tran_ts)...
  19. rose4567

    New to Oracle. Help with Function Syntax

    This is running against Oracle 10g database, but I am trying to create the view through TOAD (no laughing). Perhaps that's my problem? Adding "AS" took care of that error, but now it's throwing the following error and this doesn't make sense to me why it would be complaining about...
  20. rose4567

    New to Oracle. Help with Function Syntax

    ...iv_transactions.stock_item_nbr, iv_transactions.UNIT_cost, iv_transactions.QUANTITY, stock_item_locations.QUANTITY_ON_HAND, QUANTITY*UNIT_cost DOLLAR_COST, SUM(QUANTITY) OVER (PARTITION BY iv_transactions.SITE_id, iv_transactions.stock_item_nbr ORDER BY tran_ts)...

Part and Inventory Search

Back
Top