HI,
Does Reporting support the Oracle 11g, 10g or 9i databases. if yes, then kindly provide databinding etc samples for the same.
Regards,
Sohail Kazmi
Hi Sohail,
I'm attaching to this post an example showing how to implement a variable for changing the printing style. It's a very simple report, using a background and a couple of controls with text, just to show you the idea.
In order to use it, just add it to your Visual Studio project, open it and go to the "Preview" tab. The report viewer will prompt the parameter window so you can specify the rendering mode. First type "PREVIEW" in the RenderMode textbox and then click "Submit". The rendered report will look like the following:
Next you can change the parameter value to "PRINT", and click "Submit" again. Then the rendered report will look like the following:
Once it's rendered using the printing colors, just click "Print" and it will be printed like that.
When you edit this report you will notice that it has a string parameter named "RenderMode". If you look at the properties for each section, you will see that the Background property is not a color, but a bound value, like this:
=If(Parameters.RenderMode = "PRINT", "White", "DarkBlue")
This binding could be interpreted as "use White color if we are in PRINT mode, else use DarkBlue color". On the other hand, if you look at the label properties in the report, you can see that the Foreground property has the following binding:
=If(Parameters.RenderMode = "PRINT", "Black", "White")
Which means "use Black color if we are in PRINT mode, else use White color".
I hope this helps you.
Luis
Hi Luis,
Thanks for suggestion, kindly provide some sample code for the same, so that it will be really helpful to me.
Sohail Kazmi.
As of version 2011.2 of Reporting there's no way to tell, in render time, if the system is previewing a report or printing it. But it doesn't stop you from creating your own parameter in the report to indicate this. For example, you could create a string parameter named "RenderMode", and bind the background to a conditional format. Something like:
=If(Parameters.RenderMode = "PRINT", "White", "<my color for preview>")
The foreground property should be bound similarly to the parameter, but using black for printing mode.
If you take this approach, you will need to specify the parameter as "PREVIEW" when you want to preview the report. Later on you would set it to "PRINT" and render the report again when you want to print, so it gets drawn with the printing colors.
Thanks, at-least can i print the report in white background and black foreground despite of the same will be in color at preview.
1. In order to do this, you can set the "InsertPageBreakBefore" property of the Group Header section to true. Then it will start to render each group in a new page. Alternatively, you can set the Group Footer section property "InsertPageBreakAfter" (or in the Group Body if you don't use a footer), which would have the same effect.
2. Currently we don't have a way of defining different styles at runtime or printing time.