Blank spaces

How can I pass blank spaces for Required fields into database from Forms as
Initial Value , On insert , Post insert options does not work.
Thanks- HAVE YOU TRIED SETTING THE SETTING THE DEFAULT VALUES ON THE FIELDS?

-DO THEY HAVE TO BE SPACES? WOULD 'NULL' VALUES WORK?|||Originally posted by edwinjames
- HAVE YOU TRIED SETTING THE SETTING THE DEFAULT VALUES ON THE FIELDS?

-DO THEY HAVE TO BE SPACES? WOULD 'NULL' VALUES WORK?

1. Forms will not take blank spaces as it will truncate it for varchar2 fiedls .

2. All fields are required.

3. Assigning it from triggers have different problems of record locking.

Blank Pages following report

I have a report that uses 7 subreports. Some reports show, some don't
depending on the data received from the Shared Datasource. My initial report
appears fine in the viewer, however I have a single page following the last
page with data containing only the header. When I create a pdf, I have 4
pages at the end with only headers. The main report and the first subreport
should be the only ones outputting data.
Ideas?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1I have found my problem, but no solution. When the subreports run, they are
given "space" on the report even if their visibility is set to False. This
is what is generating my "blank pages". This poses a new and even uglier
issue for me, What Now? My requirements are to have a single report that
gives alternate data depending on the needs of the user. I have two ideas:
1) Can I manually launch a subreport in code WITHOUT navigating away from
the parent report?
2) Is it possible to dynamically add a Subreport to the main report via VB
Code so only the subreports needed are run?
I am researching both avenues, but any advice you could offer would be WELL
received!
Rick wrote:
>I have a report that uses 7 subreports. Some reports show, some don't
>depending on the data received from the Shared Datasource. My initial report
>appears fine in the viewer, however I have a single page following the last
>page with data containing only the header. When I create a pdf, I have 4
>pages at the end with only headers. The main report and the first subreport
>should be the only ones outputting data.
>Ideas?
Message posted via http://www.sqlmonster.com|||I am also running into the same issue and finding no solution. Any help is
appreciated.
"Rick via SQLMonster.com" wrote:
> I have found my problem, but no solution. When the subreports run, they are
> given "space" on the report even if their visibility is set to False. This
> is what is generating my "blank pages". This poses a new and even uglier
> issue for me, What Now? My requirements are to have a single report that
> gives alternate data depending on the needs of the user. I have two ideas:
> 1) Can I manually launch a subreport in code WITHOUT navigating away from
> the parent report?
> 2) Is it possible to dynamically add a Subreport to the main report via VB
> Code so only the subreports needed are run?
> I am researching both avenues, but any advice you could offer would be WELL
> received!
> Rick wrote:
> >I have a report that uses 7 subreports. Some reports show, some don't
> >depending on the data received from the Shared Datasource. My initial report
> >appears fine in the viewer, however I have a single page following the last
> >page with data containing only the header. When I create a pdf, I have 4
> >pages at the end with only headers. The main report and the first subreport
> >should be the only ones outputting data.
> >
> >Ideas?
>
> --
> Message posted via http://www.sqlmonster.com
>|||Has Microsoft any answer to this problem as this is something has been faced
by many people and doesnt seem to find any solution.
Setting page size and margine is one part of avoiding blank pages but with
sub reports, it not only introduce blank pages and sometimes change the whole
look of the report.
"manish" wrote:
> I am also running into the same issue and finding no solution. Any help is
> appreciated.
> "Rick via SQLMonster.com" wrote:
> > I have found my problem, but no solution. When the subreports run, they are
> > given "space" on the report even if their visibility is set to False. This
> > is what is generating my "blank pages". This poses a new and even uglier
> > issue for me, What Now? My requirements are to have a single report that
> > gives alternate data depending on the needs of the user. I have two ideas:
> >
> > 1) Can I manually launch a subreport in code WITHOUT navigating away from
> > the parent report?
> >
> > 2) Is it possible to dynamically add a Subreport to the main report via VB
> > Code so only the subreports needed are run?
> >
> > I am researching both avenues, but any advice you could offer would be WELL
> > received!
> >
> > Rick wrote:
> > >I have a report that uses 7 subreports. Some reports show, some don't
> > >depending on the data received from the Shared Datasource. My initial report
> > >appears fine in the viewer, however I have a single page following the last
> > >page with data containing only the header. When I create a pdf, I have 4
> > >pages at the end with only headers. The main report and the first subreport
> > >should be the only ones outputting data.
> > >
> > >Ideas?
> >
> >
> > --
> > Message posted via http://www.sqlmonster.com
> >|||This is a good question, I see this issue often on many boards I post to. In
this case, it was my error. I was setting sub reports to hidden, however the
Rectangle they were in were not being set to hidden. Hence the blank pages.
When I set the Rectangle to invisible, it works like a charm. If you run
into this issue, I suggest you look at the container you placed your Sub
Report in, that just might be your error.
manish wrote:
>Has Microsoft any answer to this problem as this is something has been faced
>by many people and doesnt seem to find any solution.
>Setting page size and margine is one part of avoiding blank pages but with
>sub reports, it not only introduce blank pages and sometimes change the whole
>look of the report.
>> I am also running into the same issue and finding no solution. Any help is
>> appreciated.
>[quoted text clipped - 22 lines]
>> > >
>> > >Ideas?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200511/1|||Also, if you set the subreport (or its container) to be invisible
conditionally, any pagebreaks selected for that subreport or container
will be ignored. For me, it is a really anoying "feature".

Blank data in initial page of report

I guess you could say I'm a CR novice, but so far I've been able to develop a few report systems using CR as the front-end formatter. I'm currently working on the implementation end of the cycle and I'm experiencing an issue that didn't come up in the development of the prototype: the first page is blank.

When building the first report (eventually I'll have to build one for each of our clients, dozens in total), the first page was almost entirely blank. The header was almost intact, except for the client name (present in the Excel workbook serving as my datasource) not populating where I placed the field. Underneath, only the field headings display. The group heading doesn't show, though it is present on mouse-over, and all the details fields are blank.

On the second page, however, everything looks as it should: The group heading is displayed, and all the correct data show up in their respective fields. I'm pulling data from an Excel spreadsheet that I quadruple-checked to be accurate, and running CR XI. Any ideas?Please check whether the "Keep group together" property for any group is checked or unchecked.

If it is checked then uncheck it.

For this you have the right click on group => click change group

on property tab this option is available just uncheck it.