Search results for query: *

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.)

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...

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...

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...

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...

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...

That's much simpler. Thank you so much!

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...

Unfortunately, I could use a set format with "#,###.#####" because the the currency value is 36.00000 it displays as 36. That format drops all zeros. However, I can use it in conjunction with an iif statement to say if it found 36.00000 to display 36.00 otherwise, use the format "#,###.#####"...

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...

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

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...

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...

Hey guys, So I am testing and for some reason the DOLLAR_COST and RUNNING_TOTAL fields loose their formatting when selected from the second "temp table." I am not sure if I need to define the fields in my create view statement or if I need a format mast in the second select statement. Here's...

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.

IT WORKS! Thank you SO much Tharg!! My version of Oracle did not like the outer join statement. I needed to join in the WHERE clause. I'm going to paste the end result in case anyone else is running into version issues and references this thread. I want to say thank you again - a thousand...

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

Here's the whole body of code. Keep in mind for me that quantity_on_hand is coming from another table so I need to perform an outer join. I don't see why that would have any effect on the query. I should be able to perform a select statement and join two tables. I also tried cutting the...

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...

I restructured for this version, but I'm having trouble using the "WITH" clause. I get the following error: ORA-00905: missing keyword Here's the code. In this version of Oracle you have to list the fields you want created. The "With temp_tble AS" line it where it hits "WITH" and throws the...