Data outside parameter field

Can any body help me that how to get data (opening balance) of an account in report wich showing data in between specific dates. The opening balance will be the values before the parameter fields.Use Sub report to show the Opening Balance. So create a sub report without using parameters, just show the opening balance and dont link the sub report and main report.

In the sub report created a formula, "sub_op"

WhilePrintingRecords;
Shared x As Number
x = Opening Balance

and in the main report create a formula, "main_op"

WhilePrintingRecords;
Shared x as number

Use this formula in the main report to show Opening Balance. Important thing is place the subreport in the header before using the main_op formula, so that subreports gets executed first and will show the Opening Balance value in the main report.|||But if I want to get opening balance for a specific date then I have to pass a parameter for that.

So, if the I could not insert the subreport at header then what could be the solution.

Thankyou|||First I agree with khs_shankar that a subreport for the OpeningBalance is the way to go.

If you want to select date(s) for OpeningBalance independent from the the main report parameter field, then create parameter field(s) in both main & subreport, say Op_date1 (& Op-date2?). In your subreport, use these dates as a filter. Link the main & subreport by these Op_ parameter fields so you can pass the values.

If the Opening Balance are for the dates prior to your main parameter field, like a cut off date to show previous balance & details afterwards, then you can create a parameter field in your subreport, say Op-date. Link the parameter field in the main report with the Op-date field in the subreport. Use this Op_date field as a filter in the subreport.

Hope this help.|||I want to alter my question here.

The Opening balance must be of the current month and les then by the date which is selected by user.

Because I have tried "thg's" logic but when I want to link parameter main report with the Op_date of sub report, it does not show the op_date field in link combo.

Help in this regard.

Data formatting problem

Hello,

I'm looking for solutions to a formatting problem.

I have two stand alone textboxes on a report body that I would like to have display side by side with very little white space between them.

Example: TextBox 1 contents (variable length) = "Muddy Waters"

Textbox 2 contents (variable length) = "B.Sc"

Current display:Muddy WatersB.Sc

Desired display:Muddy Waters B.Sc

Here is my problem.

Simple concatenation of values into 1 textbox would work if the font size and font family were the same for both textboxes; unfortunately this isn't the case. The font size and family for each textbox is different. Is there a richtext control I can place on the report and load with preformatted rich text?

Any suggestions would be appreciated.

Thanks,

Roy M

Hi,

Try making the first textbox right-aligned & the second textbox left-aligned. It might possibly solve your problem.

Just an idea

-Aayush

|||

1.Put both of the textboxes adjacent to each other .

2.Apply Font size and style.

3.Use Padding left for the second text box.

Hope this will solve your problem.

|||Thanks, but this won't work as I need to keep things left aligned.|||

Do they have to be separate textboxes? The easiest thing would be to replace the two with a single one, replacing the content with the values from both fields as follows:

Code Snippet

=Fields!Field1.Value & " " & Fields!Field2.Value

If your textboxes are in a table, select them both and right click for the context menu and choose 'Merge Cells' and do the same.

Good luck,

Larry|||

This won't work as the text formatting for both fields needs to be different.

Thanks anyway.

Data formatting problem

Hello,

I'm looking for solutions to a formatting problem.

I have two stand alone textboxes on a report body that I would like to have display side by side with very little white space between them.

Example: TextBox 1 contents (variable length) = "Muddy Waters"

Textbox 2 contents (variable length) = "B.Sc"

Current display:Muddy WatersB.Sc

Desired display:Muddy Waters B.Sc

Here is my problem.

Simple concatenation of values into 1 textbox would work if the font size and font family were the same for both textboxes; unfortunately this isn't the case. The font size and family for each textbox is different. Is there a richtext control I can place on the report and load with preformatted rich text?

Any suggestions would be appreciated.

Thanks,

Roy M

Hi,

Try making the first textbox right-aligned & the second textbox left-aligned. It might possibly solve your problem.

Just an idea

-Aayush

|||

1.Put both of the textboxes adjacent to each other .

2.Apply Font size and style.

3.Use Padding left for the second text box.

Hope this will solve your problem.

|||Thanks, but this won't work as I need to keep things left aligned.|||

Do they have to be separate textboxes? The easiest thing would be to replace the two with a single one, replacing the content with the values from both fields as follows:

Code Snippet

=Fields!Field1.Value & " " & Fields!Field2.Value

If your textboxes are in a table, select them both and right click for the context menu and choose 'Merge Cells' and do the same.

Good luck,

Larry|||

This won't work as the text formatting for both fields needs to be different.

Thanks anyway.